Combine multiple sheets of data into one worksheet
 

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

Combine multiple sheets of data into one worksheet
 

See below page from Ron'e Site.

http://www.rondebruin.nl/copy2.htm





Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.



"Jason" wrote in message
...
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