Quote:
|
The VBA code that is written searches the particular date column and if it comes across any data in that row it records it in the printout sheet starting in Z1 and working on down, pulling the associated name in that row.
|
Not Z1; it starts in row 8. Notice the line in the program that says "y = 8"? It uses y as the row number for the output; it starts it at 8 and then increments it from there. I don't know why it should use 8, but it doesn't really matter.
And that's why the formula skips over the first seven rows: because the author (I presume that, too, was excelledsoftware) knew that's where the data started. So you're not imagining things; the formula had to point to the right place. It's just that the formula was told that the right place to start was row 8—that is, it was constructed using Y8 as the starting place.
Does that help you see what you have to do? If you add more lines to the bottom of the report (after row 32, I mean), how does that affect what has to happen in the formulae in cols C and D?
Quote:
|
....while i generally understand the concepts of the VBA code the specifics of the lingo that is being used is way over my head.
|
Whenever that happens,
stop me and ask! I used to think there must be something wrong with me because I didn't understand the terminology that other people considered basic, and what I learned is not that there's nothing wrong with me but that it doesn't matter: The only way to make up the deficit is to start asking, even at the risk of making a pest of myself.