Recquired Conditional VBA solution for moving data as per diffrenet cell value

[santosh226001]

Hello Friends I m from India… my english is littlebit week. But I m trying to express my problem in English..hope u understand the problem..

Friends I m facing a problem in Excel & I wanna a VBA macros for as a solution of that problem. Excel problem is following:

I have a workbook with 4 sheet (Entry, Record, Sr Work, Ho Works)

When we enter P in sheet Entry we want to copy whole row (a24:v24) and paste special in next Sheet Record last empty row
&
also copy following conditional Range

A) if Cell Value j24= Head office Work then copy range(A38:d40) in Sheet HO
B) range(A27:k32) in Sheet Work if Cell Value j24 is other then Head office Work



pls help me for above problem the illustration of that problem in attache file

thanks

[pike]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.