i've attached a sample sheet. i hope it makes sense. i need only "customer 1" sites on sheet2, i got that setup to pull only those sites over, skip four cells and auto update as new sites are added. i then need to keep track of invoices as they come in, by weeks. i have four invoice columns to pull information from. i can't get the site columns on sheet2 to be just for individual site id's. also need a month total but i'll open another thread for that. thanks for the help!
Bookmarks