superstarr
Board Regular
- Joined
- Jul 10, 2003
- Messages
- 54
Hi
was hopeing someone could help
been trying to make a macro that will
.. pop up the FIND (cntrl F) button,
allow me to enter a value (can be part of the text say "choc" instead of chocolate) even cool with *choc*
search a sheet called CAT and once the value is found ask me (with a button) if this is the item i was looking for,
(with a button) ask me if i want to keep searching, accept this result, or cancel
... keep seaching will find the next value for choc -- then prompt the same thing as above, accept the result means copying a cell whcih is 4 cells to the left, then if another button could prompt me to continue or finish, if you continue then copied cell 4 over would then go into a memory, and we would look up the same value further down the sheet, if that value is selected then it too goes into memory until we say finish, at which point all values collected are pasted into a sheet called PRO (pasted in the next available empty cell in column C (cell C3 beging the fist possible entry - so it may paste value 1 in C6 and the next in C7, and then we end the seach. cancel would end the search.
i know its a lot to ask, been trying to piece my own code togehter from disc i bought from this site, holy macro and excel knowlege base.
if its helps i can paste my code so far but is not that amazing
thanks to the brave soul
Jon
was hopeing someone could help
been trying to make a macro that will
.. pop up the FIND (cntrl F) button,
allow me to enter a value (can be part of the text say "choc" instead of chocolate) even cool with *choc*
search a sheet called CAT and once the value is found ask me (with a button) if this is the item i was looking for,
(with a button) ask me if i want to keep searching, accept this result, or cancel
... keep seaching will find the next value for choc -- then prompt the same thing as above, accept the result means copying a cell whcih is 4 cells to the left, then if another button could prompt me to continue or finish, if you continue then copied cell 4 over would then go into a memory, and we would look up the same value further down the sheet, if that value is selected then it too goes into memory until we say finish, at which point all values collected are pasted into a sheet called PRO (pasted in the next available empty cell in column C (cell C3 beging the fist possible entry - so it may paste value 1 in C6 and the next in C7, and then we end the seach. cancel would end the search.
i know its a lot to ask, been trying to piece my own code togehter from disc i bought from this site, holy macro and excel knowlege base.
if its helps i can paste my code so far but is not that amazing
thanks to the brave soul
Jon