If you look at the attached file. The running total sheet has a table that I will be continuously uploading similar data to for the year. I need to break that data down into each month in separate sheets. The sheet "How March should look" is what I need the sheet "march" to look like after conditional formatting is applied. I need it to copy and paste the part number column from the table in running total to the part number column in the table in the march sheet. But I only need the part numbers that occur in march. I then need the subsequent descriptions and costs to be copied over for those part numbers. I found one formula that somewhat worked but it left 0s in the cells for which the part number did not exist in march date range. I would like for all of this to happen automatically as I load data in the running total table.
Thank you
Bookmarks