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.

Can you automate the ALT+ function?
 

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.

Can you automate the ALT+ function?
 

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.

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.