Question about Microsoft Computers & Internet

1 Answer

In my book i have 2 sheet in sheet one my master data reside in sencond sheet i have some data that data i want to check if it in my master data A colum if it is there value in the colum b should be posted in Colum C in sheet 2

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

LOOKUP will do that for you - You can use eithe H or V depenign on how your data is set in columns or rows.

Posted on May 22, 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

Tyre pressure on Isuzu bakiie 245x75x15 4x40tyre


welcome to the Fixya USA forum. (we call them Tires)
the famous (choke) forum with Zero KB, nor Bakiee trucks
not a single one,
nor books on same.(for same reasons, wink !)
if running non standard tires, (in USA the law requires stock tire data
on the dirvers (left) door jamb)
but when you dont use stock tires, then you get to be mr. engineer.
in that case every tire maker in the world publishes,
a tire TABLE (paper) sheet, called a data sheet.
this sheet, covers weight of car, and proper pressure to match it.

there are only 2 ways to do this. (above)
google how to measure tire foot prints.
getting the pressure correct, allows for maximum traction
under inflated, causes cupping of the foot print
over inflated cause crowning... both are a danger, on wet roads
or driven too fast like that.
tire.101, end.

Dec 05, 2016 | Isuzu Cars & Trucks

1 Answer

In duplex printing page sencond page printing down to up


There is usually a setting in the print software that asks you is you want to flip the flip on the short edge (top-to-bottom, like yours is doing), or on the long edge, which make the page print like in a book. Check and see if you can find this setting and change it to correct your problem.

Dec 23, 2014 | Brother HL2240D Laser Printer

1 Answer

I need the installation book to install it.


The power connector (Molex) has a red wire (one of four) - the data wire has a red stripe on one side - the red stripes go toward each other. If you have a 80 conductor data ribbonn cable, this is for "Cable Select" position in the shorting plug. If yours is 40 conductor, you are NOT cable select. The Master or '0' drive goes at the end of the cable while a slave or '1' drive attached to the plug close to the end plug. The other plug of course goes to the mother board. Look for a small '1' on the motherboard (red srtripe). Use either Cable Select (if appropriate) or Master (if appropriate) or Slave (if appropriate) when selecting the shorting pins on the back of the device.

For your info, the little connector you will find inside adjacent the Molex is called a Mini Molex.

The Master is where the device "C" should reside (and have your operating system). All other drive designations will be set by your BIOS.

If you need more help, go to www.seagate.com/support and look up your drive for complete instructions. I think they have downloadable "tools' there to help you as well.

I hope this information helps you ... Thanks for your quesiton @ FixYa.com

Feb 14, 2012 | Seagate DB35 ST3160215ACE - 160GB -...

1 Answer

How do I reset and erase all personalized data from the phone, before recycling it?


Click 1. Settings 2. Initial Setup 3. Master Reset menu 4. Master Clear
It will wipe all information you have entered into the phone. "Master Clear" will wipe out your phone book, pictures and all the other files you have saved.
If this helps, please rate. Thank you

Jan 22, 2011 | Motorola Mobility W376 Cell Phone

2 Answers

How can i export the data tally to excel


Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

tally-export-screen-300x82.gif

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

tally-export-ready-screen-300x81.gif

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

csv-file.gif

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.



Hope this is helpful. Let us know if the issue is resolved.





*Rating and Comments are invited for this solution

Nov 24, 2010 | Tally T2245 Matrix Printer

1 Answer

I HOW I EXPORT TALLY 7.2 DATA IN EXCEL FORMAT


Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls


Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

tally-export-screen-300x82.gif

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

tally-export-ready-screen-300x81.gif

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

csv-file.gif

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.


Hope this is helpful. Let us know if the issue is resolved.



*Rating and Comments are invited for this solution

Nov 10, 2010 | Tally T2245 Matrix Printer

1 Answer

Excel 2003 cell is highlighted, font color is selected, but the color on the screen remains black. When printing the color prints out correctly while showing black on the screen


to remove all formats....
i.e.
open another workbook....
copy all data from the present sheet to the new work book....
present workbook
select data/edit/copy

new work book
select cell edit/paste special/values

now do the formating/color/font/size etc in the new workbook and check if they work here

Dec 14, 2009 | Microsoft Office Excel 2003 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

1 Answer

Excel Formulas


Hi,
Try using a software called MacroRunner for Excel v1.0.. you can download this from the following link
http://www.filebuzz.com/fileinfo/21205/MacroRunner_for_Excel.html

Good luck.

Feb 05, 2008 | Computers & Internet

1 Answer

Consolidate few sheets under 1 excel


What version of Excel are you working with. Newer versions allow you to have multiple spreadsheets grouped together into what is called a, "Workbook." To view the sheets separately, you simply click on the tabs at the bottom of the workbook. The easiest way I know of to join spreadsheets together into a single workbook is to open all of them at the same time, then choose, "View / Arrange All," and they'll be small, but you can grab each one by its tab and drag it to the workbook you want them in. Then you save the workbook (give it a new name like, "Accounting Roll-UP," or, "Consolidated Books," or whatever best describes it) making sure to close all the (now empty) spreadsheets without saving your changes to them (or else you'll lose your 'back-up' data). Voila! You open one file, and all your spreadsheets are available with the click of a mouse.

Dec 18, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

76 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 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...