Search : in
By :

Need Macro to sort thru raw data

Last answer on Jun 8, 2009 4:59:34 am BST Karminak, on Jun 3, 2009 4:06:35 pm BST 
 Report this message to moderators

Hello,
I have a POS data file that I'm not sure how to approach. The data columns are not specific and the data loops across a few rows. What I need to show is the Qty Sold in Eaches and Dollars for every SKU at different stores. Below is a small snip of the data showing the SKU (190724), type ($ or ea), store #(7002, 7004, 7030, etc.) and qty (0.01) looping horizontally for each SKU. I have over 100 SKUs and 178 stores so it is quite a mess. Since it is a weekly report, there has to be a way to do this with macros or functions so I don't have to do it manually. If anyone is will to take this challenge and help me, I will greatly appreciate it.

Thanks in advance,
Karminak


NEP SKU QTY TYPE TYPE Store # Qty Store # Qty Store # Qty
LIN05 ZA01 SDQ01 SDQ03 SDQ04 SDQ05 SDQ06 SDQ07 SDQ08
190724 QtySold EACH 7002 0.01 7004 0.01 7030 0.01
190724 QtySold DOLLARS 7002 0.01 7004 0.01 7030 0.01
190724 QtySold EACH 7161 0.01 7167 0.01 7180 0.01
190724 QtySold DOLLARS 7161 0.01 7167 0.01 7180 0.01
190724 QtyEnding Bal EACH 7002 14 7004 3 7030 3
190724 QtyEnding Bal EACH 7161 1 7167 1 7180 1

Configuration: Windows XP
MS Excel 2003
Firefox 3.0.10

Best answers for « Need Macro to sort thru raw data » in :
Excel data extraction macro needed Show
Excel macro for copy & paste selected range (Solved) Show
Excel – Macro for copy & paste selected range Show Excel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Sorting a table without using the sort function ShowSorting a table without using the sort function Getting started Pseudocode The coding Getting started First of all we initialize a variable $ max with the 1st value of table. Then we will make a loop until the table still contains...
Excel – How to extract partial data? ShowExcel – How to extract partial data? Issue Solution Note Issue I have an Excel spreadsheet that contains around 1500 html links. All the addresses start out common... i.e. http://www.frogs.com/. What I want to extract into another...
Uploading Large Files ShowUploading Large Files You have surely encountered various difficulties for sending files through e-mail due file limitation. You have found the elucidation to your trouble. There are several means to transfer files and data from one...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Data transmission - Introduction ShowData representation The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to...
OOP - Data encapsulation ShowThe concept of encapsulation Encapsulation is a way of organising data and methods into a structure by concealing the the way the object is implemented, i.e. preventing access to data by any means other than those specified. Encapsulation...
Ask your question Reply

1

mubashir aziz, on Jun 5, 2009 7:17:43 am BST

So tell me exactly what you want ????? Mean do you want to add the quantity on different different stores against SKU ????

can you be more specific as you have mentioned below columns

NEPSKU
QTY
TYPE
Store#
Qty
Store#
Qty
Store#
Qty

but you didn't tell whats your needs ??????

It will be better to explain Quantity Sold & quality ending that in which column they lies ????


Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz

2

Karminak, on Jun 5, 2009 1:10:05 pm BST

Hello,

Thanks for your response. This is a data file showing the sales of items at various stores. What I need to do is pull the data associated with the QTY Sold by eaches and dollars for each SKU by store. So for SKU 190724, store# 7002 sold 5 items each for $10 dollars, store# 7004 sold 5 items each for $15 dollars, etc.

I need to sort the data into a easily readable format that can be manipulated.

Thanks in advance,
Karminak


NEP SKU QTYTYPE TYPE Store# Qty Store# Qty Store# Qty
LIN05 ZA01 SDQ01 SDQ03 SDQ04 SDQ05 SDQ06 SDQ07 SDQ08
190724 QtySold EACH 7002 5 7004 5 7030 5
190724 QtySold DOLLARS 7002 10 7004 15 7030 10
190724 QtySold EACH 7161 0.01 7167 0.01 7180 0.01
190724 QtySold DOLLARS 7161 0.01 7167 0.01 7180 0.01
190724 QtyEnding Bal EACH 7002 14 7004 3 7030 3
190724 QtyEnding Bal EACH 7161 1 7167 1 7180 1

Configuration: Windows XP
MS Excel 2003
Firefox 3.0.10

   
Reply to Karminak

3

 mubashir aziz, on Jun 8, 2009 4:59:34 am BST

In this case Pivot Tables are the best thing to do ..... you can get info about Pivot from the net ....
Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz
Ask your question Reply
They need your help