Konsolidating tabels on diffrent sheets in one sheets

P

Palle korsholm

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)
 
D

Don Guillett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel, assign cells in multiple worksheets from one sheet 1
Match and delete rows on two different sheets from reference numbers 4
Calling name of Sheet as a Variable? 1
Pivot Table using data from multiple sheets 1
VLOOK with Index - How to get results across instead of down? 3
Copying cells from one sheet to another 5
Copy Data from One sheet to Different Sheets 1
Lookup & return multiple rows based on cell value 3

Top