Question about Microsoft Excel for PC

1 Answer

Minimize Data Entry

At the time of Order / Invoice entry, every time I don't wnat enter Customer Name and Address and other details. So, I want to maintain saperate Customer Data Master source file, from that source file every time my customer details should write/update in my invoice file. To identify I will keep customer ID as key number. Please guide me how to create source file and how to link both customer details source file and Invoice / order transaction file.

At present I'm using Excel-2003,

Regards
dutt

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 19 Answers

I will suggest you to create small application in .net for ths which will add some value and process your data;If you want to use Excel only make a master sheet with details and use it in other excel sheets

Posted on Jan 02, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Hi, I'm using v12.0 RPE for a fast food establishment. I just started delivery service. Is there a way to include the customer's address to the reciept? -- Thanks


Two ways to do this. Add them as a customer with there address. A good policy is to use their phone number as customer number. That way repeat customers are already available. Then go to SETUP, SETUP SCREEN, RECEIPT tab, PAGE 2. Under PRINT CUSTOMER INFO, check NAME AND ADDRESS.

If you are not interested in building a customer database, add a button at the bottom with the function INVOICE NOTES. After taking order, hit this button and enter address. It will appear at the bottom of invoice.

B Mattern
sysadmin@ccybernet.com
Please return and give me a favorable rating if this helps or is of value to you.

May 02, 2011 | Pc America Restaurant Pro Express

1 Answer

How to send mail from tally


E-mail a Invoice
To send a Invoice to a customer by email:
1. Gateway of Tally > Display > Accounts Books> Sales Register >
2. Select the required Invoice from the sales Vouchers
3. Click on Email from the button bar or press Alt+M

1. The fields on the Mailing Invoice form are automatically completed if you have given the required information during creation of the master records. Select No or press Backspace to change/modify the entries. Select Yes to accept.
2. The E-mail Server field is highlighted next. This is a mandatory field. The first time you use this feature in Tally, enter the name of your SMTP server, example: mail.btinternet.com. Subsequently, Tally will automatically display the SMTP server name. Refer to your Internet Service Provider (ISP) or network administrator for further queries.
3. The From field displays the name of your company entered in the Company Creation screen and stored in the Company Information Master records. You can also modify the default information. Press Enter.
4. The From E-mail Address field displays the e-mail address entered in the Company Information Master data. Enter your email address, if you have not done so while creating a company, or if you want to change the id.
• Enter the user name and password in Authentication User Name (Only if required) and Password field respectively if the mail server requires authentication.
• In the Format field a pop-up screen lists the three formats in which you can generate your email:
o ASCII (Comma delimited)
o HTML (web-publishing)
o XML (data interchange)
Select the type that suits your recipient.
1. To E-mail Address field is a mandatory field.

It displays the recipient's email address as entered in the Mailing and Related details during ledger creation. Enter the address if you have not done so while creating the ledger or if you want to modify the information.
1. Type the email address of another recipient to whom you want to send a carbon copy of the email in the CC (if any) field.

1. The Subject field is filled by default and displays the subject of your mail. You can change it to a subject of your choice.
• Any text you enter in the Additional Text field precedes the report in the recipient's mail program. You can use this field to type a message to the recipient.
• Additional Options provided in the form are:
o Include Post-Dated Transactions?- Set this option to Yes to include post-dated transactions.

Note: Additional Options may vary depending upon the type of report you want to email.

Print Preview: Use the Print Preview screen to view the document before emailing. This shows how the document appears in the recipient's email

Oct 31, 2010 | Tally Computers & Internet

2 Answers

Have a Chinese smart phone and need the detail setup for gprs rogers communication


WAP

***First Step***
1.Main menu --> Select Services
3.Select Data Account --> Select GPRS
5.Select the first entry
6.Edit the account name to whatever you would like
7.Edit APN to goam.com (lowercase), if not work, try "internet.com"
8.Edit Username to wapuser1
9.Edit Password to wap
10.Edit Auth Type to Normal
11. Save

Select Back --> Select Back

***Second Step***

Select WAP
1.Select Settings --> Edit Profile
3.Select the first entry --> Edit Profile
5.edit the name to whatever you would like
6.Edit Homepage to http://mymobilehomepage.rogers.com
7.Edit Data Account to the Name you established in the First Step
8.Edit Connection type to HTTP
9.The IP address is 208.200.067.150 and the port number is 80
10.Edit Username to wapuser1
11.Edit Password to wap
Select back or done
Select Activate Account


MMS

Select Messages --> MMS --> Message Settings
Select Server Profile
Select the first entry
Select Edit Profile
Edit Rename Profile to whatever name you would like
Edit Home Page to http://mms.gprs.rogers.com
Edit Data Account to the same data account you created for WAP
Edit Connection Type to HTTP the IP address is 172.025.000.107 and the port is 80
Edit the Username to media.com
Edit the Password to mda01

Select Done or Save
Make sure to activate the profile and you are good.


Restart the phone.

COUNTRY: Canada
CARRIER: Rogers

Internet Settings
APN: internet.com
USER: wapuser1
PASSWORD: wap
HOMEPAGE: http://mymobilehomepage.rogers.com
PROXY: 172.025.000.107
PORT: 80

MMS
APN: media.com
USER: media
PASSWORD: mda01
HOMEPAGE: http://mms.gprs.rogers.com
PROXY: 172.025.000.107
PORT: 9203


Mar 01, 2010 | RIM BlackBerry Curve 8310 Smartphone

2 Answers

I cannot have internet with th tv mobile n99i


wellcome ,you can call their service customer care line for it.

Jul 26, 2009 | Lands Phones

1 Answer

Downloading latitude and longitude


Do you want to enter them manually, or via USB?

To enter a location manually, using only GPS coordinates, try the following: Create any entry in your address book - it doesn't matter what you enter since you will be totally changing it anyway! Then 'edit' the address book entry that you just created, putting what you want in each data field. Finally, edit the GPS coordinates for this address book entry (note that you have to overwrite the whole entry, beginning with N, S, W, E and then the numbers). Save your changes and now you have an address book entry for that rig.

I do not know how to download this directly using the USB connection - sorry.

Jun 29, 2009 | Lowrance iWAY 600C Car GPS Receiver

1 Answer

My cellphone is reading gprs not subscribed when trying to download multimedia message. I have a ifone cect p168c My phone tells me GPRS not subscribed, I have AT&T. My phone is a CECT P168+


ATT Manual Set Up


WAP

***First Step***
1.Main menu --> Select Services
3.Select Data Account --> Select GPRS
5.Select the first entry
6.Edit the account name to whatever you would like
7.Edit APN to wap.cingular (lowercase)
8.Edit Username to WAP@CINGULARGPRS.COM (UPPERCASE)
9.Edit Password to CINGULAR1 (UPPERCASE)
10.Edit Auth Type. to Secure
11. Save

Select Back --> Select Back

***Second Step***

Select WAP
1.Select Settings --> Edit Profile
3.Select the first entry --> Edit Profile
5.edit the name to whatever you would like
6.Edit Homepage to http://device.home
7.Edit Data Account to the Name you established in the First Step
8.Edit Connection type to HTTP
9.The IP address is 066.209.011.032 and the port number is 8080
10.Edit Username to WAP@CINGULARGPRS.COM
11.Edit Password to CINGULAR1
Select back or done
Select Activate Account

MMS

Select Messages --> MMS --> Message Settings
Select Server Profile
Select the first entry
Select Edit Profile
Edit Rename Profile to whatever name you would like
Edit Home Page to http://mmsc.cingular.com
Edit Data Account to the same data account you created for WAP
Edit Connection Type to HTTP the IP address is 066.209.011.032 and the port is 8080
Edit the Username to WAP@CINGULARGPRS.COM (UPPERCASE)
Edit the Password to CINGULAR1 (UPPERCASE)

Select Done or Save
Make sure to activate the profile and you are good.


For full help topics I have a cd available for 10 us dollars. Has 100's of mp3 ring tones wallpapers, and java games and opera java browser. Guaranteed help on every question ever asked on these phones. And all settings for all cellular services. I have answered 100 questions with this CD. If interested contact prestorose@aol.com Pay Pal only, will send out First CLASS Mail in padded envelope. If interested I will send Pay-Pal invoice that can be filled out and returned with instructions. Guaranteed safe transaction.

May 06, 2009 | AT&T CECT Unlocked i68+ Quadband GSM FM...

1 Answer

Invoice & Order Minimize Data Entry - Especially Name and Address


Do you have Microsoft Access? If so, you could use that to create a database and an invoice form. You could also use Access to "dump" the info into Excel to track and record.

Otherwise, try searching for "Import Data" in the Excel help. It would be very difficult to walk you through the whole process, but if you have specific questions about certain steps, that would be more manageable.

Jan 06, 2009 | Microsoft Excel for PC

1 Answer

1. A software company has the following information about its cl


Shouldn't you be doing your own school homework?

Nov 18, 2008 | Computers & Internet

4 Answers

I want to program a new number into my old A900 Samsung phone to replace my wife's old phone.


Hi

Surprsingly u never mentioned the name of the network which u r using. Please mention the CDMA server's name.

Thanks.

Supriyo DG

Jun 19, 2008 | Cell Phones

8 Answers

Canon LaserCLASS 710 Fax Owner's Manual


Set Speed Dial / One-Touch Feature
  1. Open One-Touch Speed Dialing Panel and press “Data Registration.”
  2. Under “Additional Functions” scroll to find “4. ADD. Registration” and then press “Set.”
  3. Scroll to find “1. 1-One-Touch Speed Dial” and then press “Set.”
  4. Under “Tel # Registration” scroll until the desired “One-Touch” number is displayed. Press “Set.”
  5. Under “Tel # Registration” scroll to find “1. Tel Number Entry” and then press “Set.”
  6. Under “Tel Number Entry” enter fax number (with “9” and the area code – ex. 913104454200) and then press “Set.” Screen will display “Data Entry OK.”
  7. Under “Tel # Registration” scroll to find “2. Name” and then press “Set.”
  8. Under “Name” enter the company name and press “Set.” Screen will display “Data Entry OK.”
  9. Press the red “Stop” key on the main control panel.
  10. The “One-Touch” feature is now set.
Label corresponding “One-Touch” button with company name.

Jan 30, 2008 | Canon LaserCLASS Fax 710 Printer

Not finding what you are looking for?
Microsoft Excel for PC Logo

108 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18357 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...