#copy

I need to modify a bunch of excel files, for any row that contains the word "Skimmer", I need to move the value from column B (same row) to in front of Skimmer (always in column K) like this: (1)Skimmer, (2)Skimmer, (3)Skimmer. (The value in column B does not need to be removed) see below for...

I am working on a project that requires data from sheet1 to sheet2, where the data in sheet one has 3 subcategories. Each category is labeled under a number in column A which is in turn the heading in each column in the list. I have attached a link to a sample picture of sheet1 and sheet2. This...

Hello, I'm new to creating macro codes and I mostly use solutions from this forum to form the code I need. However, I have not found a coding that satisfies my exact purpose; therefore, I decided to form my own question for once. Thanks in advance to whoever who replies. Problem: The code is...

how can i insert the content in 'title' column in table 1 to empty cell in table 2 like shown below in vba and highlight the cell with red colour after that? i want to know how the logic will be. table 1 will be in sheet 1 and table 2 will be in sheet 2. <tbody> Date Process Title 25-Feb-13...

Hi, I'm having a problem with my macro, I run it from one sheet(A) and I need to copy cells from sheet(B) and paste it to sheet(C) but I could only make it changing sheets, there is any way to do that without activate sheets??? My macro: Sub VPL() Dim j As Long, i As Long For j = 1 To 9...