Using find feature in macro

[debf]

Hello,

I think this is pretty basic, but I don't have a lot of knowledge on the subject.

I'm trying to record a macro that performs the following steps:

copy the contents of a cell
go to another tab
open find dialogue box
paste contents of copied cell in the find dialogue box
find next and close dialogue box
copy the contents of the cell to left of search results
go back to original tab
paste contents in cell below

This all works fine except when I run the macro, it always finds the exact contents I pasted in the find box when I recorded the macro. So I guess it's not pasting the new contents in the find box when running the macro. Can I make it do that somehow?

This is my first time posting so I hope I'm following the correct procedure and that this is clear.

Thank you for your help!

Deb

[mehmetcik]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[xladept]

Hi Deb,

Something like this perhaps?

Please Login or Register  to view this content.

[debf]

Hello mehmetcik,

I've attached a very basic spreadsheet with the recorded macro.

Thank you for your quick reply and offer to help!

Deb

[mehmetcik]

Two simple formulas do what you need

in B2

Please Login or Register  to view this content.

In B3

Please Login or Register  to view this content.

As a Macro

Please Login or Register  to view this content.

[xladept]

Did you see post #3??

[debf]

Thank you xladept, I did see your post. I'm not at all good at reading VBA code so I'm not sure I can make this work in my spreadsheet. I know what I am trying to do should be very simple...I just have little knowledge

I do plan to take a look at your post again when I have some time to study it because I'd like to be able to learn from it.

Thank you very much for your help!

[debf]

Thank you very much mehmetcik! I will work on incorporating this into my spreadsheet. Unfortunately, I need to direct my attention elsewhere for a few hours. Hopefully I can spend some more time on it this afternoon. I do appreciate your help!

Deb

[xladept]

There are just about eight lines of code - the rest are your specifications - I tried to put the code close to the spec it addressed

[debf]

Thank you xladept. I do appreciate the help. I'll let you know if I'm successful!