Results 1 to 11 of 11

Macro

Threaded View

biggs Macro 09-03-2007, 07:25 AM
royUK You aren't using Aaron's... 09-03-2007, 08:42 AM
royUK Your full code to use that... 09-03-2007, 08:46 AM
biggs Thanks for your reply RoyUK,... 09-03-2007, 08:53 AM
royUK Have you still got the... 09-03-2007, 08:58 AM
biggs missed a line when i copied... 09-03-2007, 09:02 AM
  1. #1
    Registered User
    Join Date
    09-20-2005
    Posts
    14

    Macro

    Hi,

    Im trying to do a macro that will move data from a number of sheets based on a flag in column W on each sheet.

    Basically if the flag in column W is "YES" then i want it to copy the whole row and append it (if thats possible?) into the sheet 'Journal'

    I have attached a cut down version with only 3 sheets (one of which is the 'Journal' sheet) and only a few rows on each sheet.

    Firstly is this even possible and if so how would i go about it? i know very little about VBA so any help whatsoever would be very much appreciated.

    Thankyou
    Marc
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1