How to Combine 2 sheets Ranges

[internet_imran]

Hi all,

I am working on database workbook contained 2 sheets. Both sheets range is ("B7:N" & lastrow & "").value. (same column ranges). I am trying to combine both sheets ranges into one but could not work around.

Please help me..... my code is below.....

Please Login or Register  to view this content.

Thanking you

[kev_]

What are you trying to do?
- simply copy one range below the other?

[internet_imran]

Thank you very much Kev
working around this code will be copy column data of sheet 1 & sheet 2 and paste to sheet 3.

[kev_]

Test in attached workbook
- there are values in sheet1 & sheet2
- run the macro with {CTRL} k
- this copies the values to sheet 3

Does it do what you want?

Please Login or Register  to view this content.

[internet_imran]

Sir, thank you
may be I cannot clear the concept mentioned in the above code. please find attached sample file.

[kev_]

You did not explain your problem accurately in post#1
- you are not wanting to combine ranges on 2 sheets
- you are wanting to take 2 lists of journalled transactions and create an old fashioned double-entry ledger (where the shape of the data needs to change significantly)

Your 2 original worksheets are badly designed
- lots of merged cells
- lines without dates
- lines with descritions but transactions on previous line
etc....
- this is not real data - it is much too simplistic
- perhaps it was pasted in from a college exercise?

I will still help you - BUT this looks like college coursework - am I correct?

[internet_imran]

Thank you very much ....
- this is a sample workbook and not real data...
- my office data is different but work around this code, So firstly I try myself .....
- I try to combine the ranges as i explain in my first post. I also searched on the different website. The code in this sample workbook is good but worked out only the single sheet either sheet No.1 or sheet2 but not both sheets together.
Please look out the code existed in the sample workbook.

[kev_]

If this is Sample data - why have you formatted it in this way?

Bad and Better.jpg

[internet_imran]

sir thank you!!!! code existed in the sample workbook is correct but only change is required in the following line ........

Please Login or Register  to view this content.

If the above range is combined efficiently, my problem will be solved. please look out again the sheet Ledger which I update it manually.
Ledger sheet is my requirement.

Imran

[kev_]

An easier way to combine your 2 ranges is to place ALL values directly into a ONE array

Test in attached workbook with {CTRL} k
- values from array are printed to sheet TEST

Note
- range rows are counted (they vary and differ from each other)
- range columns B:N = 13 EVERT TIME

Please Login or Register  to view this content.

[internet_imran]

Sir thank you very much, suggested solution provided by you is very beneficial for me.

- one more question about post # 8 https://www.excelforum.com/excel-pro...ml#post4777134 in which you have asked to change the format.

- Please provide me the solution to change the Ledger format based on database format.

Imran