sheet1

Hi I have 3 sheets and they are showing in the vba editor/project window as following: - sheet1(hello1) - sheet2(hello2) - sheet3(hello3) I am moving these sheets around using vba code and I want to make sure that sheet1 is the active one after whatever move I do. I remember once I used code...

Hi I have one sheet in a workbooks, and that sheet I can call it 1) Sheet1 2) Sheets(1) or Worksheets(1) 3) Sheets("sheet1") or Worksheets("sheet1") Sheet1, Sheets("sheet1") or Worksheets("sheet1") will always refer to that sheet no matter what except if the sheet name has been changed then...

Hi all, I have a tricky question regarding linking two cells in different sheets. I have a column of data in a worksheet (say Sheet1) that I need to be reflected in another worksheet (say Sheet2). So far I have no trouble. The difficult part is that I would like to be able to change the data...

Hi I want to add a sheet but I want to keep sheet1 as an active one. I named sheet1 as "Hello". Now when I run the code below, it will do these 2 things 1) Adding a sheet before sheet1! why is that? In excel when I click + to add a sheet, it will add it after the active one not before like what...

Mind blank. I have two workbooks. Workbook 1 is the reporting workbook, has 2 sheets in it. Sheet1 is called Data, sheet2 is Count by Member (where I have all the graphs and results set out. Workbook 2 gets labelled with the date that it was created on. This workbook is where...

Hi Experts! Here's my current situation, I have 3 different worksheets. Let's call them: Sheet1, Sheet2, Sheet3. - Sheet1 contains New Data that is delivered daily. - Sheet2 contains Old Data. - Sheet3 is meant to dump non duplicate values between Sheet1 and Sheet2. Example : Sheet1 contain ...

Hi I opened bran new excel file then went to vba editor. I see Sheet1(sheet1) and Thisworkbook, inside Project windows. I double clicked sheet1 and started typing this code: Sub abc() MsgBox "hello" End Sub Then I went to excel and inserted Button and assign it to that macro and I ran it...

sheet1 data: column C (material #) ; column F (salesman name) ; column G (Salesman count per material) = ? ; column H (salesman name) = ? sheet2 data: column B (salesman name) ; column F (material #) need: sheet1 , column G answer formula =COUNTIFS('New Materials'!B:B,Materials!E7,'New...

I have the following code which works perfectly. What I now wish to do is loop through all worksheet sin Wb except sheet1. I have tried to use a For Each Loop and an If statement trying to exclude Sheet1 but it wil not compile with the message that I have a next without a for. I have tried many...

Hi there, I have a excel sheet1 in which various cells reference cellvalues from the first row of cells on sheet2. (eg. Cell B15 on sheet1 mighthave the formula =sheet2!A1) I am trying to create a macro that will run my existingmacro (lets call it macroX) then change the references in sheet1...

I would like to prevent the user from leaving Sheet1 if certain conditions are not met. I'm using the Worksheet_Deactivate event in the Sheet1 module. However, when the user attempts to leave Sheet1 by selecting Sheet2, the Sheet2 Worksheet_Activate event runs even though I have...

In Sheet1, I have a list of 100 Dynamic IDs in Column D. Starting from D11 to D111 In Sheet2, I have a database of about 20,000 rows. Each ID ( from Sheet1 ) will appear only once in Sheet2.ColA. Need a VBA to delete rows, where the value in Column A is NOT equal to any of the 100 ID. In...

Can someone please try this and see if you get the same problem? In a new workbook, put the number 1 into cell A1. Then add a Data Validation rule, stating it must be a whole number greater than 0. Now in the VB Editor, put this is Sheet1: Option Explicit Private Sub...

Hi On sheet1, column B, I have a list of reference numbers. In sheet2, column A these may or may not appear. In Sheet1, I would like the Cell in Column B highlighted IF it does NOT appear in Sheet2, column A Blanks should also be ignored Many thanks

Hello everybody? Suppose in L10 the following formula: =COUNTIFS('Sheet1'!$H:$H;Report!$B29;'Sheet1'!$AF:$AF;L1;'Sheet1'!$M:$M;Report!$B$23) L1 is a date: 27/03/2019 In this case, the result in L10 is a number that considers in Sheet1 column AF only the records dated 27/03/2019. Now, I'd...

I have been searching for a formula how I can highlight duplicate data between two different worksheets but ignoring duplicates on one of the worksheets. I have tried a few formulas and macros but not getting the results I want. Hoping someone here is able to help. For a better understanding...

Hi - I have a workbook with 51 tabs, 50 named after a state and 1 other. I have a drop down with each of the states on sheet1. How do i use the values in that drop down to reference one of the worksheets? Each of the state sheets would be the same, they would just have different data. I have...

What I've been trying to do might not be possible, but I'll ask anyway... In my File on a Given Worksheet named "Main" - I clicked on View - New Window So Now I have MyFileName.xlsm:1 and also (now, not before) MyFileName.xlsm:2. Originally on my Main Sheet (Now +":1")- I had Sheet1, Sheet2...

Hi There, I need to create excel tab after every 2 minutes as per sheet1 in workbook and rename them as per SR.no provided in sheet1 like below. <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> SR.NO 1 2 3 4 5 6 7 8...