Hello,
I'm currently working on a project where I need to take data from seven separate worksheets (each named for a day of the week) and compile it into one master list. The date only appears once, at the top of each worksheet, but it needs to be on the list beside each of the other entries. In addition, the length of each list the seven worksheets varies. I'm trying to create a form that can be used each week to compile the data and make it readable.
The master sheet should have data like this:
Date: Name: ID Number: Etc.:
I can't figure out how to get the data from each worksheet to appear underneath the data from the other worksheets. I've tried VLookups, CountA, IsBlank, and If statements in order to get this to work, but these don't work if the lists change size each week.
Does anybody have any ideas?
I'm currently working on a project where I need to take data from seven separate worksheets (each named for a day of the week) and compile it into one master list. The date only appears once, at the top of each worksheet, but it needs to be on the list beside each of the other entries. In addition, the length of each list the seven worksheets varies. I'm trying to create a form that can be used each week to compile the data and make it readable.
The master sheet should have data like this:
Date: Name: ID Number: Etc.:
I can't figure out how to get the data from each worksheet to appear underneath the data from the other worksheets. I've tried VLookups, CountA, IsBlank, and If statements in order to get this to work, but these don't work if the lists change size each week.
Does anybody have any ideas?
