I have a worksheet where in cell A5 has an item description. Then in week 1 a quantity will be entered into Cell B5 and I would like a date time auto entered into cell C5. In week 2 a quantity will be entered into Cell D5 and I would like a date time auto entered into cell E5. This would continue for numerous weeks of readings.
I have seen how a VBA code could work for one cell but not for multiple entries that I would like.
I hope someone can help, it would save me an awful lot of work.