| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling data from different sheets
On sheet1 I have an overview of sheet2:sheet10. Sheet2 has a different
number of data entries than sheet3 and so on. What is the best way of pulling that data from each sheet but only from the rows that have data? Here is the formula in A4: =IF(Topps!$H3<1,Topps!A3,"") I've copied that down my sheet, but there are only 30 entries on sheet Topps. How can I start pulling data from the next sheet once the 30 rows are pulled from sheet Topps? I've done a COUNTIF for each sheet to determine how many rows have data but I don't know how to write the formula to work the way I want it to. Do I need to do it in VB coding? Please help, Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data from Sheets in A workbook | Excel Worksheet Functions | |||
| Pulling data from other Excel sheets | Excel Discussion (Misc queries) | |||
| Need help with a formula pulling data from mutilple sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| 'Pulling' rows into sheets | Excel Programming | |||
Threaded Mode
