Hi All, I've tried making this macro by recording the clicks, but that only works for the same cells every time. Attached is a spreadsheet that I use to track recipes that I make on a daily basis. I am trying to create a macro that, when run, it will cut and paste the cells that I hand select into another worksheet.
Source Worksheet: "Recipes"
Destination Worksheet: "Queue"
So I would like to be able to select a varying amount of rows, in this case (attached document), I would select Rows (12:22) in "Recipes" worksheet, then run the macro, which would cut and paste those selected cells into the "Queue" worksheet. An important point to note, is that there always needs to be 1 blank row in between each recipe, so when pasting, it will need to paste 2 rows beneath the previous recipe, unless of course it is the first recipe being pasted into the "Queue" worksheet, then it can go directly beneath the header. Sorry if that is confusing, but I haven't the slightest clue how to write that macro, even with the constant help from you guys and YouTube tutorials.
Thanks!
Bookmarks