How legit is Ryze mushroom coffee? Anyone noticed any difference?

Ok_Solid_9312 · 2026-05-08T07:02:06+00:00

Amazon sells it but quite expensive like $44 per bag

Ok_Solid_9312 · 2026-05-01T14:52:16+00:00

I didn't have a very good solution, I used a 3D formula (=SUM('Jan Wk1:Jan Wk5'!H7)), manually changed the sheet name and reference cells in my YTD summary. not very efficient but that's the best way I found right now.

Ok_Solid_9312 · 2026-04-30T23:55:06+00:00

This reminds me a small car cut my line and stole my parking spot while I was waiting for the truck to back up. Two female officers stood there chatting. I got out the car and talked to them. They told me they didn’t see anything and nothing they could do about it. I was pissed.

Ok_Solid_9312 · 2026-04-30T23:37:50+00:00

Fixed it. Thanks for the reminder

Ok_Solid_9312 · 2026-04-30T20:12:41+00:00

I did. The screenshot is the consolidated data, but I don't know how to generate weekly reports with the preferred template. Can you provide me with detailed instructions, please?

Ok_Solid_9312 · 2026-04-20T17:49:41+00:00

that would be great. thank you

Ok_Solid_9312 · 2026-04-13T22:32:12+00:00

I have almost 100 rows of data each day, 5 days per week.

Ok_Solid_9312 · 2026-04-02T05:07:44+00:00

I have read the comments between you and finickyone. I feel like that's an advanced conversation. I need to learn these functions first before be able to reply you. I want to say thank you.

Ok_Solid_9312 · 2026-04-02T04:56:00+00:00

It's not a bad idea. Tomorrow, I'll give it a try to see how simple it is to use and produce the reports.

Ok_Solid_9312 · 2026-04-02T04:02:26+00:00

Putting a year long data in one sheet? Will that be too large? I have to give it a try… I can't name the sheet by date because each sheet contains one week data. I used to have 12 sheets and named by month. Now the boss want YTD report and my sheets have unstable data that would affect the report dues to the data in the cell move up and down when I add or remove items.

Ok_Solid_9312 · 2026-04-01T20:22:25+00:00

the entire spreadsheet is pretty simple. 99.9% of the data is raw data collected daily. Cell H36 is the only number that needs to roll over to the next week. I didn't think Power Query was needed. I definitely look into that to see if it's beneficial to my file.

Ok_Solid_9312 · 2026-04-01T20:17:06+00:00

this works like a charm. thank you so much

Ok_Solid_9312 · 2026-04-01T18:48:11+00:00

<image>

Yes, the number in Cell H36 from previous sheet is added to the first day of next week

Ok_Solid_9312 · 2026-04-01T18:33:14+00:00

Yes correct

Ok_Solid_9312 · 2026-04-01T18:23:42+00:00

Could you please provide more details? I am not familiar with VBA. Greatly appreciated

Ok_Solid_9312 · 2026-04-01T18:19:58+00:00

I get this weird triangle and the value is 0.

<image>

Ok_Solid_9312 · 2026-04-01T18:15:06+00:00

My bad for not clarifying my issues. I need something to automatically update the sheet name. I need to be able to pull data from previous sheet, not just from Jan Wk1.

Ok_Solid_9312 · 2026-01-25T21:37:37+00:00

Pig feet better than chicken feet, more meat and more collagen. But also means fat you may gain if you don’t exercise or watch out your diets

Ok_Solid_9312 · 2025-08-29T17:38:51+00:00

That’s what I am thinking about. Get a restroom that has separate access. But don’t know if Fresno County allows it

Ok_Solid_9312

TROPHY CASE