Hi all,
I'm trying to have a macro that will copy the whole row containing "open" on sheets 2 onwards into sheet 1(MASTER). also, is it possible for it to be not case sensitive? meaning as long as it contains the word "open", it will copy the whole row into sheet 1.
The restriction i have is i cant use any excel add-ins or other programs because im using a company laptop and i dont have administrator access.
Thank you all in advance.
Kindest regards,
Niu
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi,
It works but there's something missing. I need the macro to delete master and recopy everything again otherwise i'll have duplicate data.
Thanks for your help,
Regards
Niu
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks