Excel Help Needed!!!

[mckenzj14]

Hi can anyone help me?

I have a spreadsheet with two tabs

first spreadsheet has:

column A = Date
column B = list of shop names (dropdown list)
column c = has Items purchased

second tab sheet has

column A = List of shop names
Column B = I want to have the purchase costs of against that particular shop?


can this be done? I thought I could put a formula of vlookup or something like that to pull the total purchase against that shop name for the month
 

[soybean]

I don't know how to make column B on the second sheet do what you want.  So, I will mention the Subtotals function as a way to extract the data you want for each shop.  If you're unfamiliar with Subtotals, this reference may help: Calculating subtotals and working with levels in Excel

[mckenzj14]

Hi


thanks for you reply - I am unable to add subtotals into the below first sheet, as I will not know how many stores will be purchased from each day?. I wanted to have a grand total amount for eg. accessorize for the month to be pulled into the second sheet.  (is it possible???)

EXAMPLE FIRST SHEETS DATA

JANUARY   HOURS   CLIENT      ITEM(S) PURCHASED   STORE           COST     OTHER RETAILERS VISITED
1st   3   Miss Smith   Boots                                 Aldo           £50.00   Dune
   1.5         Scarf/Hat/Gloves                  Accessorize       £75.00   Tie Rack
                  
2nd   1.5   Mrs Jones      Dress/Bag                  Accessorize       £375.0            Coast
2nd   2   Mrs Brown      Bracelet/Necklace/Ring         Pandora           £500.00   Swag
2nd   1         Shoes                                 Kurt Geiger       £110.00


EXAMPLE SECOND SHEET

Store 2012   Jan   Feb   Mar     etc
Accessorize   £?      
Aldo         
Art & Amber         
Bare Nacessities         
Barrats         
Base         
Birthdays         
ect   
                  
   

[soybean]

If I were working with that data, I would definitely use Access database, not Excel.  I don't know how you can do this in Excel.  With Access, you can create and save a report and/or query to extract the data you want for each store and easily generate a report or query anytime.

[mckenzj14]

ok, many thanks for your help. I have a go in Ascess = first time for everything!!!   

[soybean]

What version of Office do you have?