thebigtable
asked on
Excel , puilling infor from several worksheets
I would like to pull information from a series of cells in a row and update a series of cells in a columns on another worksheet.
See attached
Populate sheet 1, COL B with information from sheet 2 ROW 2
Cheers
Q1-sample-file.xls
See attached
Populate sheet 1, COL B with information from sheet 2 ROW 2
Cheers
Q1-sample-file.xls
There are no dates in sheet 2?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What if I don't have a column header?
which sheet?
ASKER
sheet 2
=INDIRECT(ADDRESS(1,ROW()- 1,,,"Sheet 2"))
ASKER
Use the first formula. It is not affected by any data in row 1
ASKER
=INDIRECT(ADDRESS(2,ROW()- 1,,,"Sheet 2"))
This is your formula,
if the ROW number is different than in my sample will I need to change something?
The information on sheet 2 will start at E7
and be put in C5
What am I missing?
This is your formula,
if the ROW number is different than in my sample will I need to change something?
The information on sheet 2 will start at E7
and be put in C5
What am I missing?
2 is the row number. You can change it to any other number. Change the 1 in row()-1 to modify the column.
If your data starts in E7 then use
=INDIRECT(ADDRESS(7,ROW()+ 3,,,"Sheet 2"))
If your data starts in E7 then use
=INDIRECT(ADDRESS(7,ROW()+
You can make life simpler by using
=INDIRECT(ADDRESS(ROW('She et 2'!$E$7),ROW()+COLUMN('She et 2'!$E$7)-2,,,"Sheet 2"))
and only changing the two $E$7 to whatever your first cell is.
=INDIRECT(ADDRESS(ROW('She
and only changing the two $E$7 to whatever your first cell is.
ASKER
I had to change the -2 to a -5 for it to pull from E7
Here is the actual file
-2012-Budget-without-PW.xls
Here is the actual file
-2012-Budget-without-PW.xls