Recent content by aggie81

Also, thanks for showing more than one way to achieve the same result. Take care.

Thank you for helping . The code works with the file on my pc with a change to the Sheet1 to match the Sheetx on the full workbook on my pc. I hoped to have it work like Ms. Gharani's video code where the code ran each time before print. She had a line at the beginning with Private Sub...

Want to take the first filtered cell in column V of table Production and print in the center of the footer based on the filter(s) I apply. To look something like this 4" Begonia Printed on Today's Date as dynamic value Sales from January 8, 2025 thru May 31, 2025 as static text I found two...

I have problems with my file that you wrote the measures for 2 years ago. I get the following error message but cant solve the problem. Are you willing and able to help. Thanks,

I figured it out by using a helper table by power query that contained only those invoice numbers with BOXING or COLD HOT. Then using IF and SUMIFS to get the correct price per unit. Thank you for looking.

I want to calculate the cost of a plant based on what the total costs to buy that plant from a supplier. I have attached a workbook with what I am working that a supplier sent. It is straight forward with most of the items with the exception when BOXING or COLD HOT fee is added in the column...

Thank you for sharing the link. Leila Gharani is able to take something complicated and explain it in simple terms and examples. All is working well.

Thanks for adding the totals, I was in the process of asking about it when I saw your message. I halfway understand the code you wrote but not fully. It is working well. I will create a new file next week and hope there aren't any problems.

I apologize I grabbed the wrong file to upload. The Pivot Table is on Orderstoplant tab. It should be populated. Again, I'm sorry. Thank you.

I use Power Query to transform data from Excel files into appends. There are two results that are loaded into the data model and a relationship is created between them. The data model is then loaded to a Power Pivot table. It works well enough but on the Description field on the pivot table...

Thanks Ken, it seems to be the simplest solution. Gig Em! Lee ('81)

That will return the correct week for January 2, 2022 but shifts the other days of that first week into week 2. January 7, 2022 returns a week 2 with the return_type 2. The closest to matching the wall calendar is with return_type 21 but it puts January 2, 2022 into week 52 of year 2021.

I use the formula Weeknum(a1,1) for a date that is January 2, 2022 but it doesn't return week 1 instead it returns week 2. I have tried various other first week dates January 2, 2022 thru January 8, 2022 and it won't return week 1 but week 2. I have used the other return_type handles but can't...

Thank you! It works very well.

I got the code to run but there is a Debug box that returns. The formula should go in the C36 cell. Thank you for being patient with me and helping.