View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DTTODGG DTTODGG is offline
external usenet poster
 
Posts: 74
Default Can you automate the ALT+ function?

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.