LauraC1984
Board Regular
- Joined
- Jan 30, 2020
- Messages
- 63
- Office Version
- 365
- Platform
- Windows
Hi,
using the input sheet, I need to be able to search for a value in B13 - across multiple sheets - once the value is found. I need the macro to cut the row, and paste it into the sheet name entered into cell C13.
am I best doing this as separate macros, do one that finds and cuts the data and then others to run depending on the value in C13? as the data in c13 could be upto 14 different values/ 14 sheets that it might need pasting onto.
I can do the first bit of the macro, the find value - but then not sure on the coding for cut and paste - and the go to sheet ??? depending on value in c13
Thanks!
Laura
using the input sheet, I need to be able to search for a value in B13 - across multiple sheets - once the value is found. I need the macro to cut the row, and paste it into the sheet name entered into cell C13.
am I best doing this as separate macros, do one that finds and cuts the data and then others to run depending on the value in C13? as the data in c13 could be upto 14 different values/ 14 sheets that it might need pasting onto.
I can do the first bit of the macro, the find value - but then not sure on the coding for cut and paste - and the go to sheet ??? depending on value in c13
Thanks!
Laura