I have a spreadsheet of 250 employees where annual increases are
calculated, lets call it sheet "A". I also have a separate sheet that
has cells for one employee's data so we can hand a sheet to each
employee, let's call it "B"
I want to be able to: 1)take the information from A 2) grab the
appropriate data from A for one employee 3) drop onto spreadhsheet B
4) print B 5) then repeat the process for each employee. 5) I also
want the code to ingnore rows that don't have a Y in field A or would
ingnore rows that don't have a value in a certain column. Has anyone
already done this? If so I would be most grateful for a VB code
sample.
John