Question regarding extracting data from spreadsheet.

[rinzler]

Hi!
Another dumb question sicne im probably one of the worst at excel.

I have a spreadsheet which i use to record services performed for cusotmers. Basically its setup that during a day i usually have 5 or more posts for different customers. I want to be able to on another spreadsheet extract say all hours for a given customer, how would i accomplish this? I can provide pictures if it helps to understand the workbook better.

 

[oldbrewer]

customer1	33
customer2	44
customer3	55
customer1	66
customer2	77
customer3	88
customer2	99
customer3	110					customer1	99
						customer2	220
						customer3	253
						formula for 99 next to customer1
						=SUMPRODUCT((A1:A8=G8)*(B1:B8))
						you can put the results table wherever you want it

<colgroup><col><col span="5"><col><col span="5"></colgroup><tbody>
</tbody>

 

[rinzler]

This is what i mean:

so im not adding numbers i want rows with customer data but i want only the data for one customer on a seperate spreadsheet.

 

[rinzler]

Anyone?

 

[oldbrewer]

perhaps a macro to run down column C and every time it finds customer 4 copy the row to your new spreadsheet

 

[rinzler]

perhaps a macro to run down column C and every time it finds customer 4 copy the row to your new spreadsheet

Okay cool now how do i do this :O

 

[oldbrewer]

for j= 1 to 1000
if cells(j,3)="customer 4" then.....code to copy row
next j
end sub

 

[Smitty]

Welcome to the Board!

How about a Pivot Table? You can use a Slicer on Customer # to quickly toggle between customers.

HTH,