Відео

add client and remarks thank you...

Pls video link consolidation data

Also can we put names of person what product is issued to which person As I have to do for my manufacturing concern

Can we add alert for low balance in the final balances

please add the formula in the comment or description for easy copy and paste. Nice Video. Thanks

Indian rupees code sir

I have to add the Add In every time I open excel. Please help.

Hi Mr PK , I cannot seem to enter text into the text box after I come out of the design mode, I am using Excel for office 365

Really nice. I try to same on vba code. Bt it's really nice. This all function are available in 2019 version or ???.

I couldn't find the VBA code.. It's not in the description.

Thank you for that.

Thank you

What about when you need to update a specific pivot table when there are multiple source tables and multiple pivot tables in the same workbook?

Thank you sir

If you encounter the problem not working after u close it, i migth have the answer because i solve it i my own idk it this works on you, feel to reply here if need help

Thank you!!

Hi there, Thank you for the video you created. I have a question regarding the growth calculations. I have the data showing that the Actual Month-to-Date (MtD) for August 2024 is 27%, while the Actual for July 2024 was -16%. When I followed your formula, it indicated that the MtD percentage of growth in August 2024 is -269%. However, this doesn't make sense since there was an increase. Could you please help clarify the calculation and the formula used? Should I use the ABS formula? For example: =(Actual Aug - Actual Jul) / ABS(Actual Jul)? Thank you!

Link not working

Nice detailing, Can you please the practicing execl link. Thanks.

Hi...plz make a video how to consolidate 4 sheet mutlipl excel files to 4 sheet one excel file

Explained with great simplicity... I admire you for your in depth knowledge. Good work. Keep it up, Thanks.

Very nice 👍

Sir, I encountered a similar issue. Despite entering the correct date range, the listbox did not populate as expected. Additionally, when I double-click the listbox, I receive an error. The error points to the line: Me.Tb_id1.Value = Me.ListBox2.List(Me.ListBox2.ListIndex, 0). Could we kindly request an updated version of the file? It’s possible that the file might have been altered before uploading.

Sir, I encountered a similar issue. Despite entering the correct date range, the listbox did not populate as expected. Additionally, when I double-click the listbox, I receive an error. The error points to the line: Me.Tb_id1.Value = Me.ListBox2.List(Me.ListBox2.ListIndex, 0). Could we kindly request an updated version of the file? It’s possible that the file might have been altered before uploading.

Thank you so much ❤Sir

!!!!! Just a office girly passing by saying thank you so much for this video!! I made a pretty neat spreadsheet with your help from the video. I appreciate you so much!

sir good after noon hope you are doing well my name is mumtaz ali amd i am really thanks full to you for this kind of helpful videos i really appriciate you sir and kindly give me the contact number whatsapp i need a software from you. thanks

I stop at stock balance Product description i dont know what he said. any one help please.

people who do not know row and address function and never used vba would not undertsand what you bare doing

I cant sucess, it show # Name

Send out the sheet, if at all possible.

Hello.. Can you provide code for Ethiopian Birr?

Awesome!! just made the change to google sheets and its so different, thank you for you help!!

Brother can you give the training file

Hi teacher! If our products have many colors or size and purchest stock in product A in different cost ( Ex: TV sorry 32' on 01 Jan was $90 and 20 Jan we purchest stock in of Sony 32' is $100 ) so how could we manage these different cost of one product of Sony 32' to show of unit price of purchass in summery in inventory? Use which formular Sir? And in case one of product of TV sony have many different Inch and different case color, how could we manage summery of inventory ? Please make one show about these cases ❤ thank you in advance 🙏

How different between Google sheet and excel sir?

Hello Sir the download link on the description is not working

Beautifully explained brother. TYSM

no sample data file used here to practice SWITCH function. PLZ give the raw file. tnx

How do you make the date option on right click?

Thank you!!

Thanks for this

Good one

It worked, but why the data source from the table doesn't show all the search data in the search box?

Well nailed

🗞🗞🗞🗞🗞🧾🧾🧾🧾🧾🧾🧾📝📝📝

What is the year of this excel? Excel 2021?

The link is not working Sir

great video sir but i have a small dout is this dynamic

Exactly what I was looking for.