Hello, I want to reference data from every other cell from one workbook into another.
For example, This is the forumla that I have in cell A1:
='S:\Payroll\2011\[Crew Time by Day of Week 1.15.11.xls]NE CORP'!$A$42
In Cell B1, I want the formula to say:
='S:\Payroll\2011\[Crew Time by Day of Week 1.15.11.xls]NE CORP'!$C$42
However when i drag the fomula across row 1, it autofills the exact same formula that is in A1 without changing the referenced cell at all.
How can I do this? I am in somewhat of a time crunch since this is a report I am doing for my boss. I appreciate any tips. Thank you.
The reference you are using is absolute so you need to remove the $ to make it change relatively as you drag it:
='S:\Payroll\2011\[Crew Time by Day of Week 1.15.11.xls]NE CORP'!A42
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks