PDA

View Full Version : Search & Replace



danweeks20
09-07-2013, 06:40 PM
Hi all,

I have a spreadsheet that consists of a data entry sheet that copies the data line into the applicable sheet, i.e. if the date is 08/09/2013 it will copy the data into the September sheet.

I am trying to find a code, or help to code a macro that looks up the reference number (entered into a cell), finds the data amongst the workbook and allows updates a particular cell.

For example:

Reference Number: (Number is entered into cell)
Update with: (Drop down list of possible options)

The macro would then search for the data based on the reference number cell, and updates with the option selected in the cell below.
If the data is not found, it would return an error to the user, otherwise confirm it has been done.

The workbook sheets are;
Entry
January, February, March etc.

The cell to be updated is found in column J within each one of the month worksheets.

Thanks in advance,

Dan

patel
09-08-2013, 12:55 AM
can you attach a small sample file wid data and desired result ?

HaHoBe
09-08-2013, 01:42 AM
crosspost: http://www.mrexcel.com/forum/excel-questions/725214-search-through-workbook-update.html