Hello, very new to VBA and excel macros and looking for some help. Hopefully this is pretty easy.
Values start in row 2, row 1 has filters.
Filter Column P and remove any row containing a date before 8/1/2016.
Filter Column N and remove any row greater than or equal to 2.0 and less than -.2
Filter Column K by color yellow.
copy row 3 all the way over and all the way down.
This is extra, buy if possible I would like to do the following...
Paste the copied data into sheet titled 'Data History', but the data needs to be pasted where after where the last data was pasted. (This is something I need to do daily and can't be pasting over past data)
THanks, please advise if you need more details on what my sheets look like.
Values start in row 2, row 1 has filters.
Filter Column P and remove any row containing a date before 8/1/2016.
Filter Column N and remove any row greater than or equal to 2.0 and less than -.2
Filter Column K by color yellow.
copy row 3 all the way over and all the way down.
This is extra, buy if possible I would like to do the following...
Paste the copied data into sheet titled 'Data History', but the data needs to be pasted where after where the last data was pasted. (This is something I need to do daily and can't be pasting over past data)
THanks, please advise if you need more details on what my sheets look like.