IAM ACCOUNTANT IN COMPANY OF TOBACCO
IAM NEW EMPLEY
SO I FIND ALOT OF PROBLEM ABOUT HOW I DEAL WITH EXCEL
I MEAN I NEED YOUR ADVICES OR RECOMMENED FOR HOW I CAN MAKE SMALL DATA BAISC FOR ACOUNTING
FOR EXAMPEL: I WANT LEARN HOW I COULD MAKE COMPLETE ORGONIZATION OF STORES
I WISH IF YOU WERE HELP ME OF THAT
THANK YOU SO MUCH MY DEAR
I WILL WAIT YOUR ANSWER
WRITE YOUR BEST ADVICES FOR ME PLEASE
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Place the numer to be update in one cel
In anither cel say cel=cel+1 because of the alpha "S" here you need to combine 2 things.
3 formulas in excel.
add 1 to val(3charactersfromright)
combining s with converted new serialnumer
Personally I prefer Foxpro for these tasks.
For large amount of numbers this is no excel task.
Have no english excel here. Look up the easy function types.
You need no visual basic for this.
Open the protected sheet... Go to edit and click select all. Go back to edit and click on copy. Open a new excel sheet, go to edit and click on paste. Now you have the copy of the protected sheet without the protection.
I would not open up the company file in 2009. Open your 2003 Quickbooks, make a backup and then restore the back up in 2009. If you do run into problems you might want to upgrade into 2006 and then to 2009. (you will need to find someone who can do this for you if you don't have a 2006 version. I can help you with that if you need it
Ur answer is simple.
Just keep a common database on internet for all stores & create website (ASP or PHP) or web based application(like Vb.Net or VB) much preferred.
so any sales occurs, it would be reflected across all stores,
so you can calculate total sales & remaining stock any any time and sort it or aggregiate it daily, weekly & montly..
you select the trial balace--and press Alt+E or click export---then the export details screen came,
Language: Default(all language)
Format: Excel (spreadsheet)
Output file name: trial bal.xls (any name you select)
Excel (spreadsheet) formating: yes
other details you select and accept the screen. then minimise or close the Tally, you open the tally file name at my computer. at the time you can see the file trialbal.
Dear gaddar, this is relatively simply. You see if one customer pays 7000 then when someone brings three customers that mean he has given a company business of 21000. Company pays the customer who brought others 2000. Now if you minus 21000-2000 = 19000 is what company earns.
And when they pay out i'm sure they deduct certain amount for processing charges and service charges. Thats how these companies make profit.
If that has solved your problem please press 'fixya'