Pivot Table Question

[Crudge]

Hello!

this is my first post and excited to find this resource!

i am trying to make my life easier at work by creating a sell sheet ( flyer) that pulls data from my excel stock list that pulls data from our server. the stock list is a pivot table and i have built the sell sheet in excel.

what i would like is to have excel make a sell sheet for every stock number ( row) on the pivot table.

is this something that is do able?

[David A Coop]

Welcome to the Forum, Crudge.

What you are asking is most certainly doable, but would require a macro which reads down the PT list, and creates a new sheet for every row. I assume you would also want to transfer from that PT some of the information to each sheet.

If you want people to help you with this, you will need to post an example.

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[Crudge]

David,

thank you for the pointers.

I have attached the two files i am working with. copy of used trucks is the spreadsheet that pulls from the database. respectivly inventory sheet is the sheet i would like filled out for each stock Number

i understand that not all of the data is available but would like the macro to fill out everything available to save some time!

Thank You!

[David A Coop]

CTone - Used Trucks.xlsm
Inventory Sheet.xlsx

Hi Andrew,

I have placed a macro in your Main File.

It reads through the Pivot Table listing for the Used Trucks worksheet, and creates a sheet in the Inventory worksheet.

You should file both workbooks in the same folder, and have them both open!

The macro copies the relevant row from the PT to the inventory sheet. and there are formulas in the Inventory sheet to pull pertinent data into the sheet. It also creates a simple INDEX at the front.

Note: There is a MASTER sheet which is hidden. This is the sheet which gets copied every time, then hidden again, so if you want to change formulas, you have to do it on the Master, then hide it again.

Hope this works for you. Please let me know how it goes. (I had quite some issues opening the file because of the SQL, and not being able to connect).

Regards,

David


When you reply please make it clear WHO you are responding to by mentioning their name.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".