...sheet 1 data. (dont press enter yet.) Press the "+" sign and then click on the Sheet 2 tab. Select the cell on sheet 2 at the top left corner of the data table on that sheet. Now press "+" again. Now ...
Question about Microsoft Computers & Internet
...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 LOOKUP will do that for you - You can use ...
...data on sheet 2 column b matches the data on sheet 1column aa I need it to input that data on sheet 3 column a, but it's more complicated, if the above is true I need it to input the rest of the ...
...sheet. You save the data and next day you open the saved data and edit it and then save the edited data in the option save as and store in different name . I think this might have helped you . SAM ...
...data: Sheet 1 Building Floor Number Space Sheet 2 Building Floor Space The results should copy and paste the Not Match data from Sheet 1 and Sheet 2 then paste the Not Match result to Sheet 3. Thanks ...
...data in sheet 1 and columns with marks for each of 2 learning areas - one on each sheet. PROBLEM: I need to be able to sort across the sheets ie if the names get swopped in sheet 1 then the ...
Question about Microsoft Computers & Internet
...data on sheet one and for same the text format on another i want to copy data in the sheet having text format for particular cell reference which is there on first sheet Try using "Paste Special". ...
...sheet my data operator entered alot of duplicate date in a excel sheet to increase the no of count of data. i have to search every data by its pnone no how many entry of that no is in the sheet .then ...
...data. I lock and protect each sheet individually. Is there a way to lock and protect all sheet in a workbook at the same time without having to do each sheet individually? I have over 25 people who ...
...data on the active sheet and other selected sheets. To selectDo this A single sheetClick the sheet tab. If you don't see the tab you want, click the tab scrolling buttons to display the tab, and then ...
20 questions posted
Usually answered in minutes!
7,277 Questions
4,615 Questions
4,483 Questions
4,194 Questions
3,681 Questions