Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data from multiple sheets
Hi,
This is my first post. Hope you can help. I have a form that has been copied 100 times in 100 sheets. I also have a data sheet that i require to only show parts of each form. Example: Name Date Cost Ref Number How can i do this quickly without going int each page for the info. I tried dragging the original formuler but it changes the cell and not the sheet. I need the cell to stay the same but the sheet to change. Hope that makes sense |
#2
|
|||
|
|||
Document Attached
I have attached the file i am working on.
Sheet 1 (Data) should display the data from all the other sheets as named in column A. I have done the first sheet manually but would like to create 50 blank sheets and get the information as i fill them in automaticly. Is this possible and if so how. I tried to drag each formula down but it leaves the sheet name the same and progresses the cell. Also where i have merged cells the info just does not show up. Just returns (VALUE) Thanks again for your time. The Jackal Last edited by the-jackal : February 16th 06 at 09:28 AM Reason: Adding File & Description |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
how do i find data in multiple sheets in excel | Excel Discussion (Misc queries) | |||
how do i find data in multiple sheets in excel | Excel Worksheet Functions |