I'd like a macro for excel to in fill data

May 27, 2011 at 04:00:31
Specs: Windows Vista
I have a spreadsheet with person identifier in column A, date in column C and location in column D (column B is irrelevant to my query)

I would like a macro with would infill columns C and D when person identifier in A is equal,

A C D

234 12/5/11 GP surgery
234
345

So I would like the macro to infill C and D with 12/5/11 and GP Surgery for A=234 but not for A=345

I would like the macro to loop through my worksheet


See More: Id like a macro for excel to in fill data

Report •

#1
May 27, 2011 at 06:47:31
What do you mean by "hen person identifier in A is equal"?

what does 234 stand for? is this a constand number or will this change,

im sorry i dont understand what you have written can you please explain a little better?


Report •

#2
May 27, 2011 at 18:25:52
Wouldn't a database program be better for this medical application?

Report •

#3
May 28, 2011 at 08:47:43
Column A is the unique person identifier (primary key)

Report •
Related Solutions


Ask Question