Find the last row on column A -> copy the row from A unti H-column

**Tsinos** · 12-23-2022, 05:36 PM

I have a Purchases.xlsx (wsDest) from which I want to transfer only the last row information from A to H column, to an other wsCopy Excel (Receps.xlsx).

The problem:
Everytime I run the macro, it copies everything - not just the last row, which I would like it to copy.
This is problematic as the Destination file is updated by other users and once I hit the Macro again on wsCopy excel, the macro re-writes everything to wsDest Excel.

Needed solution
The macro should find the last row from wsCopy excel and copy that rows information from A:H columns to further pasted to wsDest excel.

Please Login or Register  to view this content.

I believe I need to change something on point 3 which I bolded. but what is it?

**skywriter** · 12-23-2022, 05:55 PM

Please Login or Register  to view this content.

You are copying from A4 here, if you want only the last row you would have to use the last row next to A also.

**PCI** · 12-24-2022, 02:51 PM

It seems that destination is column "A"
See next code NOT TESTED

Please Login or Register  to view this content.

**Tsinos** · 12-27-2022, 04:57 AM

As the destination file's last row should be found based on column A. I changed the code

Please Login or Register  to view this content.

But the code copies only one cell to the last row of column H.

FURTHER INFO:
A sample of the Excel from which the last row, based on column A information, is enclosed.

Destination Excel is the same format but information is only until column H. This is because Sales people has their Excels (here the copy info from) which they fill in and the destination Excel gathers all their info with a button click (what I am trying to achieve here) to the Destination Excel.

**Tsinos** · 12-27-2022, 05:05 AM

I noticed as well, but I'm not so familiar to the ranges as I'm quite beginner.
If I will refer to A4 I'm referring to the row number. The challenge for me is, that I should refer the the last row, which has filled in information on column A and copy that to the last row, on another Excel, to the first row which is empty.

modified:
wsCopy.Range("A:H" & lCopyLastRow).Copy
but:
Attachment 810855

**Sintek** · 12-27-2022, 05:31 AM

The macro should find the last row from wsCopy excel and copy that rows information from A:H columns to further pasted to wsDest excel.

Simply...As per skywriter suggested in post 4

Please Login or Register  to view this content.

**Tsinos** · 12-27-2022, 02:10 PM

Originally Posted by sintek

Simply...As per skywriter suggested in post 4

Please Login or Register  to view this content.

Yes, understood where Skywriter refered to but I could not figure it out.
Thanks for writing the code open to me, I learned from it as could see the code.

NOW the code works perfectly! Thank you ALL!

**Sintek** · 12-28-2022, 06:47 AM

.........................
Thanks.png

Find the last row on column A -> copy the row from A unti H-column

LinkBack

Thread Tools

Rate This Thread

Display

Find the last row on column A -> copy the row from A unti H-column

Re: Find the last row on column A -> copy the row from A unti H-column

Re: Find the last row on column A -> copy the row from A unti H-column

Re: Find the last row on column A -> copy the row from A unti H-column

Re: Find the last row on column A -> copy the row from A unti H-column

Re: Find the last row on column A -> copy the row from A unti H-column

Re: Find the last row on column A -> copy the row from A unti H-column

Re: Find the last row on column A -> copy the row from A unti H-column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VB Code to find certain text in column and copy digit part in diff column

[SOLVED] Excel VBA Macro - Find Word and Select that Column to Column D and copy

Find and copy values to a new column from a regular interval of cells moving down a column

Assistance with VBA CODE to find column on worksheet 1,copy contents of that column paste

[SOLVED] Macro to find the empty cell in a column and copy a adjacent row to another column.

[SOLVED] find bold number in Column A and copy range to column C

Macro to loop through one column and find a match from other column, then copy data

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions