Vba data move in another sheet as per requirement
Dear Sir,
Please find the attached workbook.
At present this workbook working simply as move data in another sheet as per column c ( name ).
Here my requirement is that . i want to some columns data in one sheet ( i have attached in last sheet named "scrap")
If MODE OF PAYMENT = Scrap then sheet1's data of scrap move in scrap sheet.
here sheet1's all scrap data will move in sheet scrap.
From :
Sa.1985
If i understand you clearly, you will mark the rows as "scrap" in sheet1, accordingly, the macro should check the other sheets - A to E for the corresponding info and copy that info into the Scrap tab, right?
Why not mark the "scrap" entries in sheets A to E?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
yes sir you absolutely right
Why not mark the "scrap" entries in sheets A to E?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
sa.1985 
Register To Reply
Bookmarks