Hello again!!
I have an ongoing worksheet that I have been fumbling through...
I am not the best at VBA, so don't laugh too bad at my efforts.
This issue has stumped me, tried googling and searching, but to no luck; Only finding information on column vs column compare and copy whole columns, etc...
This is my problem:
I have a workbook that has had a ton of manipulations to get me to this point...
I have it to where it subtotals my 'planned qty' by each day on the "SubTotals" tab...
Done with my macro named "ConsolidateData()". (I figure that I would just call a new macro after this one to add the missing info.)
I have a "Log" tab (which gets its data elsewhere).. The "Log" tab has the days of the year as the headers, and under each day for whatever product was produced there are values (and blank spots if no production). The number of Products changes as time goes by because we add more (new) products to our production line.
What I am trying to do is this....
I am trying to get a macro that will look at the date in the first column (column A) of the "SubTotals" tab, search in the "Log" tab, find that column and then paste the 'total' (sum) of that column (in which the value is already there, but the line number could be different if more products are added later) into the "SubTotals" Tab in the third column (column C) for the appropriate matching date...
is that possible??
I have tried to do some crazy transpose copy/paste things just to get sizing errors and more flustered.
I am at a loss, and am calling for assistance from the Jedi Masters of this forum...
I hope that my explanation is clear enough and I didn't just make it more confusing!!
Thank you...
PLAN-test4.xlsm
Bookmarks