Copying data with same headers from sheet 2 to sheet 1. VBA???

[jacobswayne]

Hello everyone. I have had this issue for about a week now and it has been killing me slowly. What I am trying to do is move data from “sheet 2” to “sheet 1”. I only need the values to move over from sheet2 to sheet1 (the headers are the same). For example, on both sheets lets say I have name,address, POC info. Sheet 1 has name and address info, sheet 2 has POC info. I need to move the POC info to sheet 1. When I say poc info its separated by different columns like name, email, phone number,etc. Can someone assist? Does this make sense?? Ive been copying and pasting and its taking me foreverrrrrrrr.

Ive tried vlookup and im not good with vba so neither worked for me. Safe to say im a noob :/


Thank you.

 

[gallen]

Ensure your columns are exactly as you stated on BOTH sheets and that they start in column A.

If so the enumeration would be correct:

Public Enum ColumnHeaders
    ID = 1
    FullName
    StreetAddress
    City
    State
    ZipCode
    Country
    ITName
    ITTitle
    ITEmail
    ITPhone
    ITName1
    ITTitle1
    ITEmail1
    ITPhone1
    Website
End Enum

 

[jacobswayne]

Okay coming back around to this. So I input the script into my master document. A lot of the data was in wrong boxes but I went in and fixed. The issue I just noticed was none of the ITNAME carried over.

 

[gallen]

In the code I've given It assumes ITNAME is column 8, (Column"H")

Check no columns are hidden and that ITNAME is in fact "H"