Crappola! Just spent 45 minutes posting VBA question. Answered phone, yakked, Mr. Excel timed out, and I lost the Thread. So, this time - highly summarized...
Input sheet containing 150,000 + rows. Each row contains item, date, and amount. I want read each row and populate a 270 row by 366 column sheet. (270 unique items, and ... guess what... 366 unique dates!). I write like an old COBOL programmer (cuz that's what I was!). I intend to use 150,000 vlookups and same number of hlookups to get my cell row and column targets. Obviously, the amounts are additive in the output sheet. I will make it work, and it won't take a lot of time (minute or two). I'm guessing VBA was not meant to be attacked by a COBOL programmer. Any thoughts?
Input sheet containing 150,000 + rows. Each row contains item, date, and amount. I want read each row and populate a 270 row by 366 column sheet. (270 unique items, and ... guess what... 366 unique dates!). I write like an old COBOL programmer (cuz that's what I was!). I intend to use 150,000 vlookups and same number of hlookups to get my cell row and column targets. Obviously, the amounts are additive in the output sheet. I will make it work, and it won't take a lot of time (minute or two). I'm guessing VBA was not meant to be attacked by a COBOL programmer. Any thoughts?
