Find Jobs
Hire Freelancers

VBA and connecting data from diff sheets

$30-100 USD

Në vazhdim
Postuar over 17 years ago

$30-100 USD

Paguhet në dorëzim
I run a restaurant and I need a easy way to connect my data and change my main schedule if an employee needs to change his/her work schedule (if an employee originally was scheduled 4-cl but now the can only work 6-cl so I need to change the time on the daily sheets, main schedule, and in the employee info sheet.) So it would be easier to just change the time on the specific employee's info sheet- and maybe have an update button that then changes the time on the daily sheet, and the schedule? Here's what I invision- -Have the employee fill out the employee application sheet. -Make the import button, create a new sheet in the EmployeeInfo workbook for that employee and name the sheet by the persons first name, and the first letter of their last name- Example my name is Mike Beaird- so when I hit the import button on my employee app it will a new sheet named MikeB in the employee Info workbook. -Then I need it to import the name, phone#, email, hours wanted, hours the "CAN WORK" -(On the the application the employee enters when the CAN'T work, so I need the macro to import the opposite of when they can't work into their employeeInfo sheet. It sounds weird but this is how the owner has always wanted it done? He's the boss!! lol -Then I need the can work (availability) schedule for each employee automatically put into the availabilty schedule (in the Main schedule workbook), and put in the phone # and email. Alphabetize by last name. -Then I need the Main schedule in each employees info sheet to be automatically put into the Main schedule Sheet, and put in the phone # and email. Alphabetize by last name. -Then I need to have the main schedule of each employee put into the correct daily sheet- If the employee works before 4pm on Monday then their name and time of work will be put on the Monday sheet, If the employee works at or after 4 pm then their name and time of work would be put on the Monday Night sheet. -Each daily sheet when opened should automatically input the right date. -Each daily sheet should also look at the schedule and find who the manager is for that shift - Find mgr and input the managers first name next to where it says manager on each daily sheet. -Also in the main schedule, availabilty schedule and the daily sheets I need the name of the employee to be hyperlinked back to their employee sheet. For example if I am working on Monday and I want to see what an employee knows how to do or not, I can just click on their name on my daily sheet and it will bring up their info sheet. Or if they are late and I need to write a note into their info sheet I can just click on their name and write in their info sheet about them. -Also if possible on each page have a Print button also to automatically print that page(app, info sheet, daily sheet, availabilty, main schedule) And have a close button on each page to easily close a page using the tablet pen!! And put in a workbook_close always save on exiting to not have to click save everytime when closing. We have tablet PC's to carry around for the manager to access all of this data during their shift. I would assume the best Idea would be to have all of these workbooks in the same folder. So when I get a new employee I will drag his/her application into this folder and open it and hit import.
ID e Projektit: 72597

Rreth projektit

14 propozime
Projekt në distancë
Aktive 18 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
Please see PMB
$30 USD në 2 ditë
0,0 (0 përshtypje)
1,0
1,0
14 freelancers are bidding on average $73 USD for this job
Avatari i Përdoruesit
Looking forward to working with you again
$100 USD në 2 ditë
4,9 (54 përshtypje)
6,1
6,1
Avatari i Përdoruesit
we shall be interested in understading the project further. pls see pm for clarifications required from our side and the company details. thanks, viv
$100 USD në 2 ditë
5,0 (1 review)
5,5
5,5
Avatari i Përdoruesit
I can do this project for you... But I can't download your files... It says 404-file_not_found. can you repost the files, or send them to me thru PMB. I need to check it first.
$80 USD në 2 ditë
5,0 (5 përshtypje)
4,5
4,5
Avatari i Përdoruesit
Our comments in PM
$100 USD në 2 ditë
5,0 (6 përshtypje)
3,1
3,1
Avatari i Përdoruesit
We are working with VB & VBA for the past 6 years. We provide after sale service as long as our client wants it. It's our passion to do programming and we could even compromise on our payment for this if we are alloted the job. payment is not so important for us. Customer satisfaction is much more important and our top most priority. No satisfaction no payment. Hope we would hear positively from u.
$50 USD në 5 ditë
3,4 (5 përshtypje)
3,2
3,2
Avatari i Përdoruesit
Hi I am having 8 years exp in development of various applications using tools like C/C+, VB, VC++, MFC, ActiveX, DLL,.net, MySQL, MS SQL and MS Access. I can develop good Application for you. Thanks & Regards Eswar Reddy
$40 USD në 10 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Thanks for this opportunity, am from Kenya and we will be glad to do this project for you, if you want a sample please PM us. beth
$80 USD në 5 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I can perform the project until the promised date with all requirements satified. If you agree, this wil be my first project in this site and it is very important for me to create an excellentwork as a result to get the highest rating and comments. You can find the details related my professional Excel and VB experiments in my PM. Thanks.
$30 USD në 10 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I like to help you Regards
$100 USD në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
hi, we have a good team of VB and VB.NET developers with experience in ERP, Hotel Management and Inventory Management Softwares. Pls contact with your yahoo id so we can get this started...best regards..manish PS: Maybe you should upload the files to a free server...or send me your yahoo id so i can get them from you.
$81 USD në 3 ditë
0,0 (0 përshtypje)
3,2
3,2
Avatari i Përdoruesit
Just give me a day I will get u the solution..
$50 USD në 1 ditë
0,0 (0 përshtypje)
1,4
1,4
Avatari i Përdoruesit
Hai, I will do this project for you. I already finished this type of projects recently. Lets say when to start. Thanks & Regards Balamurugan
$75 USD në 2 ditë
0,0 (0 përshtypje)
1,0
1,0

Rreth klientit

Flamuri i UNITED STATES
Champaign, United States
0,0
3
Anëtar që nga qer 29, 2006

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.