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.
Please email me on bert.simmons@fuelchief.co.nz, so I can setup a teams meeting ,so we can go through this together,
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
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.
Please email me on bert.simmons@fuelchief.co.nz, so I can setup a teams meeting ,so we can go through this together,
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