sheet2

Hi Guys I have the following link https://www.dropbox.com/s/i77n2rc0c5pgfk7/transpose.xlsx?dl=0 Sheet1 is my data table and Sheet2 is the output. You will notice that there are five Ref Numbers which are the same(TV201801/000380). These Ref numbers are assigned to the name of the persons...

Hopefully I explain this clearly. I want to look up a value in Sheet1A5. Find that value in AA:AA on Sheet2, and then copy from that row in AA:AA down 6 rows and over to Column Z and paste it in A13 on Sheet2.

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 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 have code to copy sheets into a new workbook but what I want to do is, move one and copy the other. I.e. Sheet1 > move Sheet2 > copy paste special (to remove formulas) then save the new workbook with file name as per cell A1 of Sheet2 However, I need the user to specify their own path...

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

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

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

Is there anyway I can populate the data from Sheet 1 into Sheet2 based on the value of a cell in the row on Sheet1 For instance Sheet1, Column D, will have Yes or No in. Column A will have a unique reference number. If I have --A-- |--B-- 12345| YES 23456|YES 34567|NO 45678|NO 56789|YES In...

Hi I need to grab all the non-blank rows in a table in a sheet(Sheet1) to another sheet (Sheet2), whilst deleting any text that contains theword ‘off’ in column G. The non-blank rows will usually be in a group set so Ijust need to remove the blanks which are at the beginning and end of the...

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

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 everybody, I have a question regarding a task which I do at work and which involves excel. Since the real sheets contain sensitive information I've made two very simple example sheets which i attached below, blue is sheet1 & yellow is sheet2. I hope this is enough to understand what I...

Greeting, First of all, thank you very much for such a site and it has been so helpful for me. Problem: so I'm doing an almost daily task which I couldn't do it by macros, I'll explain it by an example; For example, let's say that here I have the following table in Sheet1: Order No Color S M L...

Hi to all, I’m trying to get the result in the following statement: Sheet1: Column A - I have the list of part numbers. Column B - I have location (A) Column C - I have location (B) Sheet2 Data: Column A - Part numbers repeated Column B - locations repeated Column C - Quantities The result...

​In sheet1, the value of cell A1 is [ABCD] including the brackets. Whent he code executes, the value inside the bracket should change to the contacts of the selected cell in sheet2. For example, If I select Cell A2 in sheet2, the contents on A1 in sheet1 should change from [ABCD] to [contents of...

In lieu of placing the array of sheets within the two procedures below, how can I use a third procedure to establish the array of sheets and then pass that argument? Sub ApplyAutofilter() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets(Array("Sheet1", "Sheet2", "Sheet3"...

Hi please can you help I have a combobox with a dropdown in sheet1, the data I want it to list is in sheet2 G2 to last row, please can you look at my code below and advise how to correct it. thanks again Private Sub Workbook_Open() With Sheet1.ComboBox1 ComboBox1.RowSource = ("Sheet2")...

The code below works great if I am on Sheet1, but what if Range("H3").Value is on Sheet2 and I am still on another sheet? Reason is because i want to save as CSV and that will delete Sheet2 Can't seem to get the syntax right Worksheets("Sheet1").Activate ActiveWorkbook.SaveAs...

Dear Sir, How can I Update My sheet1 data to Sheet2 without overlaping my existing data of Sheet2 with same font and font size. I also want to clear all data of sheet1 after updaing to sheet2 Using VBA code. Thank You in Advance.