i'm trying create spreadsheet reorder lot of data, different source sheet every day. have created templates in numbers 2009 , excel 2011, both suffer same unhelpful helpfulness. either that, or i'm going in wrong way.
original worksheets in same stupid, cluttered format, same name "jumpering schedule". have created worksheets use =offset cherry pick relevant data "jumpering schedule" , place in "prejumpering" , "changeovers".
"jumpering schedule" sheet in new workbook, downloaded intranet every day. copy sheet, , paste workbook template "prejumpering" , "changeovers" sheets.
every formula in "prejumpering" , "changeovers" refers "jumpering schedule" has !ref error - assume because original version of "jumpering schedule" no longer there. can correct each formula in turn, it's time consuming.
how can make refer whatever sheet has name, rather specific sheet wants use?
i'm trying without using macros, because i've had problems before transferring them between mac , work vista laptop, , don't know enough them understand error message.
howdy. time reference workbook closed, run problem. in order go direction, require more information want accomplish. might visit 1 of premier excel sites:
mr. excel
vba express
Forums Macs Mac Apps and Mac App Store
- iPhone
- Mac OS & System Software
- iPad
- Apple Watch
- Notebooks
- iTunes
- Apple ID
- iCloud
- Desktop Computers
- Apple Music
- Professional Applications
- iPod
- iWork
- Apple TV
- iLife
- Wireless
No comments:
Post a Comment