different sheets

I'm new to all VBA concepts so I really need help. I have a file with 3 sheets. The first one contains clients from the UK and FR (this being column 3) , the second one clients only from the UK and the third one clients only from FR. I want a code that will update the second and third sheet once...

Hi, All, I see that this is quite simple but I am not able to get the formula. I am trying to average 3 sets of data from 3 different worksheets with a criteria to follow. I am using Excel 2010. Worksheets contain scores on a daily basis. Example: Sheet 1: Jan1-50%, Jan3-65% Sheet 2: Jan...

Hi, This seems fairly easy, but I haven't had much luck with searching for the answer on the web. I have an Excel 2010 table in Sheet 1 (FYI, table has headers with 11 columns). In Sheet 2, I would like to continually reference a particular column (Column 1) and its rows from the table in Sheet...

Hello everyone! I rely on your expertise for this! I need to compare two columns on different sheets and get all the non-duplicates on a third sheet. I would like the results on the third sheet to be red-highlitened and to show the the same row content present on the first sheet. The...

Hi eveyone! What I really need is a Macro that can compare three columns of data each on a different sheet. Excel 2010. Here is step by step what it should do: 1) Take columnB on sheet1 and compare it with columnA of sheet2 and columnA of sheet3. 2) The result of this comparison should fill...

Hello everyone, I'm trying to use VLOOKUP to search on a table in a different Workbook (which is also open, say Workbook 2.xlsx on it's Sheet 1) than the current (say Workbook 1.xlsx). I want to write the name "Workbook 2.xlsx" in a cell of Workbook 1.xlsx Sheet 2 and then just use INDIRECT to...

Sorry for the long title, but just wanted to try to explain my problem. I have 2 worksheets: "Results" and "Trend". I need a macro in order to: - select a cell in "Results" - copy the value of the cell - filter the first column of "Trend" of the value copied At the beginning of the process...

Hello =) I'm new to VBA I want to make a worksheet with a list of some sheets (within the same workbook) that are hyperlinks to those sheets. Example: I have sheet named "Summary" where I have a list of the rest of the sheets in the same workbook. The list shows the names of the worksheets...

I am new to macros. I have a requirement where i need the data to be splitted to multiple sheet. I have used the below code: Sub SplitData() mycount = 0 myrow = 0 Do mycount = mycount + 1 oldrow = myrow + 1 Sheets("Master").Select Do myrow = myrow + 1 Loop Until Sheets("Master").Range("A" &...

Thanks for helping in Advance I have some idea on how to design the userform, i need help with the code. If user1 enter the username and password correctly I want only the "sheet1" & "sheet2" to visible. is user2 enter the username and password correctly I want only the "sheet3" & "sheet5" to...