Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding assistance needed.
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coding assistance needed.
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 "fpd833" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup assistance needed | Excel Worksheet Functions | |||
CODE Assistance needed PLEASE please please | Excel Discussion (Misc queries) | |||
VBA Assistance Needed | Excel Discussion (Misc queries) | |||
Coding help needed | Excel Programming | |||
Coding Assistance | Excel Programming |