Excel vba find & delete

Question

Excel 2000 Win7 I have a workbook with sheet 1 as home, and 2 or more sheets with identical data records. Have data coming into sheet1:- A1 and B 1 , that show a reference in A and the sheet number it is to go into in B.

A1 & B1 will get deleted later for a new set of data.

Need a Find macro to - select the value in A1(which changes often) and delete it from all other sheets. Then place the value of sheet1 A1 into the sheet referenced in B1

It will then revert back to the start for next data coming into Sheet 1 in A1 B1.

Do I need to have dynamic ranges in the sheets except sheet 1. or should I use xlup .

For a hobby activity model railroad.

Answer

Hi Charlie,

Please send me a sample file (maryalindsey@gmail.com) and I will create the macro and return same to you. I need to have a point of reference where I can fully understand what you are hoping to accomplish.

I look forward to assisting you with this project.

Kindest Mary A. Lindsey Instructional Technologist eDoc Support LLC www.edocsupport.com