Copying and pasting between worksheets if and validations

[stephanbou]

Here it is....

I have a worksheet named Expenses, in expenses column k i have three important values, paid 100%, YES and NO
If the value in column k = YES i need the macro to copy column j,g and b to a worksheet named general account to the next available row

values xJ need to be copied to F(first available row#) and G(first available row #)

then values g and j as one string and pasted to C(first available row #)

but all these items g,j,b my go to the same row #

then return to the sheet Expenses and change the value from the row that was just copied change the row# column k to paid 100% (so that next time the macro runs it doesnt copy this data, then repeat until there are no more YES's remaining in column k.

please help.... please..

---------- Post added at 06:09 PM ---------- Previous post was at 06:02 PM ----------

also it will need to write the value in B(first available row #) to WITHDRAWL....

[fredlo2010]

Can you provide a sample?