Hello trying to do something that is probably pretty simple, but I have no experience at all with Marcos.
In cell F I have either 1's or blanks.
If cell F has a 1 i would like it to copy over the rows A-J to a new work sheet.
If in cell F the 1 is changed back to a blank, it would be removed from the said work sheet.
Doesn't have to be Automatic, I can create a but to run the Macro.
From what I have been reading this is "Dynamic" but i cant find anything that provides a similar code for me to tune to fit my needs.
ANY HELP is much appreciated.
Thank you, thank you, thank you in advance!