merging list with standard range

K

kuriti

I am trying to make a spreadsheet that contains a column of department
with identical formulas in the remaining columns. since i am using th
deparment code, the formulas will look up the information i nee
elsewhere. ie:

332000 BIRTHING CENTER Item 1 82.14 80.77
332000 BIRTHING CENTER Item 2 69.64 69.23
332000 BIRTHING CENTER Item 3 62.50 61.54
346000 CHILDREN'S CENTER Item 1 #N/A #N/A
346000 CHILDREN'S CENTER Item 2 #N/A #N/A
346000 CHILDREN'S CENTER Item 3 #N/A #N/A

I can create this by copying and pasting the formulas and the
replacing the department code one by one. however, it becomes tim
consuming when i have 80 departments.

can i keep a list of departments in a column and the formulas in
range and have excel combine the single department codes with the rang
of formulas? Ideally, when i needed to change the formulas i could jus
change the source. likewise, if i wanted to add a department, i coul
just add one department code to the list.

FYI-i am only just learning VBA by cheating with macros

thanks,

Kurit
 
M

Mark

Hi,
Personally, I rely only mainly with VBA. However, A
vlookup function may be is what you need.

regards
Mark
 
Top