Hi, I am new and I want to be able to fill in the blanks on a Pivot table without using copy and paste but using the previous data above to fill the blanks below each data. Please kindly check the attachment speadsheet and help insert the formula in my spread sheet. Thank you for your help.
I guess the data that you have attached is not the pivot table but a copy paste version of it right?
By fill in the blanks do you mean, that values such as Telecommunications Plc Inc., Care Limited should be copied to each empty row before the next value starts?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
- Select E2:E68
- Press F5...Special...Blanks
- Press = followed by the up cursor key so =E3 is showing
- Confirm the formula with Ctrl+Enter
- Select E2:E68 again and Copy...Paste Special...Values
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
This is Excellent....It worked. I am very grateful. Thank you for your help in resolving my queries.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks