I have a project at work where I have a list of names (column A) and a list of time worked (column B). I know how to go through and consolidate the info manually but i would like to have a macro cycle through the info and stop when column A has a blank cell (making one table). Then start again when column A has a name again then make a consolidated table when it hits a blank cell again. Is this possible because manually going through creating all these tables is very time consuming.
Bookmarks