I have tried a variety of formulas, but I haven't been able to get
anything to work. Any suggestions would be appreciated. I have a
worksheet as below.
EMPLOYEE Bump MACH Month
3001656 N Y Oct 04
There are rows for every employee for every month, I.e. Nov 04, Dec 04
etc. the way data is retrieved it is added to the bottom of the
worksheet so there will be entries for the same employee for every
month. Bump and MACH will be either y or N.
On another worksheet in the same workbook I need to fill in the same
information. This worksheet is structured differently. In this case
the data for each month is arranged horizontally with only one line for
each employee as below.
EMPLOYEE Oct 04 Mach Oct 04 Bump Nov 04 Mach Nov 04 Bump
3002376 y n n y
This will repeat for every month through December. The workbook tallies
the information for import to a database. Unfortunately the source is
only able to output the data as either a spreadsheet or in other forms
that I can't import into the database.
I have a feeling that the solution is probably straightforward, but I
can't figure it out.
Thanks,
Luke
Bookmarks