filter and copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am filtering my data using column b and then copying everything in that row
5 times. E.g., if the filter in column B contains 05/01/07 the I would
highlight and copy the whole row where column b=05/01/07 and paste it 5
times. is there an easy way to do this?
 
Im not sure exactly what your trying to do but it sounds like you might be
able to use advanced filter and filter the result to another location.

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find then highlight in yellow 6
Copy & paste range 4
Select value on a cell by matching value of two cells 1
Tried and true copy code lines fail me here 7
Macro to filter two columns 8
Macro or VBA to Clear Contents of Rows By Date (Starting At A5) 1
Assigning values to dates 7
convert range of years to series 10

Back
Top