Guidance Needed: Efficient Data Collection and Liquid Stock Tracking in Excel

Azzam

New Member
Joined
Aug 27, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello MrExcel Members,

I would like to express my sincere gratitude for your continuous support and valuable contributions. Thanks to your efforts, MrExcel has become an invaluable source of knowledge and assistance in the field of Excel.

Thank you for all that you do.

I need to collect data monthly from 5 different regions. The data includes the month, type of fuel, amount consumed during the month, and consumed received and the remaining quantity.

Q1- How can I create a worksheet in an Excel file for data entry so that users can only enter data for their respective region ?

Q2- Than data gathering in anther my master file ?

Q3- What is the best way to track liquid stock, including technical adjustments, using Microsoft Excel?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,888
Messages
6,175,206
Members
452,618
Latest member
Tam84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top