#1
|
|||
|
|||
Extracting data, pivot tables, and maybe VBA help?
Hi, I am working on an excel sheet and need some help.
I have data in the format of the Part B on the attached image. I have only shown 2 examples of the data, but I have 15+ various line items which all have different work items, descriptions, work orders, completion dates, etc. I need to sort the data in various methods to include the actual cost based on car, location, type, etc. I believe pivot tables is the best tool to use to analyze the data. However, with pivot tables, I've found I need all of the data on 1 line like shown in Part A. I will collect all future data based on Part A; however, I need to display the data in a format like Part B. I tried using VLookUp and the Match/index functions above, but I could not get it to work correctly. Any help/ideas/etc? I would greatly appreciate it! -Brooke |
#2
|
|||
|
|||
Hi,
I see that we have not responded to your request. I was going to try to assist you but have found you are already receiving help on another site. Be kind when you post a request let us know if you asked the same at another site and the location. http://www.vbaexpress.com/forum/show...maybe-VBA-help |
#3
|
|||
|
|||
Macros Enale Sheet
Hi,
Please find the attached Macros Enable Sheet to salve this problem in easy way. Please don't make changes in this sheet because its format is fixed. Good Luck Thanks, Raju Singh |
#4
|
|||
|
|||
Pivot table
Want to change the field in the Report filter field. Pivot table reads info from column E want to change it to read from column D? As soon as I want to remove it, error message appear: "A pivotTable report cannot overlap another PivotTable report?
|
Tags |
extract, pivot table, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
formula writing for extracting data | jennamae | Excel | 1 | 11-15-2013 08:40 PM |
Extracting data from excel | Eric855 | Word | 6 | 07-25-2013 08:02 AM |
Extracting data from ppt graphs without linked spreadsheet | Abol | PowerPoint | 2 | 06-27-2013 07:42 AM |
Extracting Contacts Data from Excel | Caesar | Outlook | 1 | 05-08-2011 05:54 AM |
extracting data from Table to text file | Anirudh_Dsp | Word Tables | 1 | 05-23-2010 07:48 AM |