Visual basic- easy work.

Visual basic- easy work. is project number 71089 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider xamdam91
Budget:	$30-100
Created:	07/01/2006 at 14:49 EDT
Bidding Ends:	07/02/2006 at 14:49 EDT
Project Creator:	buzzharley   Buyer Rating: (3 reviews)
Description:	Another provider last night finished my macros for me. So I'm done with the big stuff. I decided that I wanted to add a couple more things to my excels sheets to make them easier, and finish filling in some formulas. (I already filled in all of the formulas in the sales2 sheet for days 1-32, then when I tried to import it erased all of the cells in the formulas and changed them to Ref. -- I don't have the time to fill them all back in. I have to get the excel sheet running ASAP!) -So here's what I need- The button "import comm2000 data" on the sales page moved to the top of the sales2 sheet. The only data that is not recieved by the register sales journal is the amount of actual cash in drawer (when we count down the register what amount of cash we actually have) So right now I have to enter the date- -Can I also make it ask for the cash- and whatever amount is inputed will go into column R of the sales2 sheet and in the appropiate day row? -In the sales2 sheet- I count a weekly sales as Sat-Fri. Now every new month the days of the week won't match up with number of the day- Without changing the name of the days manually and then adding up sat-fri on a calculator. So if possible I want it to know where the break is between Sunday + Sturday to tell me the weekly total and then the monthly total. -I assume that all of my cell formulas in sales2 got replaced with REF is because the sheet wasn't protected? If not can this be changed in the macros. -Delete the sales page, I don't need it. At the end of the macros I want it to stay on the sales2 sheet! Additional files submitted: buzzharley.rar
Job Type:	Visual Basic
Database:	(None)
Operating system:	(None)
Bid count:	5
Average bid:	$ 75