Sunday, August 22, 2010

Hey people, ok i know i asked this question a million times but i really need help with it?

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