Copy Data from various worksheets and display row by row in a single worksheet

fwd105

New Member
Joined
Feb 23, 2014
Messages
5
Hi,

I data on a master document and have data sent in from various independent offices which I would like to reconcile. Each region along with the master is posted onto a separate worksheet in my spreadsheet but I would like to copy specific information in worksheet order and paste row by row onto single worksheet in order to run a comparison. The data needed is in the same order but the number of rows reported on each work sheet will differ day by day. If worksheet 1 displays 50 rows in the consolidated sheet I would like worksheet 2 start in row 51, if however worksheet 1 finished in 24, I would like worksheet 2 to start in 25. Now I also want each worksheet to start reporting once the previous worksheet is complete and when there is no data in a specific worksheet, I would like the process to be able to continue.. so sheet 1 reports, then sheet 2 but sheet 3 has no data so it jumps to sheet 4 to begin.

For example consider various cities, New York, London, Frankfurt & Tokyo, each has sales of various products from a catalogue range but the products sold differ each week based on regional trends.
The master document which is independent also reports sales but this is manual so I would like to pick up any inaccuracies through reconciliation.

Outside of VBA and Macros, is it possible to get excel to report data sheet by sheet onto one in a continuous order?

Thanks
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,985
if the headings and columns are the same in all cases just put ALL the data onto one spreadsheet as it comes in and then analyse it however you want - far simpler !
 

fwd105

New Member
Joined
Feb 23, 2014
Messages
5
That would be ideal but the data from each region differs in terms of formatting so I have created formulas to the side of each to extract the data I need.
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,985
before I retired I worked in business improvement and often came across such scenarios.

MAKE each region use same formatting

ie alter the order of the columns and make column headers the same for all regions

you will save a lot of money that way

you can still analyse by region etc etc
 

Forum statistics

Threads
1,081,774
Messages
5,361,219
Members
400,617
Latest member
barron1

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top