sheet

  1. A

    Link between multiple sheets required

    Hi , I have a excel workbook which has 60+ sheets. In that I have a common word in column A say name "SAM" in all 60 sheets but in different rows in different sheets. Example if Sam name is there in A4 in sheet 1 means in sheet 2 it might in A3 and in sheet 3 it might be in A2,etc.. Against...
  2. P

    VBA- Making Log/History

    Hi Guys! I have a sheet that is going to be used every day and i want to press a button and cut today's data and copy in a history sheet. Im kinda new to VBA but was able to cut and paste the data of the day successfully but when i press the button to log another day, the data overwrite the...
  3. A

    Pulling List of Rows from other sheet dependent on matching Cell Value? HELP See Pictures!

    Hello, I have a workbook with Sheets 1 and 2 with data on them. This template is on Sheet 3. The template uses the cell D5 to pull data from these different sheets to populate. You type a project number (Proj#) in D5 and the rest should populate. On "Sheet 1", I have a listing of all the...
  4. N

    How to add excel sheet into one file?

    I having two Excel Workbook (excel file) with one sheet for each. I want to add both sheet into one excel file (as 1 workbook with 2 excel sheet ) How to do that.
  5. S

    Copying a worksheet from a closed workbook to the active one

    Hi all, I want to copy a sheet from a workbook I have saved to the one I am currently working on. I need this code to be able to do this in any workbook I am working on. The code so far is as such: Dim sourceBook As Workbook Application.ScreenUpdating = False Set sourceBook =...
  6. Z

    (=sheet!) drag horizontally, column increment issues

    Okay so I've been struggling with this for a while and I can't seem to formulate my question that great either, bear with me please. So, I have created an excel sheet that collects exercise data into columns extending for several weeks. In my data sheet I am trying to collect these data points...
  7. M

    How to make a row auto populate

    Hello, Thank you in advance for your help! So I would like to have a separate sheet for certain data that is entered in another sheet, but all located in the same book. Is there a way to do this? For instance, if the text in cell D2 matches a certain criteria, then excel will auto-populate...
  8. D

    Using IPhreeqc in Excel

    I can't get excel to do what I want after creating this VBA script: Sub sbCopyRangeToAnotherSheet() LastColumn = ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRange.Columns.Count).Columns For n = 63 To 63 For i = n To n Worksheets("Data").Activate...
  9. TAPS_MikeDion

    Google Sheets (Excel) - Always highlighted sheet?

    Would anyone happen to know why every time I go to one specific sheet in the Google Sheets/Excel workbook I'm working on, that particular sheet has all of its cells highlighted? I'm guessing it's something simple I'm missing. Every time I go to that one sheet, even if I click a cell to remove...
  10. C

    Use formulae to check that 2 variables on sheet A appear in the same row on sheet B

    Hi I am trying to use formulae to check that the order number (sheet A, cell B4) and week due (sheet A, cell Q4 as YYWW) values are found in the same row of sheet B. The order numbers are stored in column E of sheet B, the due date is stored in column O of sheet B as WW. Note the order number...
  11. R

    Opening Hidden Columns in Excel Sheet

    I tried to open an old Excel sheet, and columns A through AM were hidden. I cannot open the hidden columns by using the Unhide action (highlighting the entire sheet). Any suggestions that would enable me to open these hidden columns would be appreciated. Thanks.
  12. M

    VBA - Copy specific headers help... check point

    Hi Team I got one vba solution on this site given by DanteAmor, if any header missing then I want to add message box for user and exit sub Option Explicit Sub copy_paste_data_based_column_headers() Dim sh1 As Worksheet, sh2 As Worksheet, a() As Variant, b() As Variant Dim i As Long, j...
  13. L

    VLOOKUP look for last cell

    Hi all, I have a workbook that has two sheets. Sheet1 and Sheet2. Sheet 1 will have employee names in column "C" The name will appear on sheet 2 in column "C" as well The times I want to lookup are in columns G and H in sheet2 I am using this formula below in column M and N in Sheet1 to find...
  14. P

    Help Matching Two Columns and Showing Non-Matching Values

    Hello, I am working on a project and it has been a while since I've had to use any VBA, so I'm saving the time and asking. I have data on two separate worksheets. I want to compare column B on Sheet 1 with column N on Sheet 2. Any values that do not match between the two columns I would like to...
  15. D

    Search Sheets Help

    I have an idea for a search sheet that i have no idea how to create, and am looking for help. I would like Sheet 1 to just be a search box and you can type in an address, and below it will be a table that will show the results that match your search. The matched search data will be stored on...
  16. Trevor3007

    find many based on a certain criteria

    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet 2 that contains a specific word ( ie Adobe) This would than display the data on sheet 1. A bit like vlookup, but vlookup as you are aware only picks...
  17. H

    Macros in a protected sheet

    I have a worksheet with a mixture of data entry cells and cells derived from formulas. I want to protect the formula derived cells so I have locked them and protected the worksheet (no password). I have various buttons running macros to perform bespoke filters. These are inoperative because...
  18. B

    Long, Difficult, Very Specific Problem on VBA Code for User Form Log In for Multiple Users

    I have a very difficult and specific request that I would like a lot of help with please. I have a very large macro-enabled workbook with around 260 sheets. Originally, I used some VBA code so that no matter what sheet the user was on when they saved and closed the document, the next time it was...
  19. J

    find the content of a cell in another sheet based on the content of a cell

    Hello, I'm looking for a macro to jump to a cell in sheet 2 based on the content of a cell in sheet 1. Basically what the macro should do is: Find cell A1 of sheet 1 in column B of sheet 2 and go to that cell. I've looked for a solution but couldn't find it. Hope it is a simple question...
  20. W

    RANK gives different rank for same value

    Hi guys, I'm getting totally crazy over the RANK-function. In this sheet, B2 = RANK(A2,$A$2:$A$3) and B3 = RANK(A3,$A$2:$A$3), and as you can see, it gives me two different ranks for the same value. These are constants (not formulas) and prove that the value is the same, formula in C2 =...

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