transfer data without a formula in that cell

[Joey]

Hi all

I would like to know if a formula in one cell can put data in anothe
cell without a formula.

Eg.
According to a Ref #, data is entered according to dates alongside.
These dates are not in sequence necessarily.
A1 = Ref #
A2 to A6 = dates (1 to 9 Jan)
B2 to B6 = 5,7,4,6,9 respectively

The result
A10 to A20 = Ref #'s
B9 to J9 = dates (1 to 9 Jan)

If the ref # above matches A1 then the data in B2 to B6 should b
entered automatically when it relates to the dates in B9 to J9 withou
formulas in all the cells B10 to J20.

This needs to be done for the whole year and I don't want thousands o
formulas.
If you know of an easier way of doing this then please let me know.


Many thanks
Joe

 

[Don Guillett]

This can be done with a worksheet_change event macro found in the sheet code
for each worksheet.

 

[Joey]

Thanks Don

I'm fairly new to the world of Excel and am lost though.

What exactly does worksheet_change mean