Chestnuttgirl98
New Member
- Joined
- Apr 18, 2020
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
I need to figure out how to automatically look for a cell with data, copy it, and paste it in all the blank cells...until it gets to the next filled/occupied cell, wash rinse repeat.
I have a pivot table with column 1 = project name, column 2 = resource name, all the other columns are the hours per month that person spent on the project. I need to build on top of the macro I already have that selects the pivot table and copies and paste special the values into a new sheet. ***I'm using that data to run some calculations on other sheets*** It's labor intensive to come back and copy down all the project names in all the blank cells, and I hope there's a way to find the data, copy and paste into the sequential blank cells, and then copy the next data, and so on.
I have a pivot table with column 1 = project name, column 2 = resource name, all the other columns are the hours per month that person spent on the project. I need to build on top of the macro I already have that selects the pivot table and copies and paste special the values into a new sheet. ***I'm using that data to run some calculations on other sheets*** It's labor intensive to come back and copy down all the project names in all the blank cells, and I hope there's a way to find the data, copy and paste into the sequential blank cells, and then copy the next data, and so on.