need help in creating a macro that will place Totals & other data below my spreadsheet entries. The spreadsheet entries get pulled in from another workbook & the # of rows of data will vary each time, (in this instance I only used two rows of data). I already have a macro to generate the total formulas and data below that, just need help in determining where this info will be placed based on # of rows.
Excel File.JPG
Appreciate the help
Last edited by RSa; 03-10-2017 at 01:43 PM.
Post the macro code rather than a pic.
Ben Van Johnson
Here is the macro code I'm using to calculate the totals in Row 11 & then the subsequent data/formulas below that.
How to I get this information posted starting 2 lines below the last row of data (# of rows of data will vary, so I know the cell selections below will not work when there is more than 11 rows in this case)
Please Login or Register to view this content.
Last edited by RSa; 03-10-2017 at 02:55 PM. Reason: added code tags
Hello RSa,
When you are posting any VBA Code, please ensure you do so according Forum Rules, which we all have to follow.
Thank for adding Code Tags.
Thank you.
Last edited by Winon; 03-10-2017 at 04:17 PM.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
sorry, still learning here, I've added the code tags.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks