Data Automation - Pulling data from a sheet but also blocking cells
My main purpose for this is to be able to create a trackable booking spreadsheet,
the main input page is where the kids are booked onto sessions
this is then checked against when they enrol and leave.
I have Data in my 'Input' sheet this is split into 5 sessions per day 5 days.
Column A is the name
Column B:F is Monday 5 sessions
Column G:K is Tuesday 5 sessions and so on
I then have a sheet 'Apr 26' which then pulls this data into the monthly sheet
The data i have in my input sheet can have anywhere between 1 cell to 12 cells per session, my formula works if there is 2 cells or more per session but doesnt work if only 1 cell it puts that cells data over multiple cell.
Excel Doc Link - ignore sheets past May 26 as they dont have the updated code or conditional formatting in.
This is my main input data sheet
This is the sheet and cell (highlighted) that the formula relates to
As you can see in the above images on Monday on the ASC 5pm column it multiples the data (child 1)
If I have 2 lots of data in the ASC 5pm Monday column on the input sheet the formula works properly.
Input sheet is how sessions per child are booked.
sessions can only have 12 in
however on certain days due to staffing can only have a certain number in (say 9)
the formula im having trouble with is on sheet Apr 26
on column F
it repeats the 'child 1' cell multiple times rather than just doing It once
but as you can see on column K the formula works but just not when its got 1 cell of data
Version Excel 2024 on Mac but needs to work on windows as well
[link] [comments]
Want to read more?
Check out the full article on the original site