Devam Ediyor

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!

Beceriler: Visual Basic

Daha fazlasını görün: top work, sheets add, running excels, night fill, import journal, get cash, cash count sheet, work up, c sat, formulas sheets, excel visual basic, easy cash, data visual, cells, cash back, time sheet calculator excel, data excel work sheets, tried, macros excel basic, add macros, excel match count, excel protected cell, sheet excel visual basic, visual basic week, excel delete row

İşveren Hakkında:
( 3 değerlendirme ) Champaign, United States

Proje NO: #71089

Seçilen:

xamdam91

Hello again.

1 gün içinde 80$ USD
(54 Değerlendirme)
6.1

5 freelancer bu iş için ortalamada 75$ teklif veriyor

amanullahs

Can do this neat and clean.

in 2 gün içinde65$ USD
(1 Değerlendirme)
2.7
sathybiz

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

in 10 gün içinde50$ USD
(0 Değerlendirme)
0.0
bsoist

Please see PMB for details.

in 7 gün içinde100$ USD
(0 Değerlendirme)
2.0
asaikiran

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

in 3 gün içinde80$ USD
(0 Değerlendirme)
0.0