Sleeper: Conditional VBA solution for moving data as per diffrenet cell value

[santosh59211]

i have a problem in excel .. & i wanna solution in VBA form... pls help me

i have a main entry sheet & i wanna data in selected sheet after entry

Problem in illustration form in attache document fill pls help me for solving problem

thanks & advance

[Bob Phillips]

Why post a picture, why not the workbook?

[santosh59211]

Why post a picture, why not the workbook?

dear friend as per ur instruction here is the file for i wanna VBA

[Bob Phillips]

Doesn't your code already do it all?

[santosh59211]

Doesn't your code already do it all?

no in those file.. when i press P in Cell V24
then copy range a24:v24 & other both range ((range a26:k31) & (range a37 :d39)) in Sheet Work & Sheet Ho respectively.

I wanna when we enter P in Cell V24 then
Range(a24:v24) to record sheet)
& if Cell Value j24="Head office Work" (in prv sheet i use hindi font but now i enclosed new file in english font use Head office work) then only copy range a37:d39) in sheet HO
& if cell value j24<>"Head office work" then copy range a26:k31 in sheet works last empty row

(in my sheet i use vlookup & many other function use but i u wanana then forget all thing & just make code on thinking base row on A24:V24 other think i will manage as per my requirement)

friend hope now u understand my problem..

thanks in advance..