Macro to copy data to sheet "All Vehicles" based on headings on this sheet

**Howardc1001** · 05-10-2024, 02:35 AM

I have headings in row1 on sheet "All Vehicles"

I have tried to write code to copy the data from sheets "New Vehicles" and "Used Vehicles" where the column headings match

for Eg Where "Stock Number" is in A1 on sheet "All Vehicles" then copy this data from Used Vehicles" and "New Vehicles" from the column containing this header in row1 and paste in row2 onwards on sheet "All vehicles" The same goes for the balance of the headings

When running the code only the data from "used vehicles" is copied and pasted on sheet "All Vehicles"

Kindly test and amend

Please Login or Register  to view this content.

**sudbhavani** · 05-10-2024, 03:29 AM

Dear Howardc1001 please try this code with my understanding

Please Login or Register  to view this content.

**jindon** · 05-10-2024, 03:31 AM

Please Login or Register  to view this content.

**JohnTopley** · 05-10-2024, 03:36 AM

Please Login or Register  to view this content.

[/COLOR]

You overwrite "New" with "Used" as you start with row 2 rather then then "Lastrow" associated with "New" - the logic for this is wrong.

Check your "LastRowAll" logic in BOTH New/Used code blocks AND learn how to step through code to find errors.

**Howardc1001** · 05-10-2024, 03:41 AM

Hi Jindon

Thanks for the help. Your code works 100%

**jindon** · 05-10-2024, 03:49 AM

That's good and thanks for the rep.

**Howardc1001** · 05-10-2024, 03:50 AM

Dear sudbhavani

The code is extracting the data in the incorrect columns for some of the headers

See final result on sheet "All Vehicles" of what it should look like as well as result on sheet "All vehicles" when running your code

**sudbhavani** · 05-10-2024, 04:56 AM

Originally Posted by Howardc1001

Dear sudbhavani

The code is extracting the data in the incorrect columns for some of the headers

See final result on sheet "All Vehicles" of what it should look like as well as result on sheet "All vehicles" when running your code

Dear please check now

Please Login or Register  to view this content.

**Sintek** · 05-10-2024, 05:25 AM

Howard...Just out of curiosity...
Are your New Vehicle & Used Vehicle headers always in the same position...
Does Used Vehicle tab never have a Year header...

**daboho** · 05-10-2024, 05:49 AM

Another way

Please Login or Register  to view this content.

**Howardc1001** · 05-10-2024, 05:52 AM

Sintek -The "Used Vehicle" Tab does has a Registration date

The Header Names will always be in the same position for New Vehicle & Used Vehicle

**Howardc1001** · 05-10-2024, 05:53 AM

Perfect now sudbhavani

**Howardc1001** · 05-10-2024, 05:56 AM

Thaanks for your code, but no data copied

**Sintek** · 05-10-2024, 06:00 AM

The "Used Vehicle" Tab does has a Registration date

Nope...YEAR Header

Just for the fun of it...

Please Login or Register  to view this content.

**sudbhavani** · 05-10-2024, 06:03 AM

Originally Posted by Howardc1001

Perfect now sudbhavani

thanks for the rep.howaed

**Howardc1001** · 05-10-2024, 06:30 AM

Thanks Very much Sintek

Code works 100%

**Sintek** · 05-10-2024, 06:57 AM

Thanks for feedback Howard...And rep +

Macro to copy data to sheet "All Vehicles" based on headings on this sheet

LinkBack

Thread Tools

Rate This Thread

Display

Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Re: Macro to copy data to sheet "All Vehicles" based on headings on this sheet

Thread Information

Users Browsing this Thread

Similar Threads

Macro to Copy Data where Sheet Names are the Same from sheet "Bad Debts" onwards

Generate copy of "template" sheet & change data in 2 cells based of cells in sheet "A"

[SOLVED] Macro to Copy Headings from Sheet "885201" to specified sheets

many actions in one macro: copy sheet "G" and paste "g_koond" no empty rows and add ID

[SOLVED] Copy Data from "Source" Sheet to "Target" Sheet (Code need help thanks)

Copy Data from Sheet One to Next available row on Sheet Two based on Indicator "Complete"

Looping thru rows and copy cell values from "Inputs" sheet to "Output" sheet

Bookmarks

Bookmarks

Posting Permissions