allrounder
New Member
- Joined
- Dec 23, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi please support, I am looking for a solution to my below problem.
I am preparing a price sheet here (see below reference link) via which i wants to create the orde selection sheet.
Setp1: User press default button to make sure that the next person who will be using it will not make wrong entries. For this, I need a button in my main "select" sheet. Which will make all items (column B, F, M) =0 and delete all entries from the order selection sheet.
Step 2: Now instead of taking data from different sheets, I will take data only from my main sheet " select" and select the particular items column B, F, M and create the order selection sheet.
Step 3: The order Selection sheet will contain the description item and price.
Please find the attached reference sheet link- .reference sheet.
I am preparing a price sheet here (see below reference link) via which i wants to create the orde selection sheet.
Setp1: User press default button to make sure that the next person who will be using it will not make wrong entries. For this, I need a button in my main "select" sheet. Which will make all items (column B, F, M) =0 and delete all entries from the order selection sheet.
Step 2: Now instead of taking data from different sheets, I will take data only from my main sheet " select" and select the particular items column B, F, M and create the order selection sheet.
Step 3: The order Selection sheet will contain the description item and price.
Please find the attached reference sheet link- .reference sheet.