H
HowieA
Hi,
Just a simple question on formats. I have been given a
project that keeps coming back to me. It is a
spreadsheet that has many rows(6000) that I need to sum
certain colums and count the items in the section. The
spreadsheet is sorted by store and I need ti insert
rows and put the results of the colume. Is there function
or macro that I can use to do this with as little pain as
possible. This is how it looks before and after:
This is what the raw data looks like
A B C D E F
Part Number Quanity Cost Extended Cost Lead Time Store
C440000 10 .50 5.00 30 01
c440001 5 .30 1.50 30 01
c440003 15 1.10 16.50 15 01
c440005 15 .90 13.50 30 01
C450000 10 .50 5.00 30 02
c450001 5 .30 1.50 30 02
c450003 15 1.10 16.50 15 02
c450005 15 .90 13.50 30 02
C460000 10 .50 5.00 30 03
c460001 5 .30 1.50 30 03
c460003 15 1.10 16.50 15 03
c460005 15 .90 13.50 30 03
This is what I need to do
A B C D E F
Part Number Quanity Cost Extended Cost Lead Time Store
C440000 10 .50 5.00 30 01
c440001 5 .30 1.50 30 01
c440003 15 1.10 16.50 15 01
c440005 15 .90 13.50 30 01
4 45 36.50
C450000 10 .50 5.00 30 02
c450001 5 .30 1.50 30 02
c450003 15 1.10 16.50 15 02
c450005 15 .90 13.50 30 02
4 45 36.50
C460000 10 .50 5.00 30 03
c460001 5 .30 1.50 30 03
c460003 15 1.10 16.50 15 03
c460005 15 .90 13.50 30 03
4 45 36.50
Just a simple question on formats. I have been given a
project that keeps coming back to me. It is a
spreadsheet that has many rows(6000) that I need to sum
certain colums and count the items in the section. The
spreadsheet is sorted by store and I need ti insert
rows and put the results of the colume. Is there function
or macro that I can use to do this with as little pain as
possible. This is how it looks before and after:
This is what the raw data looks like
A B C D E F
Part Number Quanity Cost Extended Cost Lead Time Store
C440000 10 .50 5.00 30 01
c440001 5 .30 1.50 30 01
c440003 15 1.10 16.50 15 01
c440005 15 .90 13.50 30 01
C450000 10 .50 5.00 30 02
c450001 5 .30 1.50 30 02
c450003 15 1.10 16.50 15 02
c450005 15 .90 13.50 30 02
C460000 10 .50 5.00 30 03
c460001 5 .30 1.50 30 03
c460003 15 1.10 16.50 15 03
c460005 15 .90 13.50 30 03
This is what I need to do
A B C D E F
Part Number Quanity Cost Extended Cost Lead Time Store
C440000 10 .50 5.00 30 01
c440001 5 .30 1.50 30 01
c440003 15 1.10 16.50 15 01
c440005 15 .90 13.50 30 01
4 45 36.50
C450000 10 .50 5.00 30 02
c450001 5 .30 1.50 30 02
c450003 15 1.10 16.50 15 02
c450005 15 .90 13.50 30 02
4 45 36.50
C460000 10 .50 5.00 30 03
c460001 5 .30 1.50 30 03
c460003 15 1.10 16.50 15 03
c460005 15 .90 13.50 30 03
4 45 36.50