Our Members have a unique individual membership number that is imbedded into their RFID card.
I have a USB RFID reader for when they enter the space they can tap in, this will record the member number only, on our master-sheet called MEMBER LOGIN
Now what I would like to happen is:
When their individual number populates into a column A, then the following cells A, B, C, D in that row, will automatically copy into that individual members sheet.
Note the Sheet names are labelled as the company that the member works for.
There are however multiple members with the same company. So, the layout if this happens is: Member1 Columns B-G, Member2 I-N and Member3 P-U and so on within that sheet.
I have included a sample of the basic layout. Please note the Members name and company name has been removed to adhere to company policy.
Within the sample youll also see a VLOOKUP formula to lookup the member name and company name associated to that RFID number as well as a little VBA script to automatically update the NOW date and time.
The above is the fundamental requirements.
Although as an added bonus, is it at all possible: to have it when their number is registered for a second time, (tap out when leaving) to have the tap time copy into their individual sheet into the Time Out column, if not I dont mind manually entering this in.
Once this excel system has been created will there be an easy way for team members like receptionists to edit the workbook in a matter of minutes when adding new sheets, companies and members?
In Summary what I need is when a unique individual member number populates in column A, the cells A, B, C, D (A=Membership number, B=MemberName, C=Company & D=MACRO Time & Date) in that row atomically copy into that members individual company sheet.
So then at the end of the day, we are able to clear the Master-sheet while keeping the copied data now stored within their sheet.
Please note, the members enter and exit multiple times thought the day. Sometimes up to five.
We also need to be able to in future as the members numbers change, when we add new companies and sheets have this process to the new members, numbers and sheets.
The reason for this is to record all the members entering the space and produce a individual table summary at the end of month for each member.
If you believe there is a better solution to my requirement above please advise, as long as is meets the basic layout, Im open to suggestions.","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":339361},"skills":["Administrative Support"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-08-11T05:13:49+05:30","url":"https://www.toogit.com/freelance-jobs/MzM5MzYx"}
Remote Data Mining And Management Job In Data Science And Analytics
Find more Data Mining And Management remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekHourly Type
Remote Job$26.85
Cost Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
I am looking for someone with a background in customer service/sales to serve as an offsite contract New Client Intake Coordinator. As set forth in the attached job description, the New Client Intake Coordinators primary goal is to interview potent...read more
I run a business in London called BusinessMatters UK.
I want to set up on our Amazon accounto sell ebooks on various business subjects.
I need someone to upload these onto Amazon and provide ongoing support.
In the first in...read more
Organization of projects
Social media posts
Maintaining my online profiles at Xing / Facebook / Linkedin
Building and controlling an online team
communication
For the purpose of placing advertisement in social network, we need to rent personal accounts, registered in facebook in Latin America, for local people. You can still use your account any time you need, because we will need only your ad account. Thi...read more
Selecting the highest potential students has been the driving force behind our companys position as a top software engineering bootcamp.
To continue helping applicants through our admissions process, we are looking for a driven and detail-...read more