I am trying to create a spreadsheet that pulls data into a form (actually another workbook). Which row of data is imported is dependant on a single integer input on the new workbook.
For example, I want cell Book2!A2 to display the data shown in Book1!A4 so the formula needs to read the integer, which will be 4 so it knows to imput data from A4 and not A?
Basically, how do I tell exel to get it's data from Book1, RowA, CellX (4 in this case)
Adam F
Solaris System Administrator
For example, I want cell Book2!A2 to display the data shown in Book1!A4 so the formula needs to read the integer, which will be 4 so it knows to imput data from A4 and not A?
Basically, how do I tell exel to get it's data from Book1, RowA, CellX (4 in this case)
Adam F
Solaris System Administrator