Please help a novice!
Here is what I am looking at. I have 16 tables on Sheet A with 4 columns in each table (Date, Tag#, Feed Type, and Pounds). Some of these tables may get completely filled while others may never get one entry. There is no way to know this information in advance. I have one table on Sheet B with two columns (Date and Pounds).
There are several things I need this file to do. First, I need the information that is entered into Sheet A to automatically populate to the table on Sheet B. I want this in chronological order with only 1 entry per date. Some dates may be listed on those 16 tables dozens of times, some may not be there at all. I only want the dates that there are entries for listed. So if there were three entries for 06/29/18, I want that date listed just once on the Sheet B table with the pounds for those three entries added together for that entry.
This is where this may get complicated. I have added a column next to the pounds column on Sheet B. I need a formula here that will sum up the pounds at certain intervals. The first sum I need to pop up will be all dates BEFORE the Placement Date (found on Sheet C). Then, I need the sum to come up every 7 days starting from the Placement Date. This may be especially tricky because it will be impossible to know how many dates may be listed within each of those periods. So I do not know which lines a formula would need to be in.
Maybe this really isn't as difficult as I am finding it to be. I am far from an Excel expert here. Your help would be GREATLY appreciated. - KR
Here is what I am looking at. I have 16 tables on Sheet A with 4 columns in each table (Date, Tag#, Feed Type, and Pounds). Some of these tables may get completely filled while others may never get one entry. There is no way to know this information in advance. I have one table on Sheet B with two columns (Date and Pounds).
There are several things I need this file to do. First, I need the information that is entered into Sheet A to automatically populate to the table on Sheet B. I want this in chronological order with only 1 entry per date. Some dates may be listed on those 16 tables dozens of times, some may not be there at all. I only want the dates that there are entries for listed. So if there were three entries for 06/29/18, I want that date listed just once on the Sheet B table with the pounds for those three entries added together for that entry.
This is where this may get complicated. I have added a column next to the pounds column on Sheet B. I need a formula here that will sum up the pounds at certain intervals. The first sum I need to pop up will be all dates BEFORE the Placement Date (found on Sheet C). Then, I need the sum to come up every 7 days starting from the Placement Date. This may be especially tricky because it will be impossible to know how many dates may be listed within each of those periods. So I do not know which lines a formula would need to be in.
Maybe this really isn't as difficult as I am finding it to be. I am far from an Excel expert here. Your help would be GREATLY appreciated. - KR
