A1=AB B1=CD C1= -
A2=GH B2=EF C2 = LM
A3= - B3= IJ C3= -
Sheet 1
A1=AB
A2=CD
A3=EF
A4=GH
A5=IJ
A6=LM
Sheet 2
Hello,
I am trying to write a financial model where I have 90 inputs exactly the same that has an effect on sheet 2 which have identical layouts. I have gave an example of one above.
Is there anyway to use an offset to that I can once I make 'sheet 2' A1 cell equal AB and that CD could be referenced to sheet 1 from the newly referenced AB using a nested offset command?
'Sheet 2'A1 would equal ='Sheet1 A1'
'Sheet 2'A1 would equal =A1(offset,-1,1) so that it will equal CD (this does work it only offsets on sheet 2)
I could manually link the values to sheet2 manually but the model will have 25 links in each iteration and there is 90 different products to map.
I had thought about generating a separate table to make a Vlookup table and that will also take time, I was hoping that with one reference to the sheet1 table all others could be automated with an Offset command or anything else so that one reference would be the key to the rest. this would allow for the sheet2 90x tables to be copy and pasted with just 1 link/reference required so that the tables would then know where to look.
I hope there are some wizzes out there to help. thank you for your time and good look with the puzzle. Many thanks and I hope to hear from someone soon. (Excel 2007)
I have attached an example (Excel 2010) but my work in is Excel 2007. Thank you to anyone who can help.
Bookmarks