many sheets

  1. S

    Condition two options, Vlookup 2 worksheets

    Hi, good evening everyone. I would like to ask question that I've been stuck for a very long time, so I made a decision to ask in this forum. Roughly, I have TWO(2) worksheets. One sheet is Onhand, another sheet is input. This is table for sheet Onhand, <tbody> Column A Column B Loc...
  2. S

    Updating pivots in different sheets with same source

    Hello, someone can help me? It's a little bigger thing, let me describe the problem. Need to write macro which will be changing data source for 10 pivots in 10 different sheets. The data source and range will be same for all pivots. I just need the body of macro, dont need the procedures which...
  3. N

    Copy date from Single Input to Multiple Workbooks

    I am creating a workbook for asset history where each asset has its own worksheet. This is continually updated as assets are utilized.<o:p></o:p> For of data entry I would like to have a single input table where usage and values on multiple assets can be entered. I am looking for a VBA code...
  4. J

    "Excel Vba" I’m need help with a copy sheet code!

    I have a workbook with many sheets one of the sheets is a Pivot Table. I would like to give the user the option to create a new sheet with the pivot table sheet and the sheet that contains its source data only. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>...
  5. C

    Dinamic charts in many sheets in one workbook excel 2003 vba

    Hi: I have the code below almost finished (there are 2 macros the first one , Macro4, does the charting perfectly in sheet1) and the second macro, Macro 5, makes the macro 4 repeat itself in each sheet of my workbook except for the first sheet. However when I attempted to run the macro 5 I...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top