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

01-29-2012, 05:58 AM
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 I entry A record in ENTRY SHEET & any selected colum (eg Colum S) I enter “YES OR OK”
a) I wanna Whole row (eg A25:Z25) copy & paste as value (not just copy paste remember I wanna paste value) in Record sheet
b) after YES enter if cell value R6=”Head office Work” then cell value of selected range (eg A37:F18) copy record to SHEET Ho works In after last row
c) after YES enter if cell value R6= other then "Head office Work" cell value of selected range (eg A26:K31) copy record to SHEET Sr works In after last row

friends hope u ppl under stand my problem & help me. If u wanna more details then pls send me ur mail id or mail me I will send u my workbook which one I m doing works & few existing macro exit there..
my mail id is santoshkumarshukla@gmail.com

friends actually I m from India & doing work in hindi font but if u help me in English I can understand & done in my sheet.

i have sheet also selleted in this sheet cell value V24 when i enter P then i wanna i above excersie move

01-29-2012, 01:57 PM
Your description does not match your example. Can you reconcile these?