Macro Assistance needed,

[Bert S]

Hello, I am wanting to solve the below manual data entry with a macro enabled function in excel if possible..

What is currently happening is the below.
We have several pricing tabs based on several different configurations that make up a product, like 3 different categories, such as the Fuel Tank, Pump, and Dispenser for example.
We have to manually copy each specific data tab relevant to the customer requirements, into a new sheet, of which we can then look at the pricing across the board.

Is there way we can run a macro, based on 3x dropdown fields in a new sheet, which represents the 3x different categories that make up our product, which then copies the data from the respective tab, all into 1 new sheet/tab, so it is all in one place.



I have tried using the indirect function, which works partially however cannot get it to update based on a dropdown list value changing.

Look forward to someone helping me out.

Kind regards
Bert

 

[Sam_D_Ben]

I would say possible. But could you provide some images of your working data? This will help members understand your requirements better. Thank You

 

[Bert S]

I would say possible. But could you provide some images of your working data? This will help members understand your requirements better. Thank You

I would say possible. But could you provide some images of your working data? This will help members understand your requirements better. Thank You

Say I wanted to add the 3 tabs in red squares into 1 single spreadsheet tab, based on the below dropdown values being selected, is this possible?

The 3 dropdowns say looked like this, of which the various tabs as pictured above make up the 3 dropdown criteria as required. Ideally when I selected a dropdown of the 'Tank Type' for example, the matching tab would appear underneath the Tank Type as a table format, and so on so forth for the 'Pump Type' and Hose Type' data configurations.

Hopefully this makes sense what I am trying to achieve. Right now, we are having to manually copy tabs/data over to a new sheet to get all our data in one place, which is labour intensive and time consuming.

Upon the data being copied, we still need the ability to adjust the individual line item - pricing and quantity figures should they need to be altered to suit the customer requirements.

Kind regards
Bert

 

[Sam_D_Ben]

Could you share your file if you dont mind and Please ensure that any sensitive data is removed beforehand.