Can you automate the ALT+ function?
I can not get away from the manual sorting, but after that, I would like to
write the TOTAL and calculate the amounts thru some macro or some code.
"DTTODGG" wrote:
Gary,
I would love to use SUBTOTAL, but, I have to manually go through and make
the divisions, so subtotal would not work.
I was hoping to make a little icon that when I clicked on it, it would:
Write TOTAL in bold and right justified in the cell
Then go to the next cell to the right and do an ALT+ for the count total
Then go to the next cell to the right and do an ALT+ for the dollar total
Got any ideas?
"Gary Brown" wrote:
Why not use the 'SubTotal' option from the Data menu item for EXCEL 2003 and
lower or the Data | Outline | Subtotal menu for EXCEL 2007+?
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
"DTTODGG" wrote:
Hi,
I have a spreadsheet that has data dumped from another program.
Each day I format the refreshed data. That means I:
Insert blank rows to divide parts
Type in bold TOTAL under the several lines for that part
Hit ALT+ to TOTAL the count of parts
Hit ALT+ to TOTAL the amount for parts
Then go to the next section and do the same thing over again!
The number of parts varied each day, so I can not use a given number of lines.
Any clue if there is a solution for this?
Thank you.
|