•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Combine Tab data into one?
Hi,
I currently have a workbook with 3 tabs. Two of the tabs I'm downloading data and pasting into every day and with the other I'd like it to combine the data from the two tabs into. They mostly share the same column headers but each have a few unique headers. In that scenario I'd like the columns in the third tab and to remain blank if it's coming from a tab without that column. Pasted below is an example. I don't want the tab names listed, just listing as example to show where they're being pulled from. What would be the best way for me to accomplish this?
| Tab 3 |
|---|
| Tab1-A |
| Tab1-B |
| Tab1-C |
| Tab2-A |
| Tab2-B |
| Tab2-C |
Thanks
[link] [comments]
Want to read more?
Check out the full article on the original site