Posts by hollowmaker11

I want to thank everyone who took the time to help me understand and resolve this issue.

A huge thanks to frozenheron7 for fixing everything; I really appreciate you stepping in to get my workflow back on track. 😍

Kyle Johnson2 said:WHY use PM? I don't take problems via PM because then I feel obligated to work on them, and I don't want that.
The forum is public, and it’s better to provide help publicly so others can see the solution and use the examples. You might want to consider that other members could run into this exact same issue, whether now or down the road.
If you get help here, everyone benefits.

Looking at your spreadsheet—which seems pretty disorganized to me since I don't know the full context—I didn't quite catch what you meant about it being solved previously. I noticed someone set a specific Print area? My guess is the original author was using VBA macros. Maybe check an older backup of the file if you have one to see how the formulas were set up there.

This behavior is standard if cells are linked through formulas or external links.
From an organizational standpoint, it could be improved. I suggest using one Sheet per day (with identical tables linked by formulas/links).
That way, you would have a set number of sheets in one Workbook for the month (covering all three shifts; you could even manage all shifts within a single workbook).

It makes sense that the total changes when you enter new entries, because the cell contains a formula that sums those specific items. I'm offering a different approach, but if that doesn't work for you, perhaps someone with more free time can assist.
Check out the example in the attachment, best regards.

The table isn't poorly organized; it's mostly because I didn't send the whole thing. It wasn't my intention to withhold help, but this is an official document and I didn't want to post it publicly.

Don't feel like you are obligated to do anything. I asked for help; I didn't give an order.

Best,

Jack Hayes said:Like I mentioned before, I still think there is a fundamental flaw in the logic—specifically regarding who is entering what, where, and when. There isn't a clear link between those two tables and the two shifts, so formulas won't fix anything if the data itself is disconnected. 🤷

I'll send it over via PP

Jack Hayes said:Exactly. I don't want to be pushy, but I think there's a flaw in how this is set up. 😂

@hollowmaker11/">@@hollowmaker11:
One shift ends with a specific final state for the Apens structure.
The next shift starts from that exact point and reaches its own unique end state. There shouldn't be any reason for the second shift to mess with the first shift's data.

It’s because money was being moved and handed out during the shift. Since there were expenses, the structure changes. This means the second shift has its own distinct Apens structure. However, when I input the total sum of all Apens from the first shift's closing balance into the second cell, it correctly shows the starting state, but as soon as I touch the Apens table, that value changes too. What formula can I use to lock that transferred amount? That figure should stay fixed; once new entries are made in the left table, the new total should become the closing balance. Closing-Received = turnover.

Jack Hayes said:Why would that be an issue?
The starting balance for the second shift should match the closing balance of the first shift, but you need to use a formula instead of typing in the number. That way, there won't be any discrepancies because they will always be identical. For example, if the closing balance is in cell C2 and the opening balance is in D2, then D2 should just contain the formula =C2.

Unfortunately, that's not working... whenever I set it up that way, both cells change as soon as I enter numbers into the left table.

hollowmaker11 said:If anyone happens to know 😁

I have two tables. The left one works like a register, totaling the cash by denomination—for example,

50 units of $333
30 units of $167, and so on. The Total cell shows how much money is in the drawer. For the first shift, this Total cell also serves as my Cash Handed Over cell.

Then the second shift starts, and they enter that exact amount into their Starting Balance cell—essentially, the closing balance of the first shift becomes the starting balance for the second.

That’s where I run into an issue.

At the end of the second shift, when they log their denominations in the left table (since they obviously made some sales too),🙂 it messes up my Starting Balance cell. My question is: which formula can I use to lock that starting balance? I need it so that even when the second shift updates the denominations in the left table, the starting balance remains fixed as the closing balance from the first shift.

Thanks so much to everyone who takes the time to understand this and help out.😁

Does anyone 🙂

Does anyone happen to know 😁

I have two tables. The left one acts like a tally sheet, counting the cash denominations—for example,

50 units of $333
30 units of $167 and so on. The Total cell shows how much money is currently in the register. For me, this Total serves as the first shift's amount and also as the Cash Handed Over cell.

Then the second shift comes along and enters that same amount into their Starting Balance cell—essentially, the closing balance from the first shift becomes the starting balance for the second.

That is where I run into an issue.

At the end of the second shift, when they enter their own denominations into the left table (since they naturally made some sales, 🙂), my Starting Balance cell gets messed up. My question is: which formulas can I use to lock that starting balance? I want to ensure that even when the second shift updates the denominations in the left table, the starting balance remains fixed as the closing amount from the first shift.

Thank you sincerely to everyone who takes the time to understand this and help.😁

Walter Jackson48 said:For example, put this formula in cell B1:=IF(A1=1,10,IF(A1=2,11,IF(A1=3,12,""))).
So if I type 1 into A1, B1 (or wherever you put it) will display 10. If I enter 2, it shows 11, and finally, if I enter 3, it displays 12.

Thanks so much, you really helped me out. 😁😍

Hi everyone, thanks in advance for any help you can provide.

I'm building a spreadsheet for work and I want to set it up so that if I type the number 1 into a cell, another cell automatically displays $3.25.

If I change that same cell to a 2, I want it to show a different value, like $3.75, and

if I enter a 3, it should display $4.00.

I would be incredibly grateful if anyone could point me toward the right tool or method to make this happen.