Using an IF stmt then copying/pasting into new spreadsheet
 

Hi, I've been looking for code to do the following, since I am new to using
VBA...

I have a Communications Log that contains numerous lines of communications
and I want only the lines that have "yes" marked in Column A to copy and
paste to another spreadsheet in the workbook titled Issues Log. Can someone
please help me with this code? I'm completely lost!!! I've been on so many
different websites trying to find this, thank you so much!

Using an IF stmt then copying/pasting into new spreadsheet
 

Try recording a macro while doing
datafilterautofilter
copy/paste
clean up the macro
If you still can't get it, post back and we will help.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Angela" wrote in message
...
Hi, I've been looking for code to do the following, since I am new to
using
VBA...

I have a Communications Log that contains numerous lines of communications
and I want only the lines that have "yes" marked in Column A to copy and
paste to another spreadsheet in the workbook titled Issues Log. Can
someone
please help me with this code? I'm completely lost!!! I've been on so
many
different websites trying to find this, thank you so much!

Using an IF stmt then copying/pasting into new spreadsheet
 

Hi Angela,

Is there any reason you can't just create a pivot table from the data in
your Communications Log and put it in your Issues Log workbook with a page
filter for Column A = Yes? You can select all the way down to the bottom of
your Communications Log worksheet even if there's no data in the bottom rows
in order to make sure you're always picking up new data if your
Communications Log expands every day, month, etc. Then all you'd have to do
is refresh your pivot table in the Issues Log whenever you wanted the new
Yes's to show up. You can even write a really quick line of VBA code that
would update that pivot whenever a user opened the Issues Log.