I gang

Visual basic- easy work.

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!

Evner: Visual Basic

Se mere: top work, sheets add, running excels, r.c. journal, night-fill, night fill, import journal, get my cash, cash count sheet, visual basic projects weekly sales, work up, m&r sales, get work, c sat, Visual Basic Excel, stay, SAT, formulas sheets, excel visual basic, easy cash

Om arbejdsgiveren:
( 3 bedømmelser ) Champaign, United States

Projekt ID: #71089

Tildelt til:


Hello again.

$80 USD på 1 dag
(54 bedømmelser)

5 freelancere byder i gennemsnit $75 på dette job


Can do this neat and clean.

$65 USD in 2 dage
(1 bedømmelse)

We have done more projects in Excel. Please check PMB. Thanks

$50 USD in 10 dage
(0 bedømmelser)

Please see PMB for details.

$100 USD in 7 dage
(0 bedømmelser)

Hi, I am very much interested in this job. I am from Hyderabad, India. Request you to please check ur PM now and get back to me ASAP. Thanks and Regards, Sai Kiran

$80 USD in 3 dage
(0 bedømmelser)