Compare column names and copy data from several sheets only where column exists else blank

**henste1967** · 01-08-2014, 11:20 AM

Hello absoute beginner at VBA!

I have a spreadsheet where I would like to copy data from tabs ATPMD, STPPMD, and SBMD to tab Core, I would like the code to copy in row data where the column name matches on the above tabs.

Thank you so much

**alansidman** · 01-08-2014, 11:29 AM

I'm not understanding the requirements. Could you give some examples of which data should be copied and the logic. I don't see any columns with the same names as the sheet names for the three sheets. Please clarify.

**henste1967** · 01-08-2014, 11:33 AM

Thanks for responding Alan

Basically where say Material exists in STPPMD I would like to copy row data as below
113358
113447
602186
1002672
1004127
To be copied under material in core, and also where material decription is found, it's data to be copied and so on.

Many thanks

**henste1967** · 01-08-2014, 11:46 AM

Hi Alan,

I hope my explanation helped!

Steve

**alansidman** · 01-08-2014, 12:56 PM

Steve:

Give this a try:

Please Login or Register  to view this content.

**henste1967** · 01-08-2014, 01:52 PM

Alan

Firstly thank you so much for your time, I ran the code, it ran and left me on tab SBMD but no data was in Core, maybe I am doing something wrong, I received a message saying it was complete but no data.

Thanks again.

Steve

**alansidman** · 01-08-2014, 01:56 PM

Attached is my copy of your workbook with my code. It worked for me. Scroll down the Core page. I wonder if you have some data in that page that makes the last row be something other than row 2.

Compare column names and copy data from several sheets only where column exists else blank

LinkBack

Thread Tools

Rate This Thread

Display

Compare column names and copy data from several sheets only where column exists else blank

Re: Compare column names and copy data from several sheets only where column exists else b

Re: Compare column names and copy data from several sheets only where column exists else b

Re: Compare column names and copy data from several sheets only where column exists else b

Re: Compare column names and copy data from several sheets only where column exists else b

Re: Compare column names and copy data from several sheets only where column exists else b

Re: Compare column names and copy data from several sheets only where column exists else b

Thread Information

Users Browsing this Thread

Similar Threads

Copying row of data to new sheets if specific value exists in column

[SOLVED] Compare 2 pair of columns then copy value of third column over different sheets

if partial data exists in one colum, copy to another column

Compare column B - If exists then update date, else copy to end

VBA - Compare one column in two sheets & copy unmatched to one sheet

Bookmarks

Bookmarks

Posting Permissions