User form data collation

S

shankarnem

New Member
Joined
Jan 27, 2022
Messages
5
Office Version
  1. 365
Platform
  1. Windows
Hello..i have to collect production data of 20 team members on daily basis...thought of creating a user form and route that to an excel sheet to save data...but what is the best way to do that..because my team members are in different shifts and code should run even when my laptop is not on...any suggestions please ..thanks in advance..
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
shankarnem said:
Hello..i have to collect production data of 20 team members on daily basis...thought of creating a user form and route that to an excel sheet to save data...but what is the best way to do that..because my team members are in different shifts and code should run even when my laptop is not on...any suggestions please ..thanks in advance..
Click to expand...
Any response on this please
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
collating rosters
Replies
1
Views
137
gint32
G
H
  • Question
'How to' question about a Dashboard
Replies
5
Views
255
etaf
etaf
M
  • Solved
PDF's won't open in Sharepoint/Teams but will in C:drive Documents folder
Replies
3
Views
714
Mr_Ragweed2
M
G
  • Question
Trouble pre-setting userform values based off user input
Replies
2
Views
109
gc2001
G
I
  • Question
Import various cell values to user form
Replies
1
Views
179
ipbr21054
I

Forum statistics

Threads
1,215,537
Messages
6,125,393
Members
449,222
Latest member
taner zz

Share this page

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