Coding assistance needed.

[Guest]

This is what I am starting with:

Column A contains a list of manager names. Each manager has his name listed
once in colunm A.
Column B contains days of the week. Each day of week is listed once per mgr
in colunm B.
Column C contains empolyee names. Each employee is listed more than once
depending on the number of days scheduled.
Column D contains a number indicating hours scheduled.

It looks something like this:

MGR1 Monday Jim hours
Joe hours
Pat hours
Tuesday Jim hours
Joe hours
Mgr2 Monday Tim hours
Tuesday Cal hours
and so on......

Can anyone help with code to fill the empty cells in column A with a mgr
name and column B with the day? I want to be able to run a pivot on the data.
The list is quite long and it takes forever and a day to do this manually.
This data is spit out of an Access DB, and the date reads like this: Tuesday,
November 16, 2004. Simply dragging the day down changes the year, so I
believe I would need the code to copy the day and paste in the empty cells
below it until it hits another cell containing a day. I hop this makes
sense....Thanks!

 

[Bernie Deitrick]

fpd,

Select columns A and B, then use Edit | Go To... Special... Blanks, OK.
The type the equal sign, press the up-arrow once, then press Ctrl-Enter.
Then re-select columns A and B, copy them, then pastespecial values, and
you're done.

HTH,
Bernie
MS Excel MVP