Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 85
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default 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!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying and Pasting from INTERNET to Excel Spreadsheet F. Lawrence Kulchar Excel Discussion (Misc queries) 11 November 12th 08 08:12 PM
Protection from copying and pasting into a new spreadsheet ft Excel Discussion (Misc queries) 2 April 25th 08 08:34 PM
Copying and Pasting Kokomo Excel Discussion (Misc queries) 1 November 20th 07 02:14 PM
Copying and pasting GARY Excel Discussion (Misc queries) 2 August 22nd 06 10:16 PM
Copying and pasting ??? NorcalTruck Excel Discussion (Misc queries) 3 December 27th 05 08:31 PM


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"