different worksheet

I'm working on this bit of code which returns the first match as the result. Looking for some guidance or help to rewrite this to account for multiple matches - Criteria 2 is quite important as it changes later on in the data and needs to be accounted for (I feel I had to mention this as the...

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...

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...

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...

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...

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...

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...

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...

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...

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, &...

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...

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...

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...

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...