I don't know about any of you guys... but i love excel!
I overused it when i was in school for business/IT and discovered so much about the formulas which could be used to make life easy as well as macros but now i have hit a brick wall :/
I don't have much free time at the mo to mess around figuring out the macro language all by myself so here i am
anyway i just need a macro to take a value in a cell and do a find on a separate sheet in that workbook and paste the row on the 1st sheet...then another 'search' type function to look in a seperate workbook (which is password protected but can be open at the same time) and paste the row into my workbook.
I know this sounds really vague but any help would be appreciated - ill be happy to put up some more info if it comes to it.
Thanks for any replies
I overused it when i was in school for business/IT and discovered so much about the formulas which could be used to make life easy as well as macros but now i have hit a brick wall :/
I don't have much free time at the mo to mess around figuring out the macro language all by myself so here i am
anyway i just need a macro to take a value in a cell and do a find on a separate sheet in that workbook and paste the row on the 1st sheet...then another 'search' type function to look in a seperate workbook (which is password protected but can be open at the same time) and paste the row into my workbook.
I know this sounds really vague but any help would be appreciated - ill be happy to put up some more info if it comes to it.
Thanks for any replies