cosmic_chelonian
New Member
- Joined
- Aug 27, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I have a workbook with four sheets-- Sheet A, Sheet B, Sheet C, and Master.
The three sheets have the same base headers, but also have some specific to that sheet (i.e., Sheet A & C do not ask for Pet Name, but Sheet B does). The "Master" sheet has 104 columns with headers that do not match exactly to Sheet A/B/C. They also may not be in the same order. Many of these columns will be left blank but are required to be present on the sheet.
I am trying to write something to pull the data from Sheet A/B/C and copy it into the associated column in "Master".
I have tried about half a dozen ways but I am super new to VBA and when I try to copy existing methods, I either can't figure out how to apply the example to my sheet, or Excel runs out of memory.
If y'all could help give me that little running start with some kind of example or direction, I would be eternally grateful.
Here is an example I just made up to show what I am needing:
The three sheets have the same base headers, but also have some specific to that sheet (i.e., Sheet A & C do not ask for Pet Name, but Sheet B does). The "Master" sheet has 104 columns with headers that do not match exactly to Sheet A/B/C. They also may not be in the same order. Many of these columns will be left blank but are required to be present on the sheet.
I am trying to write something to pull the data from Sheet A/B/C and copy it into the associated column in "Master".
I have tried about half a dozen ways but I am super new to VBA and when I try to copy existing methods, I either can't figure out how to apply the example to my sheet, or Excel runs out of memory.
If y'all could help give me that little running start with some kind of example or direction, I would be eternally grateful.
Here is an example I just made up to show what I am needing:
