I tried to enter formulas in each cell and I am getting so confused.
Each column is getting the value from another workbook that contains two sheets of data using a formula such as:
The problem is, every workbook is different so entering formulas each time is really time consuming.
What is the best way to do this?
I have named S3 as the Workbook that I am trying to autofill the cells with the data from Workbook.xlsx Sheets1 (S1) and Sheet2 (S2).
Still with me?
OK, so here are the requirements.
S3 B7 = S1 B7
S3 G7 = S2 C1
S3 I7 = S1 B7
S3 J7 = S2 C2
S3 P7 = S2 G4
S3 Q7 = S2 G5
S3 U7 = S2 G7
S3 V7 = S2 H7
S3 AB7 = S2 I20
S3 AC7 = S2 J20
How do I do this?
I am still too new to figure out how to do this.
Help please?
Thanking you in advance!!!
Each column is getting the value from another workbook that contains two sheets of data using a formula such as:
Excel Formula:
='G:\Documents\[filename.xlsx]Sheet2'!$C1
What is the best way to do this?
I have named S3 as the Workbook that I am trying to autofill the cells with the data from Workbook.xlsx Sheets1 (S1) and Sheet2 (S2).
Still with me?
OK, so here are the requirements.
S3 B7 = S1 B7
S3 G7 = S2 C1
S3 I7 = S1 B7
S3 J7 = S2 C2
S3 P7 = S2 G4
S3 Q7 = S2 G5
S3 U7 = S2 G7
S3 V7 = S2 H7
S3 AB7 = S2 I20
S3 AC7 = S2 J20
How do I do this?
I am still too new to figure out how to do this.
Help please?
Thanking you in advance!!!