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!
5 freelancere byder i gennemsnit $75 på dette job
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