R
Rita
Please Help!!!
I have linked to workbooks the linking workbook has specific worksheets
in it. What I need to do is change the row from the worksheet when I
copy to a new column in the linking workbook without changing the
"worksheet name"
link looks like this
ie: '[gravel.xls]sand'!$L$20*G4
Workbook = gravel
Worksheet = sand
L20 = Column and row of above
*G4 = Column and row of current workbook
What I would like to do next is have excel lookup the next set of
totals from column "L" changing the row only.
Is this possible??
So far I have gone in the worksheet did a copy paste the manually
changed the row.
Thank You
Rita
I have linked to workbooks the linking workbook has specific worksheets
in it. What I need to do is change the row from the worksheet when I
copy to a new column in the linking workbook without changing the
"worksheet name"
link looks like this
ie: '[gravel.xls]sand'!$L$20*G4
Workbook = gravel
Worksheet = sand
L20 = Column and row of above
*G4 = Column and row of current workbook
What I would like to do next is have excel lookup the next set of
totals from column "L" changing the row only.
Is this possible??
So far I have gone in the worksheet did a copy paste the manually
changed the row.
Thank You
Rita