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

Thanks for your reply RoyUK, i tried using that code last week after looking around on here but couldnt get it to work, i kept getting an error message

when i posted this thread i made some changes to the spreadsheet to make it easier to understand, but didnt make the changes to the code to reflect it

ive made the changes you suggested but im now getting a run time error 91

object variable or with block variable not set

it seems to have a problem with the line

Find_Range("Yes", Range("W13:W100")).EntireRow.Select

missed a line when i copied and pasted it!

now im getting a compile error, variable not defined for

firstAddress = c.Address

thanks for your help RoyUK

im still getting the runtime 91 error though, before i input the Dim firstAddress As String line i was getting the error in my previous post, but since ive inserted this line im getting the 91 error again

my code at the moment is:

Please Login or Register  to view this content.

any ideas?

RoyUK That works a treat! - thankyou for all your help, its much appreciated!