kingjamesiii
New Member
- Joined
- Mar 16, 2009
- Messages
- 1
Hello all,
I am struggling with creating a macro that can link the data in one of my sheets to specific locations in other sheets in the same workbook. I have written on macro that has the users (7 people) use a form importing the needed information. I am trying to figure out a way to write a Macro that can then take this information and input it into each users own sheet. The catch to this is that each item entered is organized by three categories with nine different elements for one category and thirty for the other and two for the last. The only way I can see to do this is to write a ton of "If-Then" statements to meet every possible combination (7X2X9X30 =too much )
If there is some faster way to have this code, tell the excel which sheet to activate and then which column (one category), which row (other category) and which half of the spreadsheet (last category) to go to, I would love to hear it.
I am truly stuck.
I am struggling with creating a macro that can link the data in one of my sheets to specific locations in other sheets in the same workbook. I have written on macro that has the users (7 people) use a form importing the needed information. I am trying to figure out a way to write a Macro that can then take this information and input it into each users own sheet. The catch to this is that each item entered is organized by three categories with nine different elements for one category and thirty for the other and two for the last. The only way I can see to do this is to write a ton of "If-Then" statements to meet every possible combination (7X2X9X30 =too much )
If there is some faster way to have this code, tell the excel which sheet to activate and then which column (one category), which row (other category) and which half of the spreadsheet (last category) to go to, I would love to hear it.
I am truly stuck.
