| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Konsolidating tabels on diffrent sheets in one sheets
II have a worksheet with several sheets in. In those sheets I have some
tables that I like to place beneath one an other in one sheet. It shall be possible to put in rows in the table so the number of rows will differ from time to time in the different tables is that possible EX In sheet 1 the table goes from A1 to D10 In sheet 2 the table goes from A1 to E9 I lik to have them in sheet 3 with the table in sheet 2 first and the sheet 1 underneath (next time I have to do it The table in sheet 1 might goes from A1 to D20) -- Palle korsholm |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Konsolidating tabels on diffrent sheets in one sheets
How about naming the tables and then use a macro to determine the last row
after copying the 1st and putting the second one row down -- Don Guillett Microsoft MVP Excel SalesAid Software "Palle korsholm" wrote in message ... II have a worksheet with several sheets in. In those sheets I have some tables that I like to place beneath one an other in one sheet. It shall be possible to put in rows in the table so the number of rows will differ from time to time in the different tables is that possible EX In sheet 1 the table goes from A1 to D10 In sheet 2 the table goes from A1 to E9 I lik to have them in sheet 3 with the table in sheet 2 first and the sheet 1 underneath (next time I have to do it The table in sheet 1 might goes from A1 to D20) -- Palle korsholm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| HOW CAN I PASTE THE DATE AUTOMATICLY THROUGH DIFFRENT SHEETS | Excel Discussion (Misc queries) | |||
Linear Mode
