| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtered Rows / Numeric Data - Automate Position of Total on Worksheet
Hi Excel Forum,
Hope you can help. I am working with filtered data that will be copied to anothe worksheet (via a macro procedure). The first row of data is Row Numbe 4, the column is C. How can I automate the calculation of a total to be placed on th worksheet (after the copying process) without knowing the final / las Row Number of copied filtered data -- this will vary: Row Number canno be fixed/ hard-coded? How can I sum the values from Row Number 4 to whatever Row Number hold the last data and place a total two rows below the last row of data? Please provide a working example. Thank you QT -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need the grand total pivot table filtered worksheet? | Excel Discussion (Misc queries) | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| how do I automate emailing filtered data | Excel Discussion (Misc queries) | |||
| Automate outputting filtered data from main worksheet to another s | Excel Discussion (Misc queries) | |||
| How to have total for filtered data?? | Excel Discussion (Misc queries) | |||
![QTE[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
