VBA - Populate 270 by 366 sheet from large input workbook

[flynavy]

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?

 

[Leith Ross]

Hello flynavy,

Is working with VBA making you long for the days of punch cards? If I could see the workbook layout it would be easier to create a solution for you with VBA.

Can you post a copy of the workbook to file share site?

 

[flynavy]

Hi Leith, will do! And thanks. Let me clean the sheets down to a manageable size and I'll see if Mr Excel has a file share apability, or if I need to use DropBox or etc. Stay tuned, and like I said, "THANKS"!

 

[JLGWhiz]

Mr. Excel timed out, and I lost the Thread

To recover threads, after you sign in just click on your name at the top of the page. It will show you all of your recent posts.

 

[flynavy]

	Col	Tot		5	6	7	8
Row	Item	Qty		8/18/16	8/19/16	8/20/16	8/21/16
3	BUMPERS:20-215-07	0
4	BUMPERS:20-215-97	0
5	BUMPERS:20-315-03	0
6	BUMPERS:20-315-07	0
7	BUMPERS:20-315-14	0
8	BUMPERS:20-325-03	0
9	BUMPERS:20-325-07	0

<tbody>
</tbody>

Date	Item	Qty
01/26/2017	BUMPERS:24-515-88	1
01/26/2017	BUMPERS:24-515-07	1
01/26/2017	BUMPERS:24-325-03	1
01/26/2017	BUMPERS:40-625-10	2
01/26/2017	BUMPERS:40-515-16	1
01/26/2017	BUMPERS:22-615-97	1
01/27/2017	BUMPERS:20-625-10	1
01/27/2017	BUMPERS:22-625-10	1
01/27/2017	BUMPERS:GP-1300	5
01/27/2017	BUMPERS:GP-1200	3
01/27/2017	BUMPERS:20-425-11	2
01/27/2017	BUMPERS:22-425-17	1
01/27/2017	BUMPERS:40-525-15	1
01/27/2017	BUMPERS:30-515-14	1
01/27/2017	BUMPERS:21-625-10	2

<tbody>
</tbody>

 

[flynavy]

Leith, looks a little messy. Top portion of example represents 366 by 270 output sheet. Bottom portion is input data.

Yes, boxes with punch cards turned in for a one week compile turnaround on IBM big and old iron!

 

[Leith Ross]

Hello flynavy,

Long live Hollerith! Thanks for posting the examples. I will work on this tomorrow.

By the way, are you retired Navy, active or other? I served from 1978 to 1984.