Merge multiple worksheets to new Worksheet

[RVINODK]

The below macro works fine but the only issue is that since it uses USEDRANGE, it picks up FORMULA FIELD which is copy pasted until end of WS. I would like to select only DATA until last EMPTY row and merge worksheets

Please Login or Register  to view this content.

[/CODE]

[Juppu]

Hi what version of excel are you using?
if you are on 2016 or higher you can use Power Query/Power pivot to easily merge muliple sheets into one. both from the same workbook and from multible workbooks.
(i think you can get an add in, on version 2010 and 2013)
en.wikipedia.org/wiki/Power_Pivot

[RVINODK]

Howdy,
Thanks for getting back to me. Unfortunately, this is used by a charitable institution for recording checks and Cash and they use excel 2007

[nankw83]

Hi RVINODK,

Can you post your full code or better yet a sample file following the yellow banner at the top page for instructions

PS: Please edit your first post, select the code then press the # button to insert code tags for your

[Mumps1]

It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.

[RVINODK]

Hi,
I really appreciate all your response and help.
I have attached the zip file for your reference.
The thing that i want is to Append the data of both worksheets into a new worksheet called "cashbank"
The macro works fine but since it uses USEDRANGE it selects the column K which has formula pasted until end of worksheet as it has formula in the cell.
Hope i am clear .
Again, Appreciate all of you in advance.

[Mumps1]

Try:

Please Login or Register  to view this content.

When attaching a file, please attached an unzipped version. It makes things easier.

[RVINODK]

WOW Thanks Mumps1 . It worked like a charm. Appreciate your help.

[Mumps1]

You are very welcome.