Populating from one sheet to another, by Date

[TyeJae]

I am trying to total up by a Range of Dates some information from one page to another through VBA. I am having a tough time with this one, I can't seem to get the correct information over to the other page.

I have successfully been able to transfer the data via a series of SUMIF statements, but it really is very inefficient and takes a while when the data repopulated by another program. So I am trying to do it via VBA.

I put some notes on the worksheet I am posting.

Any help would be much appreciated...

[TyeJae]

Is this something very complicated? I've been trying it and still coming up blank too.

Any help?

[royUK]

Have you tried a PivotTable?

[TyeJae]

No I haven't, never really experimented with one of those. I'll look into that a bit.

[TyeJae]

Ok the pivot table thing is really cool. Never messed with one of those before, however it slows down the program bad. It takes a good 5 minutes when the new information is put into the spreadsheet, and without the pivot table it takes about a tenth of a second. So again the only way I've been able to accomplish the task I need done, it takes forever.

Is there a way to do what I want to accomplish in VBA?

[TyeJae]

If anyone else comes across this problem, here is the solution to the problem I had. I figured it out...

Please Login or Register  to view this content.