Salescodes

  • Thread starter Thread starter mempson
  • Start date Start date
M

mempson

Can someone please help me with this?

On a daily basis we use a spreadsheet to summarise materials issued, and each part number is attached to a 3 digit alpha-numeruc code. (Code is located in column C)

Several different parts may share the same code. Each part has a fixed cost, multiplied by the issued total.

Sorting them is easy, (by column C, ascending) but then we need to input 2 rows as each code finishes and a new code begins.

Into the 2 rows, we then place the financial total (per code). (We use 2 rows to ensure there is a clean break-point for the formula.)

Currently this is a judgement call, done manually, but I want to incorporate this into a macro.

The list may vary in length from 40 entries to 180, depending on volumes.

There is up to 18 codes. (Examples are C10, D10, G11, N12, N18, etc.)

I'm sure I could do this with a 'LOOKUP-IF' type of table, but I cannot think how to get it to aotomatically insert the 2 rows.

Any ideas?

Mike E
 
Try selecting your data and doing Data / Subtotals :-)

You should never have to do this stuff manually.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Can someone please help me with this?

On a daily basis we use a spreadsheet to summarise materials issued, and each
part number is attached to a 3 digit alpha-numeruc code. (Code is located in
column C)

Several different parts may share the same code. Each part has a fixed cost,
multiplied by the issued total.

Sorting them is easy, (by column C, ascending) but then we need to input 2 rows
as each code finishes and a new code begins.

Into the 2 rows, we then place the financial total (per code). (We use 2 rows to
ensure there is a clean break-point for the formula.)

Currently this is a judgement call, done manually, but I want to incorporate
this into a macro.

The list may vary in length from 40 entries to 180, depending on volumes.

There is up to 18 codes. (Examples are C10, D10, G11, N12, N18, etc.)

I'm sure I could do this with a 'LOOKUP-IF' type of table, but I cannot think
how to get it to aotomatically insert the 2 rows.

Any ideas?

Mike E
 
Back
Top