Hello All,
I have 8 macros running based on a cell value.
How do I change the values continuously until the cell values in another sheet comes to end.
Below are the steps I am looking for
1. Sheet1 has 'n' number of Cell values under two column - Column A(POS) and Column B (DO)
2. Sheet2 has a macro attached to it, based on cell values of POS and DO. But here we are currently manually entering the data.
3. Once cell values added we run the macro and data gets populated.
4. How do I link Sheet1 to it so that POS and DO values will auto populate in Sheet2.
5. Once values are auto populated we want the exiting macros to run and then copy (as values & Format) the data in new workbook with POS-DO name one after one in same workbook for all POS and DO combination.
I hope, I am able to explain it properly.
Regards,
I have 8 macros running based on a cell value.
How do I change the values continuously until the cell values in another sheet comes to end.
Below are the steps I am looking for
1. Sheet1 has 'n' number of Cell values under two column - Column A(POS) and Column B (DO)
2. Sheet2 has a macro attached to it, based on cell values of POS and DO. But here we are currently manually entering the data.
3. Once cell values added we run the macro and data gets populated.
4. How do I link Sheet1 to it so that POS and DO values will auto populate in Sheet2.
5. Once values are auto populated we want the exiting macros to run and then copy (as values & Format) the data in new workbook with POS-DO name one after one in same workbook for all POS and DO combination.
I hope, I am able to explain it properly.
Regards,
