Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Consolidating raw data of sheet 1 on sheet 2

Kindly assist with a macro that will compare data on worksheet 1 and consolidate the information on worksheet 2.

Please find attached sample data.

Kindly view the explanation below.

The first sheet contains raw data ; with 4 Columns

The first column (Shop Number)

The second column (Brand Name)

The third column (Type)- different types of brand items

The fourth column (Amount)- amount sold per item type.

The second sheet is expected to consolidate the first sheet with the following columns

Shop Number Brand name Count Amount

The first column will contain a unique representation of the shop number for each brand name.

Count will contain the number of occurrence of the brand name as seen in first sheet (raw data)

Amount will compute the calculation of the values representation of the data as seen in the raw sheet.

Any assistance will be highly appreciated.
Attached Files
File Type: zip sample.zip (6.4 KB, 127 views)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate sheet, autonumber sheet, record data on another sheet des-sa[_2_] Excel Worksheet Functions 0 May 8th 08 06:56 PM
Consolidating information from one sheet to a list on another J Jenkins Excel Discussion (Misc queries) 1 July 7th 06 04:00 PM
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE Excel Discussion (Misc queries) 1 June 24th 05 06:31 PM
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE No Name Excel Programming 1 June 24th 05 05:57 PM
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE Excel Worksheet Functions 0 June 24th 05 05:27 PM


All times are GMT +1. The time now is 03:34 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"