https://docs.google.com/spreadsheets/d/133HcvG1aBzHgdW2kaw4qeIHvaDaRgC6uc1WGYPIUi5c/edit?usp=sharing
Hello, I wasnt sure how to upload an excel file but I need some help with VBA with some data clean up. On the google sheets, you want the 'Data Old' have to look like 'Data New'. The biggest conflict I am having is that
1. In the whole giant database, not every chunk of data have the "Role" header
2. I have got to the point where I have removed all the header for "MoverID" and "Role" but I have absolutely no clue on how to paste it where it aligns
3. When they're also aligned, I don't know how to do the VBA for Filling down first half of the data.
Please help!!
Hello, I wasnt sure how to upload an excel file but I need some help with VBA with some data clean up. On the google sheets, you want the 'Data Old' have to look like 'Data New'. The biggest conflict I am having is that
1. In the whole giant database, not every chunk of data have the "Role" header
2. I have got to the point where I have removed all the header for "MoverID" and "Role" but I have absolutely no clue on how to paste it where it aligns
3. When they're also aligned, I don't know how to do the VBA for Filling down first half of the data.
Please help!!
