I am writing a macro in Excel, this is one thing that i am not to familiar with or further havn't faced this yet, nows the time (lol)
The macro is relative and not absolute so the recorded macro feature is probably harder than just writing the script (Like I'm the one to talk LMAO) but the basic function of this macro should be the following
1. Scan the active spreadsheet cells looking for intitials like "BRS" or "APS". For those cells containing those initials the whole row that the cell belongs to should then be copied and appended to the next work sheet that the user decides to activate in the book.
Thanks a lot , I know it is a little complicated to explain with a certain amount of characters, so i have Emails with every provider IE
rainofkayos@yahoo
@gmail
@hotmail
and who knows where else please either respond here on at my Email.,,, I am looking for help may it be the macro itself helpful hints, sites anything just meaningful stuff
Thanks a Bunch
Hey people, ok i know i asked this question a million times but i really need help with it?
Create the macro as per the instruction
http://www.helpwithpcs.com/tipsandtricks...
Then Ctrl + A to select all the data.
Add AutoFilter now
Then in the initials column do a custom filter by "BRS" or "APS”
This will result with rows with initials as BRS or APS
Now select the rows and copy to a new work sheet
Stop the macro and save as per the instruction
http://www.helpwithpcs.com/tipsandtricks...
Hope you got what you were expecting!
Reply:wow i don't know whats going on here, but if u wanna use a Marco i suggest getting iopus Marcos they work great
dental procedures
No comments:
Post a Comment