Forum Discussion
Solved
Excel formula or VBA script
I have an excel spreadsheet that I am doing grouping by rows function, then Subtotal function based off of invoice numbers (column A). In the total rows, I am needing more information carried down fr...
Alternatively: select G1:J57.
Press Ctrl+G or F5 to activate the Go To dialog.
Click Special...
Select Blanks.
Click OK.
G3 should now be the active cell in the selection.
Enter the formula =G2 and press Ctrl+Enter to propagate the formula to all blank cells in the selection.
https://ascensus.box.com/s/dhniry5epou1own9mn5vaicowcen1zsa
Here is the box drive path for the file. Please let me know if you can get to it or not.
Thank you,
Here is the box drive path for the file. Please let me know if you can get to it or not.
Thank you,
No, I can't access the file, sorry. It requires a login.
- https://docs.google.com/spreadsheets/d/1A2aPmWW8UORxL_0m7isIgN3Ycwk7vbOM/edit?usp=sharing&ouid=104527455268205459541&rtpof=true&sd=true
Please try this link.That works. I have to do something else now, if there are no replies I'll get back to you later.
Alternatively: select G1:J57.
Press Ctrl+G or F5 to activate the Go To dialog.
Click Special...
Select Blanks.
Click OK.
G3 should now be the active cell in the selection.
Enter the formula =G2 and press Ctrl+Enter to propagate the formula to all blank cells in the selection.
- Let me try a different way