Hello everyone!
I've just started working with VBA on excel (the hard way, bumping my head on the screen sometimes :P), and I'd like to ask you guys something.
My project consists of basically 3 sheets:
- One that determines what kind of sheet the macro is going to show (with option buttons.
- A second that is determined by the first one (there are several sheets and the first macro chooses one for you to enter the data)
- A third one, this one gets the information of the chosen sheet and organizes and calculates.
This project is totally based on sheets and VBA macros assigned to buttons.
Now to the doubt: There are a number of products in the second sheet that could be changed, eg: 5 products with the quantities, prices and margins, and maybe I would like to add one more kind of product to the sheet so people are able to add it and type in the information.
This also has to apply to the 3rd sheet, so it shows the correct name and information about the new product.
Ok, I have NO clue on a method do make this an easy task for anyone who needs to do it. Any ideas?
Thx in advance!ray:
Cya.
I've just started working with VBA on excel (the hard way, bumping my head on the screen sometimes :P), and I'd like to ask you guys something.
My project consists of basically 3 sheets:
- One that determines what kind of sheet the macro is going to show (with option buttons.
- A second that is determined by the first one (there are several sheets and the first macro chooses one for you to enter the data)
- A third one, this one gets the information of the chosen sheet and organizes and calculates.
This project is totally based on sheets and VBA macros assigned to buttons.
Now to the doubt: There are a number of products in the second sheet that could be changed, eg: 5 products with the quantities, prices and margins, and maybe I would like to add one more kind of product to the sheet so people are able to add it and type in the information.
This also has to apply to the 3rd sheet, so it shows the correct name and information about the new product.
Ok, I have NO clue on a method do make this an easy task for anyone who needs to do it. Any ideas?
Thx in advance!ray:
Cya.