different worksheets

Hi! so I'm very new with Vba in excel. i have a code that sends specific data (from excel files) to an access database. i wrote a code that loops through several hundred files and sends this information. The problem is to manually update these files, it is sent with a button. I need to override...

Hi. I'm a noob in this vba stuff and I need to solve a little problem. I have a worksheet named "File1" where I have some sales data and the same with a worksheet named "File2". I have 3 values among all the columns (val1, val2, val3) that I need to compare between the two worksheets. If the...

Hi all, I currently have a spreadsheet with a bunch of data over 17 different sheets, I need to create a macro to remove duplicate. The data name is 2016 data, 2015 data,2014 data and so on... The hardest parts need to identify different array (c,d,e,f) not the hold dataset to find the duplicate...

Hi All, I have 18 different workbooks saved in 1 folder (Workbook 1, Workbook 2, Workbook 3 etc) with the same worksheet names (Sheet 1, Sheet 2, Sheet 3 and Sheet 4), in all the 18 workbooks. I need to collate the data in Sheet 2 of all the 18 workbooks Sheet 2 of all the 18 workbooks has...

Hi, I need to look up for a range of values in all the available worksheets, and in case there is any matches, then colour the value on the original range. I have tried the following code: Sub Compare3() Dim WorkRng1 As Range Dim WorkRng2 As Range Dim Rng1 As Range Dim Rng2 As Range Dim...

I have seen plenty of codes online but none of them seem to work with what I'm doing. I have 2 worksheets. I want the code to run so that when worksheet 2 from column B to D is equal to any value in worksheet 1 from column B to D then delete the entire row in worksheet 2 ONLY not both...