![]() |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jennamae | Excel | 1 | 11-15-2013 08:40 PM |
![]() |
Eric855 | Word | 6 | 07-25-2013 08:02 AM |
![]() |
Abol | PowerPoint | 2 | 06-27-2013 07:42 AM |
Extracting Contacts Data from Excel | Caesar | Outlook | 1 | 05-08-2011 05:54 AM |
![]() |
Anirudh_Dsp | Word Tables | 1 | 05-23-2010 07:48 AM |