I have a spreadsheet with 42k rows of line items. If a line item (all info from row C to N) has a blank cell below it, I need to copy that information and paste it to the blank row (or rows) below that range. The blank come randomly. There could be 3 rows blank followed by 2 populated ones.
The pasting will need to stop once there is data below. This will need to be duplicated down the spreadsheet.
Can anyone help me write a VBA for this task? I am very new to VBAs.
Thank you.
Welcome to the forum.
If I understand your request properly I think you can avoid VBA. It seems like you are trying to find blank cells, then fill then with the value below which can be done with FIND SPECIAL (and I use this little trick ALL the time)!
http://www.contextures.com/xlDataEntry02.html
I would find all blanks, then hit = and UP button on the keyboard then CTRL+ENTER to fill ALL the blanks. THEN if you don't want the formulas anymore, you can copy and PasteValues on the entire selection.
Last edited by mikeTRON; 05-26-2016 at 11:10 AM.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Hi Mike,
yes, it's a bit of Excel magic, but I think you would hit = then UP before Ctrl-Enter, so that you get the data from the above cell.
Pete
Originally Posted by Pete_UK
Oh yeah I suppose you are correctI will change my comment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks