Hi, new to this forum and I'm not programmer, have recorded few macros in past but that's it. Need help on worksheet / template that I'm working on and would greatly appreciate if I can get some feedback whether if this is possible...
Template consist of multiple worksheet, I would like to see if it possible to copy cell value from one sheet to multiple sheet based on user selection.
For example:
1. I have "SB" worksheet, this sheet holds list of work instruction by module... this is predefined list of items, little over 150 rows...
2. Now, each "module" have its own worksheet where team member inputs work instruction for each module, total of 17 worksheets. Each module have 4 section for instruction for example:
100 Section heading
200 Section heading
300 Section heading (SB's)
400 Section heading
I already figure out how to populate other section via formula, lookup and index etc.. and not trying to populate 300 with SB's.
3. and finally, "Summary" sheet, kind of shorter simplified version of 17 sheets. Kind of printable version of all work instruction in simplified form but now I need to include SB's into it.
What I would like to do if possible is to copy cell value from "SB" sheet into corresponding module worksheet as well into summary sheet based on module header.So basically, user will define what need to be copied/loaded and then with click of a button user would initiate macro to copy selected line item to a prospective module along with summary sheet.
Sample of SB sheet:
SBs.jpg
Have sample template but don't see attachment option in forum, but I could provide if required, maybe it will be helpful to understand requirements. Any help or suggestion would be greatly appreciated
Regards,
Izet
Template consist of multiple worksheet, I would like to see if it possible to copy cell value from one sheet to multiple sheet based on user selection.
For example:
1. I have "SB" worksheet, this sheet holds list of work instruction by module... this is predefined list of items, little over 150 rows...
2. Now, each "module" have its own worksheet where team member inputs work instruction for each module, total of 17 worksheets. Each module have 4 section for instruction for example:
100 Section heading
200 Section heading
300 Section heading (SB's)
400 Section heading
I already figure out how to populate other section via formula, lookup and index etc.. and not trying to populate 300 with SB's.
3. and finally, "Summary" sheet, kind of shorter simplified version of 17 sheets. Kind of printable version of all work instruction in simplified form but now I need to include SB's into it.
What I would like to do if possible is to copy cell value from "SB" sheet into corresponding module worksheet as well into summary sheet based on module header.So basically, user will define what need to be copied/loaded and then with click of a button user would initiate macro to copy selected line item to a prospective module along with summary sheet.
Sample of SB sheet:
SBs.jpg
Have sample template but don't see attachment option in forum, but I could provide if required, maybe it will be helpful to understand requirements. Any help or suggestion would be greatly appreciated
Regards,
Izet
