Combine multiple sheets of data into one worksheet

G

Guest

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

Insert Rows Based on values in another worksheet 3
Combine Data 1
how do i combine data from multiple sheets into one sheet? 3
Combining data from multiple worksheets into one 4
Formula to combine 2 spread sheets into one 1
How do I combine many worsheets into one worksheet?? 6
Combing Info. from multiple worksheets 2
Combine Multiple Worksheets 2

Top