sheet1

Hi all, couldn't find an answer to my specific question so I'm hoping some one can assist. I have a range of data in Sheet1 from A1:T5000. I have a Named Range called "Doc" which I have created in Sheet2. Here is an example of what Column A looks like in Sheet1: Column A Name1 Data1 Data2...

Hello, I have in sheet1 over 1000 rows, in sheet2 i have the rows that needs to be deleted. E.G.: Sheet1: A1: 50 A2: 500 A3: 250 A4: 300 A5: 540 A6: 532 A7: 483 A8: 349 A9: 212 A10: 132 Sheet2 (file with list that needs to be removed): 250 300 540 212 So, I want a macro that searches...

Could someone help me with this code please? From a d-click in Sheet1 I want to display a Comment that's in a different worksheet. Its location is SheetAC Col Jxxx. xxx is "The RowNumber" below. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel =...

Hi, This should be straight forward but I can't see what I'm missing. On Sheet 1 in Cell O4 I have the name of a Workbook (not the one I'm in) but it is open. On Sheet 2 I have the name of the current Sheetname in Cell P1 (which will be identical sheet on the Workbook I have the name of in...

Hi there, I am looking for a macro that I can use o unhide sheets in a workbook. I want to have three button in sheet1 for sheets 2, 3, an 4. Sheets 2, 3, and 4 will be hidden and depending n which button we click on in sheet1, they unhide. Also, when closing the workbook, I do not want to...

Lads, Hope you can help me. I have Table in Sheet1 consisting of 100's of rows and about 20 columns similar to below. I need formula in Sheet2 that looks through Column A Sheet1 and if it finds APPLE IN CELL then it needs to copy whole row into Sheet2 and same for PEAR. This need to be in the...

Hi everyone I am looking for a macro that will look through columns X, AA & AC which contain dates on sheet1. If any of the dates are more than 30 days old, copy the row and paste it into sheet2 under the last entry. Finally delete the row copied in sheet1. Thanks in advance

Hi there I hope that someone out there will be able to help me with what I think might be a bit of a complex macro (at least more comples than I am capable off :)) I will try to break down the requirements in a numbers of steps, please feel free to ask any questions for further details. Step...

HI there, I have a keno results table with 80 columns having numbers from 1 to 80 in Sheet1 I need to create sheet 2 which will link sheet1 to sheet 2. So when I update sheet1 then sheet 2 should be automatically get updated. Sheet2 should have Date as the first column and numbers 1 to 10 in...

Hi. I'm trying to link between two sheets. There are filters on both sheets. Sheet1 A1 has the data: Cheetah Sheet2 A1 is linked to Sheet1 A1 using the formula 'Sheet1'!A1 This works well until I use the filter to sort Sheet1. Then, the value on Sheet2 A1 now shows the data on Sheet1 A1...

I need to refine this part of my code, I was thinking maybe as an IF statement, So if dd(1) = "@" then data is pasted into sheet1 column A starting at row 2 dd(2) = "http:" or "https" then data does into sheet1 column B starting at row 2 Problem is the (2).innerText and (3).innerText can...

So I have a lot of ComboBox on my sheet1, I cant seem to activate it execpt if I go to sheet2, and then back to Sheet1. Then they function as intended. Is it possible to avoid this process, for it to function properly ??? Thanks in advance

Hi Guys I have the following link:- https://www.dropbox.com/s/bodv5s8100cq4t6/SALES%20JANUARY.xlsx?dl=0 I have sheet1 ,sheet2 and output in my excel sheet. I want to vba to autofill sheet1 as per below :- (1) From Sheet2 range A2 :A To Sheet1 range A3:A (2) From Sheet2 range...

Hi My following code at the bottom of this page, see below works fine, it extracts the data from a list of url that are on Sheet2 "URL LIST" and pastes them into Sheet1 Spider. I now need it to extract two sets of data I need the URLs and emails address and the paste them in in...

I have problem transfer data of cells from sheet1 to sheet 2 give me the data is not accurate in from sheet1 i hope to help me here the image you can see https://ibb.co/D7dSw5x https://ibb.co/qgjbmqm https://ibb.co/mCwNy2W

Hello - Here's 1 for everyone . . . I have a sheet with item numbers and their associated barcodes. If I do a simple 'Ctrl-F', I can find the correct one but using the scanner to try to scan the correct barcode from a laptop screen full of barcodes is proving difficult. So here's what I'm...

Excel 2007 I want Sheet 4, column E5 to return “OK”, if Sheet1 C20, Sheet1 K50, Sheet2 E 70 and Sheet3 J11 are all of same value. If all the 4 values are not same, then return “Not OK”. (May be text or numerical)

Suggest with deleting the selected data from sheet through userform, and paste in other sheet4 & Then make sequence of serial number(A column) in sheet1, from 1 to 1500. Help me for above query in vba excel.

Hi - I have data on Sheet1 A:Z. I want to search column A for text that is entered on Sheet2A5. Once that value is found on Sheet1, i want to copy from where its found in A to Z and down 6 rows. So if Sheet2A5 is found in sheet1A30 Sheet1A30:Z36 is copied and pasted to sheet2AB5. thanks!

Suppose in Sheet1, I have given the cell C4 the name "MaxValue" and MaxValue (C4) contains the value "100". Is there a way that a UDF called from any cell in Sheet1 can access the value in C4 using the name MaxValue without passing it as an argument? I am working on a UDF that needs a bunch of...