Dear sir
goodmorning
I want vba code to Cut data from master and paste into newsheet & rename it its depends upon value of a col X:X in master sheet value of text barcode and cancelled:
I have set of data in master sheet In the column x:X header status have multiple text values but i want cut values only barcode and cancelled only move into newsheet with rename of sheet called "barcode and cancelled "
pls find the attachment you may understand
You can watch the replies for this thread. It is identical to yours (even the example data).
http://www.excelforum.com/excel-prog...th-rename.html
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Please Login or Register to view this content.
Hi sir
It works but some of column value is missing....sheet need to be renamed as Barcode&cancelled not in exisiting sheet
Which column values are missing? You need to show me on a sample. It might be because of spelling, lower and upper cases.
Last edited by AB33; 04-20-2015 at 05:41 AM.
Thanks sir for being spend your valuable time for my thread... It works find I dont use exisiting sheet(Barcode&cancelled) i just want copy data to newsheet and rename it as barcode&cancelled is it possble to do ? sir
Please Login or Register to view this content.
Amazing Sir Its works Keeping rocking...Thanks for your timely help...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks