in
All Tags » Excel (RSS)

Browse by Tags

  • Why won't the end key work in Excel?

    I have a column with information in some of the cells, and I want to stop at each of those cells in my macro. Using the "End" key, I should be able to make that stop at the next cell that contains data, but in the column I want to use, it doesn't stop. The column is the result of a simple...
    Posted to Visual Interdev (Forum) by microsoft on 06-17-2010

  • Copy and paste Data

    Hi, I need Experts help to create a VBA/macro. Copy data from column_B (List sheet) and paste at column_D if the value starts “F00”,”#” ,and “F01”. I have manually copied few data sample for Experts perusal. Hope Experts can help me to create this feature.
    Posted to Visual Interdev (Forum) by microsoft on 06-16-2010

  • Macro/VBA for Consolidate data

    Hi Experts, I need Experts help. Copy data from Column D,E,K and L (Database) to Column E,F,G and H (List) sheet if the data from Column_D (List) matched with data at column_C(List). I have manually copied few sample data for Experts to get a better view. Hope Experts can help me to create this feature...
    Posted to Visual Interdev (Forum) by microsoft on 06-16-2010

  • Copy value based on cell

    Hi, I have two worksheets. In worksheet two i have the following columns Country, currency, language, etc, etc, etc In sheet 1 i have a pick list for country and also two additional country columns. If they select USA, i would like the two columns in worksheet 1 for country, currency, language to automatically...
    Posted to Visual Interdev (Forum) by microsoft on 06-16-2010

  • Excel

    Hi, I have a date in the following format in cell A! (in excel) Thursday June 10 12:23:43 2010 I need to add 12 hours, 30 minutes to this. So I tried the following formula. =A1 + time(12,30,0) it's not working. Can you please suggest how to deal with this situation? Thanks, Rohit.
    Posted to Visual Interdev (Forum) by microsoft on 06-13-2010

  • Delete pictures on multiple sheets in an excel workbook

    Hey guys, I have a few excel workbooks with multiple sheets and multiple pictures on each sheet. What I want to do is delete ALL pictures in the entire workbook in 1 shot. I've looked everywhere and it looks like this can only be done with a vb script. Haven't programmed in a while but so far...
    Posted to Miscellaneous (Forum) by microsoft on 06-12-2010

  • Formula on Pivot Table subtotal only

    I have the attached pivot table and I would like to calculate column e - column f just on the total rows. How can I do this. thank you in advance for your expert advice. :)
    Posted to Visual Interdev (Forum) by microsoft on 06-12-2010

  • Copy and paste time value.

    Hi, I need Experts help to create a macro extracting time value from column-A and copied in Column-B. Hope Expert can help me to create this. Attached is the workbook for Experts perusal.
    Posted to Visual Interdev (Forum) by microsoft on 06-09-2010

  • Excel Macro - how to create cells and color then according to their values

    Hi All, I've recorded the following macro in excel, and amended it slightly with my very little knowledge (i.e. none!) of excel macros - so cannot get it to work! What I'm trying to achive is to write a macro that only calculates the total Elapsed in hours into Column F where there is a StartTime...
    Posted to Visual Interdev (Forum) by microsoft on 06-09-2010

  • Macro for identifying specific data in column

    Hi Experts, I need Experts help create a macro. Whenever we have “[LIVE]” word in column_F, at the same row in Column_E we need marked as “L”. If not indicate with as “R”. I have manually update sample data in Column_E for better understanding. Hope Experts can help me to create this feature.
    Posted to Visual Interdev (Forum) by microsoft on 06-09-2010
Page 1 of 387 (3866 items) 1 2 3 4 5 Next > ... Last »