Consolidating text data in excel
I need to send out a worksheet to a group of about 50 people the worksheet shows the days of the chosen month for example Dec 2014, one Row for each Day.
Across the top are the eight different shifts to , to etc.
Next, the code loops through the range on each worksheet and copies the values and formatting to the summary worksheet.
This procedure determines the last column in the summary workbook that contains data and then appends the column A source data after that column.Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site. Thus we have a grid of 248 cells Each employee enters their surname/Work Ref into any of the cells where they would be willing to work I would then like to consolidate this Text information into a single sheet allowing me to see staff availability or holes in the schedule.I do not have any code to post at this time, I have tried using a For Each construct i.e. Range("B2:o32") If CL "" Then This finds the entry finds the entry, but I can't find a way to append sheet1 with the data as I don't know how to find the same location.