Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
People,
I have a workbook with 150 sheets, being each one a form of a little research i've made with some clients. Now, i want to put all that information in a single sheet, making a line per sheet and a col. per info i want. By the way, all the 150 sheets are equal and obey a singular name (like, FORM (1), FORM (2), FORM (3), ..., FORM (150)). For example, my sheets have three relevant informations: my client's name, his phone number and his e-mail. so, i've put in my "Results Sheet" 4 columns: 1 for the sequential number (1, 2, 3, 4, 5, etc.), 1 for the name, 1 for the phone and 1 for the e-mail. Then, i've linked the first line with the apropriate cell on the FORM (1) sheet. Beautiful. But now, i want to do the same thing to the other 149 sheets and, of course, don't wanna do it manually. Could u people give a little world of advice, plz?? Thx a lot! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data exctraction from multiple sheets | Excel Discussion (Misc queries) | |||
Summary Sheet help with multiple sheets | Excel Discussion (Misc queries) | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
Selecting Last Sheet | Excel Worksheet Functions | |||
Compare 2 Sheets and Extract Unique Info to a 3rd Sheet | Excel Discussion (Misc queries) |