Question about Microsoft Office Standard for PC

1 Answer

Problem in copiying

We have a excel file containg 2000 records of customer.Just by entering name of the person we got the details of PhoneNo, and the address using vlookup.

If we required to get the data in other coloumns with the same excel file what is to be done?

Posted by on


1 Answer

Sorry but your description doesnt help and it is hard to understand what you want to do

Posted on Nov 17, 2007


1 Suggested Answer

  • 2 Answers

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

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.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


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



Related Questions:

1 Answer

I brought our aire fan at Home Depot last week. I installed yesterday. The fan is working fine but the light is not on. My fan is 56" Tidal Breeze LED distressed KOA. Please help

Hi Wendy:
I have found that Home Depot have been excellent at trying to ensure customer satisfaction.
My recommendation to you is that since this is a very recent purchase, you contact Home Depot. Customer Service Department as soon as possible. Request and record the name of the person that you are talking to, explain the problem, and ask how they can correct it. If there is not a simple fix, they will usually promptly replace a defective item.

Mar 31, 2016 | Dryers

4 Answers

Cannot open file. Error message reads: Excel cannot open

Use Excel Repair Toolbox is efficient corrupt XLSX file repair software, suitable for all data recovery activities, applied to Microsoft Excel documents.

For more:

Aug 03, 2015 | Microsoft Excel for PC

1 Answer

How to upload products

How to upload products -
While listing products on Amazon is a great way to sell your products and expose them to millions of customers, adding multiple items to your merchant account can be a time-consuming process. Instead of adding products one-by-one, sellers with Pro Merchant Subscription accounts can use Amazon's tools to upload product details in bulk.
1. Download Amazon's pre-built inventory file template from that fits your product category. This template is a Microsoft Excel file. You can use free programs such as Apache OpenOffice Calc and LibreOffice Calc to open and edit the file if you do not own Excel.
2. Open the template in a spreadsheet program. Each template has detailed instructions specific to your product category at the top of the document. Carefully read the instructions before entering your product details so you do not make any mistakes.
3. Print the "Data Definitions" tab in the spreadsheet. This worksheet includes important details on the acceptable values and formats you can enter into the template. Keep it handy as a reference when filling out the template.
4. Add your inventory items to the template. Pay close attention to template columns to make sure you enter product details in the correct cell. Enter details such as SKU, product ID, title, brand, manufacturer, description and more. You can also add bullet points to expand on the description of your item in the cells labeled "BulletPoint1," "BulletPoint2," "BulletPoint3" and so on.
5. Save the file in the .xls format when you are finished entering product details. In Excel, OpenOffice Calc and LibreOffice Calc, select "File" from the program menu, then click "Save As."
6. Save the file again as a tab-delimited .txt file, per Amazon's instructions. This is the file format needed for uploading on If a dialog pops up that says the file format does not support files containing multiple worksheets or something similar, click "OK." If another warning says the document contains features incompatible with the file format, click "Yes."
7. Log in to your Amazon seller account. Click "Upload multiple items," then select the template type for the file you want to upload. To completely replace all of the items in your inventory, select "Purge and Replace."
8. Click "Select File Upload," then "Browse." Locate your product file on your computer using the dialog box, select it, then click "Upload Now." After you upload the document, the page shows the status of the upload. Refresh the page to see the upload progress. Files over 5MB may take several hours to process.

Aug 05, 2014 | Work Safety

3 Answers

Lost Password excell word 2003/2010 All files unlocked gauranteed within 3 hours. I dont charge unless I open them. I will send you part of the document as proof. Confidence assured.

I cannot think of a better software than Office Password Recovery 5.0 for personal use. With the amount of passwords recovery solution, includes : word password recovery solution, excel password recovery solution, access password recovery solution.
still wait for what?download this software to unlock your excel password.

Sep 10, 2010 | Microsoft Word 2000 for PC

2 Answers

Source code for book store management system in c++

Book Shop Management System
BookMart is a book shop selling all varieties of books. It needs a console based application to manage its customer and business data.
Customers need to register before making any purchase. The registration system has the facility for the users to create their own user name and password. They can use the same for further communication with the system.

The user id and password should be stored in a file named “login.txt”.

The application should display the main menu as shown below

1. Login
2. New User Registration
0. Exit

Option 1: Login

If the user enters the option as 1, the user should be prompted to enter user id and password.

If the user has entered a valid user id and password, the message “Login Successful” should be displayed and the below menu options should be displayed.

1. View Books
2. Purchase
3. Back to Main Menu

If the user id and password does not match, then the message “Login Failed” should be displayed and the main menu should be displayed again.

Option 2: New User Registration

If the user enters the option as 2, the user should be prompted to enter a new user id and password. If that user id is not present in the “login.txt” file, the new details should be written to the file and the message “User Successfully Registered” should be printed else the message “Duplicate User ID” should be printed.

Option 0: Exit

If the user enters 0, the application should exit.
View Books
The book details should be maintained in a file named “book_master.txt”. The data should be stored as shown below.

Book ID ISBN Name Price Publisher

Sample Data

678 81-3434-343-3 Oliver Twist 500 PlaymorePublishers

When the user enters the option as 1, all the book details should be displayed on the screen with proper headings. For example, the output should be shown as below.

Book ID ISBN Name Price Publisher
678 81-3434-343-3 Oliver Twist 500 PlaymorePublishers
890 81-2456-343-4 The Tempest 800 Williams'sPublishers
Users can purchase after valid registration with the system by providing the book id.

The number of available books is maintained in a file called “stock.txt”. This file will have the book id and quantity on stock. As purchases are made, the total count should be reduced in stock.txt. Stock.txt will have data as shown below.

678 50
890 70

Purchase details should be written to another file named “purchase.txt”. This file will have the details as follows.

Book ID Name User ID User Name Price

For example,

678 Oliver Twist 11 Shubha 500
Back to Main Menu
If the user enters 3, then the main menu should be displayed.

May 03, 2010 | Intel C++ Compiler For Windows 7.1 Full...

2 Answers

Whenever I open a new spreadsheet now it automatically opens up a spreadsheet calles PERSONAL. Why is that and how can I get rid of it... I think it started after a did a macro but I am not sure. Thanks,...

You're right - it was caused by recording a macro. When you record a macro you are given the option to store the new macro in "This Workbook", a "New Workbook" (the default), or in a "Personal Macro Workbook". It looks like you selected "Personal Macro Workbook".
The recorded macro is stored in a special workbook called "Personal.xls". This workbook is loaded every time Excel is loaded. If you don't want this workbook loaded, then just delete it or rename it.
The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART On my Windows XP computer it's in C:\Documents and Settings\frogfund\Application Data\Microsoft\Excel\XLSTART. Depending on your computer your Personal.xls might be in a slightly different location. You might need to do a search using Windows Explorer.
If you are still having troubles finding personal.xls 1. Open Excel, 2. Open the Visual Basic editor (hit Alt-F11 or click Tools-Macro-Visual Basic Editor) 3. Click Tools-References to bring up the references dialog 4. Click on VBAProject in the list. The file location will be displayed near the bottom of the dialog box. Sometimes this might be cut off at the end, but it should give you a good idea where the file is located. 5. Click Cancel to close the dialog.

Sep 23, 2009 | Microsoft Office Excel 2003 for PC

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

Minimize Data Entry

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

Jan 02, 2009 | Microsoft Excel for PC

4 Answers

How to Export trial Balance from Tally 9.2 version to Excel sheet

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.

Mar 20, 2008 | Computers & Internet

1 Answer

Restict closing the main form when some controls on the subform are empty

Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

35 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2966 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18417 Answers

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

Answer questions

Manuals & User Guides