Previous Topic Next Topic

Newbie needs a macro

Closed
Dusty - May 27, 2010 at 10:32 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2010 at 04:51 PM
Hello,

I need a macro that will search for the sku I'm looking for then scroll to the correct column and update the cell with the correct value that I assign it. This seems like an easy one in theory, but I don't know how to make it happen. I have worksheets that are thousands of lines long and having this script would save me alot of time.

Thanks,

-Dusty


1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 27, 2010 at 04:51 PM
I am not following you.
You can search for the code and based on the find go to the cell on that row that you want. But how the code is supposed to put the value.

You can do by find too

I think you need to provide more detail
0

Similar discussions

Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Excel make cell flash red
hugrl -
Rjc -

13 responses
Applying my macro to a range of cells...
lorihohen -
ac3mark -

5 responses