I've got a multi-tab spreadsheet which has separate tabs for each of a person's clients. I am trying to make it so that when one enters a date and a payment amount in the next available cells on an individual client tab it fills in a slot on another sheet that acts as a repository. Basically, this supersheet/repository will have a date column and then a column for each client by initial. The row will have specific date and specific payment amount. The trickiest part feels like getting payments from different clients who come in on the same date to fill into the same row and for the rows/data to autosort by date. The days on which client sessions happen are not every day of the week and there is only a semi-stable pattern to which days of the week.
Bookmarks