Hello,
I need some help with VBA code, let me try explaining what I'm trying to achieve.
I have a multiple checkbox dropdown:
I would like to achieve the following:
When for example "ACS-002 Ind Lait" is checked go to sheet called "ACS-002" en copy everything from A3:B16
And paste it in sheet "Food" starting at A17
If multiple selected go to sheet X and copy X area, I don't mind specifying one by one which item is in which sheet.
And if multiple items are selected paste them underneath each other with always 2 rows in between each other.
The end result will look something like this :
If easier to use, I also have a sheet called "Placeholders" where I have a lookup formula that returns a true when checkbox has been selected.
Hopefully it's a little clear.
Thanks in advanced.
David
I need some help with VBA code, let me try explaining what I'm trying to achieve.
I have a multiple checkbox dropdown:
I would like to achieve the following:
When for example "ACS-002 Ind Lait" is checked go to sheet called "ACS-002" en copy everything from A3:B16
And paste it in sheet "Food" starting at A17
If multiple selected go to sheet X and copy X area, I don't mind specifying one by one which item is in which sheet.
And if multiple items are selected paste them underneath each other with always 2 rows in between each other.
The end result will look something like this :
If easier to use, I also have a sheet called "Placeholders" where I have a lookup formula that returns a true when checkbox has been selected.
Hopefully it's a little clear.
Thanks in advanced.
David