Search results

Update: I cannot find a formula or code to pull data from CU10:CU20 and output it into columns on a seperate sheet. (each worksheet is a day of the week, the ouput would look like a calendar listing the equipment below. Does anyone even have ideas?

Progress!! Luke, i followed one of your other posts in the forums, and found that to pull data from the first sheet in each file in a folder, the excel sheet with the code in it, cannot be in the same folder as the files I am pulling the data from! So, if I can figure out code to create a new...

This will be a weekly responsibility, so I want to automate as much as I can. If I can output each foremans data into a summary of each day as stated, I can copy the data onto a master summary if need be. But, the more I can automate the better. I think that I could make a summary page...

I am definitely a newbie when it comes to VB. He lists code to summarize a range in all of the sheets in a workbook onto one Summary sheet, which gives me each piece of equipment (range A10-A20 for example) for each day, listed in two columns (A=day B=equipment. So my summary page has A1-a10...

After several days of searching, I must ask the experts! My task is to verify equipment being used is not duplicated. I use 10 workbooks (seperate files named for a foreman) Each with worksheets named for each day (Monday, Tuesday etc). Each day has a list of the equipment (by 3-4 digit...