Combine multiple sheets of data into one worksheet

J

Jason

Hi all,

I have three worksheets, with the exact number of columns (A:p), however the
number of rows differ.

Can I combine all three worksheets into one. One sheet extracts P&L
accounts, another sheet extracts Balance Sheet accounts, and the third sheet
extracts Memo accounts. I would like to ignore row one of each sheet as this
is a hidden row.

Also, I would like to add another column to whatever code is suggested. The
value that needs to be added to each row is identical so if possible can we
add an input box. For example "Which Database?. The answer to this question
will be a three character alpha value, and as mentioned this value will be
added to each line of data being combined on the 4th sheet. Alternatively,
there is a database code on the set-up sheet, so the value could be
referenced to this cell if needed.

FYI, I have approximately 68 properties that these workbooks is being
extracted from.

Your help is truly appreciated

Jason
 

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

Automatically sending multiple parts of text from one word doc to another - is possible. 0
How to filter rows data based on background color of individual cells 3
External cell reference between two excel worksheets both in One Drive 0
Microsoft 365 Activations, Users or Devices? 0
Averaging Data across multiple sheets 0
Many sheets, one DB? 1
Combining data from multiple worksheets into one 4
Combine two spreadsheets into one 3

Top