zloywolf
07-23-2012, 02:33 PM
Hello!
I'm very new VBA so I could use some help with the following issue:
I want to compile data from multiple worksheets into a pivot table on a new worksheet. In the pivot table, I want to have tabs for "Customer", "Rig Name", "Equipment", "Daily Rate", and "Revenue".
How can I tell Excel to extract this information when it's not always listed in the same location on different worksheets?
I attached the sample worksheets I am working with.
Thank you!
I'm very new VBA so I could use some help with the following issue:
I want to compile data from multiple worksheets into a pivot table on a new worksheet. In the pivot table, I want to have tabs for "Customer", "Rig Name", "Equipment", "Daily Rate", and "Revenue".
How can I tell Excel to extract this information when it's not always listed in the same location on different worksheets?
I attached the sample worksheets I am working with.
Thank you!