• Import text from another excel workbook

    I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

    AenE15 pointsBadges:
  • Automatic date

    How can you set up a cell to activate the current time when another cell has data entered into it? Just want to track what time DATA was entered in the other cell.

    Bispo120 pointsBadges:
  • Current column name in Microsoft Excel

    Could someone tell me what the function is to get the current line number / current column name for cells in Microsoft Excel? Thanks!

    ITKE347,880 pointsBadges:
  • VLOOKUP in Excel 2007

    I have 2 columns on an excel spread sheet with the following formula; VLOOKUP(D2,$A$2:$B$2090,2,FALSE) if I copy from column one cell A(2thur209) it produces the corresponding name in column B, but if I type the same name it produces #N/A. What is the problem?

    Newkid4735 pointsBadges:
  • Put rows in numerical order

    I have data entered randomly and now I want to sort it numerically using a certain column as the numbers to sort.

    Kooka5 pointsBadges:
  • How to connect to quick 3270 secure screen through VBA macro?

    Hi, I use the following code to connect to quick 3270 macro and it also connect to the screen. But when I run the macro for the first time it works, but does not work when I run the same macro for second time. If I restart the mainframe then the macro runs. Below is the code. Sub getdata() Set...

    Anirudha0075 pointsBadges:
  • How can I retrieve an Excel file saved in Hotmail?

    I opened an Excel attachment in Hotmail and started editing. I saved it continuously but when I closed Excel and reopened, the file was gone. I'm running Office 2007 and Windows 7 64-bit.

    Mohanb5 pointsBadges:
  • How to collapse data in a Pivot Table in Excel 2007?

    I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collapse all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to collapse.

    Babyphat5 pointsBadges:
  • Compatibility mode

    My Excel documents are saving in compatibility mode. How do I change this?

    jlynkett75 pointsBadges:
  • Excel 2010 Second drop down based on first, not working

    I have tried a number of different formulas and data validation scenarios but I have not been able to get my second drop down to recognize the choice in the first drop down. I have a chart of sizes (including fractions) and several weights for each size. I want the weights in dropdown 2 to be only...

    jacktal5 pointsBadges:
  • Excel 2010

    The averages in several columns do not include the product in row 4. adjust the functions in these cells so that all products are included in the calculation.

    enforcer310 pointsBadges:
  • How to change shade color for selected cells

    How do I change the shade color for selected cells?

    woge495 pointsBadges:
  • Excel lookup and totals

    Find specified values in one column, and total vaues in other columns of the specified value.

    tcmichigan10 pointsBadges:
  • Excel function to identify combination of text and numbers

    I have a list of IDs (for example NSD2015, 751234, 92231J,V1819, GR5007 etc.)and would like to identify those from a list of thousands of IDs (each in a separate row in the same column). Tried VLookup but it appears that only works with values? Getting frustrated and I'm sure this is easy to do......

    topdrawer5 pointsBadges:
  • Excel 2010 question

    How do I execute fill right, fill down, and simply undo?

    DLemmon5 pointsBadges:
  • Excel Menu Bar disappeared

    How do I get the Excel Menu Bar back. I add it through the VB Editor, but once I closed and relaunched Excel, the menu bar disappeared again. I was told to search for *.xlb file, but could not find any! Please help.

    Furaha5 pointsBadges:
  • If-then looking for any text in a cell

    This is what I'm trying to do: If cell A has any text in it, then look at cell B and populate cell C based on what is found in cell B.  If cell A is empty, do nothing.  Is it possible? L.

    ExcelBeginner15 pointsBadges:
  • Find and Replace

    I have a spread sheet where I need to replace the space between each word with a hyphen. Since find & replace does not recognize space, is there another way to do this?

    needtobecloned15 pointsBadges:
  • Microsoft Excel

    Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and 20 rows with zeros amount...

    Senior1systemanalyst260 pointsBadges:
  • Copy

    Normally when I want to copy a group of cells they become highlighted in blue. One of the sheets in my workbook no longer does this. How do I restore this feature to that worksheet?

    tallpen5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following