different worksheet

  1. M

    Linking Data of a cell in the same worksheet from another excel sheet

    Hello Sirs, I have an excel file as drawing register showing the details of drawings received - such as Reference Number, Attachments details & Drawing Titles etc. (Say the file name name as "Register1"). I wanted to make transmittal for each item in another excel file (say file name as...
  2. M

    VBA Code Help Add/Delete Columns Based on Criteria in Different Worksheet

    Hello, I am still learning VBA but I have been asked to create a macro for a timesheet for my boss. It is a timesheet where each employee has time recorded weekly and separated by projects. The weekly start date is in Row 1 as a merged cell and the employee's names are in Row 2 followed by all...
  3. A

    Using VLOOKUP to pull info from another Worksheet - Not working!

    Hi there, I've input this formula to take data from a cell on one worksheet, and pull it into another cell on another worksheet. =VLOOKUP(R3,'[uk_beauty_browse_tree_guide._TTH_.xls]BEAUTY PRODUCTS (11.2.2016)'!$A:$B,1,FALSE) R3="Pedicure" The other worksheet Table_Array of Column A & B...
  4. Z

    VBA to colour cells if they are equal to or greater than another worksheet cell value

    Hi All, Please could you help me. I am trying to loop through the rows in my worksheet and then if the cells in a column match a value in another worksheets cell then I need it to change to colour of the cell. My Main table has about 50 rows and the headers start in row 2. There are 23 Columns...
  5. T

    Macro to format cells based on whether or not their contents are in a list on another tab

    So I have a range of cells, specifically A1:LH1100 on Sheet 2. Some of these cells are blank, some contain an ID number. On Sheet 1, I have a dataset which contains ID Numbers in column A, and other descriptive fields in columns B-E I am lookking for a macro that will go through each cell in...
  6. C

    Lookup or Index?!!!

    Hello Excel Gurus!! I am looking for some assistance to help my wife as the task i have been set is beyond me :/ I am looking to create a summary in a separate tab that show what jobs have been dispatched via 'Dispatched = Yes' from the two source pages. I would then like Excel to transfer...
  7. U

    Relative Reference - Formula to Goal Seek Using Cell on Different Weooksheet

    I am using Excel 2010. I want to use a relative reference to goal seek using a "ChangingCell" that is in a different worksheet... ActiveCell.GoalSeek Goal:=0, ChangingCell:=Sheets("Volumes").Range("O11") ... but I am getting an error message that the reference is not valid. What...
  8. S

    Syntax to input variable column references into formula

    Hi. I have an Excel 2007 workbook and on one worksheet it includes a formula all the way down Column H as follows: {=MAX(IF(NOT(ISBLANK('ReferencedSheet'!F$2:F$62)),ROW('ReferencedSheet'!F$2:F$62),0))-1} The worksheet it is on is not 'ReferencedSheet' but BaseSheet. I have tested it and it...
  9. A

    MS Excel macro to copy only specific columns

    Hello everyone. :) I need your help in building a macro that would allows me to copy specific colums from one workbook to another workbook. The first worksheet consists of Column A until Column DJ. A lots, rite. :stickouttounge: Of all of these columns, I just want to copy Column C, D, &...
  10. G

    Merging cells on a second worksheet

    Morning - Getting a little frustrated and need some help. Running Excel 2007 and I am trying to merge data on a second worksheet based on entries on the current worksheet I am using through a function. I tried macro recorder to get the syntax, but when I paste in to my function and make some...
  11. D

    Copying Data to Worksheet from UserForm

    Dear All, I've got a spreadsheet that contains a userform. My userform works and does everything I want it to do. I copy the data entered from the user into the sheet I want. I'd like to duplicate that data into a different workbook too. So, containing the userform in only 1 file, I'd like to...
  12. B

    Countif based on range in other column

    Hi there, I want to list cell values from different worksheets into the blank column below. These worksheets are named ("Case 1", "Case 2" through to "Case 10"). This cell value in question, can be found in B1 of each of these worksheets. The value that determines what below row they should...
  13. S

    Specifying what worksheet a macro should be executed on?

    I'm putting data off the internet and refreshing it in real time. The problem I'm going to run into is that occasionally the website I'm pulling from will but unwanted characters in a certain cell so I was going to use a macro to circumvent this if it happens by doing a little copy, text to...

Some videos you may like

This Week's Hot Topics

Top