Excel and macro in VB

  • Thread starter Thread starter dracon
  • Start date Start date
D

dracon

Hello there world !

Please don't attack me for asking this but...
I stumbled in your forum searching for macro for excel. And it seem
most users here are highly experienced in VBA and macro programming. D
you by any chance take a simple requests for a macro ?
A description would be: 620 lines and 7 coloums. I would need a macr
for searching for a value Search would be both numerical and characte
both should be possible. Thru all 7 columns.
In first coloumn there is a code in second a description (character
strings) and in all the rest is numerical entry. Search option whic
would display found results with possibility to edit all
the fields in all columns.
I have no idea is that simple or hard. Just tell me if this is a high
guru stuff i will even stop searching for help. I admit in excel an
macros i am a total newbie... no clue but basic use. Any directio
advice anything would be appriciated very much
 
This forum is full of nice folks that wouldn't dream of biting you :-)

The preference is generally to give somebody a helping hand in accomplishing
what they need to do rather than an outright solution, but it never hurts to
ask, so given that you have, lets try and clarify your needs:-

You say you are new, so it is possible you don't actually need a macro to do
what you want. I say this because from your text I can give you a simple
feature that will do this with no VBA in sight, but I don't know what prompted
the request for a macro solution, so bear with me.

Assume your data is in cols A:G, with headers for your data in row 1 in cells
A1,B1,C1,D1,E1,F1,G1

Select all your data, from cell A1 to cell G620 or whatever your last cell is,
then from the menu at the top, do Data / Filter / Autofilter. You will now see
little dropdown arrows appear at the top in row 1. Click on either of the
dropdown arrows in Col A or Col B and you will see a list of unique data. It
will be sorted alphabetically, and you can scroll till you find the value you
are looking for and then click on it. Once you have done this it will filter
just those matching records, and you are perfectly free to edit anything you
see. Just click again and select ALL to unfilter when you are done.

If this doesn't do what you really need, then feel free to post back and clarify
exactly what you are looking for, and how this solution doesn't meet the need,
and we will then have a better chance of helping you :-)
 
Back
Top