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.
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- 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,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.
