PDA

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



santosh59211
01-30-2012, 12:32 AM
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
01-30-2012, 10:54 AM
Why post a picture, why not the workbook?

santosh59211
01-31-2012, 01:30 AM
Why post a picture, why not the workbook?
dear friend as per ur instruction here is the file for i wanna VBA

Bob Phillips
01-31-2012, 07:55 AM
Doesn't your code already do it all?

santosh59211
02-01-2012, 02:30 AM
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..