Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pulling info from multiple sheets
I have 55 sheets in my file. I have one page that I am collecting data from
other sheets. So on the individual sheets I will have the same data for different dates in cells C7 C14,C21,C28,C35,C42 and so on. On the sheet I am collecting data I will have a list of the indidvidual sheets and columns labeled with the individual data to be collected there. What I need assistance with is this: If on first row of my collection sheet I pull info from sheet #1 C7,D7,E7,F7, AND G7 and I would like on the same row to then pull from the same sheet C14,D14,E14,F14 and G14, and then C21,D21,E21,F21, and G14 and so on and so on. How do I copy and paste my formulas? Can I increment a formula so when I copy it to a different rows it will automatically increment the formula to pull data from the next sheet? Don't know if it possible, but it woul sure save me time. -- Thank You & God Bless, Jimenda |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pulling info from multiple sheets
Have you tried using the 'paste special' options? It allows you to paste formulas. HTH. Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=495843 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pulling info from multiple sheets
Hi Jimenda
Try this http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jimenda" wrote in message ... I have 55 sheets in my file. I have one page that I am collecting data from other sheets. So on the individual sheets I will have the same data for different dates in cells C7 C14,C21,C28,C35,C42 and so on. On the sheet I am collecting data I will have a list of the indidvidual sheets and columns labeled with the individual data to be collected there. What I need assistance with is this: If on first row of my collection sheet I pull info from sheet #1 C7,D7,E7,F7, AND G7 and I would like on the same row to then pull from the same sheet C14,D14,E14,F14 and G14, and then C21,D21,E21,F21, and G14 and so on and so on. How do I copy and paste my formulas? Can I increment a formula so when I copy it to a different rows it will automatically increment the formula to pull data from the next sheet? Don't know if it possible, but it woul sure save me time. -- Thank You & God Bless, Jimenda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
Select Multiple sheets | Excel Discussion (Misc queries) | |||
Formulas for Multiple sheets in a workbook | Excel Discussion (Misc queries) | |||
How am i able to populate a sumation for multiple sheets | Excel Worksheet Functions | |||
Matching Multiple Sheets | Excel Worksheet Functions |