Good morning! I have issue I've been trying to resolve and am having little luck with vlookups and conditional formatting. I have done some vba programming, but this is a little out of my realm. Essentially I have an exported file that looks like this:
What I need to do is have this information transferred to a schedule type setup like this:
Where obviously the name from column C of the export would go to the correct column in the schedule based on the value of column B in the export. Then the rows of start and end dates from the export would match up with the dates on the schedule and fill the cells in between. Finally, the cells in the schedule would need to be color filled based on column A in the export. Does this make sense at all? I've tried vlookups, and index/match and have had very little luck. I have written (with help from this board) a macro to color cells based on the last digit of the cell, but that will not work here as the value would come from another page. Any help is appreciated!
What I need to do is have this information transferred to a schedule type setup like this:
Where obviously the name from column C of the export would go to the correct column in the schedule based on the value of column B in the export. Then the rows of start and end dates from the export would match up with the dates on the schedule and fill the cells in between. Finally, the cells in the schedule would need to be color filled based on column A in the export. Does this make sense at all? I've tried vlookups, and index/match and have had very little luck. I have written (with help from this board) a macro to color cells based on the last digit of the cell, but that will not work here as the value would come from another page. Any help is appreciated!
