Hello,
I am trying to replace a "pen & paper" client records system with excel spreadsheets. I have separate spreadsheets for entire groups of people for attendance and payments. I need to create an individual records sheet for each client based on the data from the two spreadsheets. This will eventually be a lot of data so I need to be able to use the "autofill" feature to cause it to fill in formulas that import data for each subsequent date. However, when I try to do this, the formula series seems to repeat itself over and over again.
For example, I have the dates: 10/2, 10/9, 10/19. using the fill series feature, I need it to fill in information from subsequent cells which would look like 10/26, 11/2, 11/9, etc. (since it is taking the data from a set of cells like F1, G1, H1, it shouldn't matter that the dates are not in a consistent sequence, I just need the cells to be in a consistent sequence).
What is happening instead, is when I use the fill series feature, the dates are just repeating (10/2, 10/9, 10/19, 10/2, 10/9, 10/19). I could just enter each formula by hand, but since there are so many cells to fill and a large number of clients, this would not be practical at all.
Also, I have only a basic working knowledge of Excel. If the solution involves programming, I will need to know where to put the code.
If anyone could help me solve this problem, I would greatly appreciate it! I am including mock copies of the spreadsheets to give a better picture of what I am trying to accomplish.
Bookmarks