Macro Assistance needed,

Bert S

New Member
Joined
Mar 3, 2025
Messages
2
Office Version
  1. 365
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
 
I would say possible. But could you provide some images of your working data? This will help members understand your requirements better. Thank You
 
Upvote 0
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
1741052672310.png
1741052695023.png

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?
1741052758959.png


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.
1741052940797.png


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
 

Attachments

  • 1741052892531.png
    1741052892531.png
    2.6 KB · Views: 1
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top