vba & copy

Hello, I am trying to copy values from Columns R, W, X and Z from the Template (red pic) into columns A, B, C, D. I need a VBA to go through these columns until there is a blank row and then paste it into A,B,C as so it creates a nice list going down. I will need this code to continue multiple...

Hello All, New to this forum as well as VBA, so i would appreciate some insight. This is probably a simple fix, but i am not able to solve the issue. I have received the following error for the code in the module i am building. I have tried simple fixes ( adding and removing paste, changing...

Hello all I have the following VBA code Sub Create() Dim application If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine End If If Not IsObject(Connection) Then Set Connection =...

I have 3 sample files and I want to open/select 2 of the files and copy only the matching data between them into a third Master csv... I have included pictures of the 3 csv files with random data & timestamps. I am new to VBA so my code prolly isn't great but... File 1. Master Workbook = the...

Hello All! In my code, once I have created a query, I need to copy only the rows containing data in columns A-C. When using the code: Range(Selection, Selection.End(xlDown)).Select it appears all is well when checking with F8, but when running the whole code, the entire column is selecting...

Hi All, Please note I already have a code that works but I would like to do it faster. Dim X1, X2 as worksheet Set X1 = Sheets("DataBase Hierarchy") Set X2 = Sheets("Tool") X1.Select ActiveCell.Offset(0, -1).Copy X2.Select ActiveCell.Offset(0, 1).PasteSpecial xlPasteValues...

I've been trying to write this VBA code to automate the process of finding differences between 2 original source sheets and then copying the entire row of the differences into a new sheet. the process should be like this: The code should look into Column A for both source sheets, finding only...

I'm trying to copy a range of cells and paste them into outlook and send automatically. I've found the code before but can't find the right one

Good morning from a very grey UK. I'm having trouble getting my code to work, I'm trying to look in column M for the value "complete", then copy the entire row to another worksheet. Then, to look at column N for the value "complete" and copy the entire row to another worksheet. Then do the same...

Hi, I am trying to unzip latest file and copy contents in it and paste in different Path/folder. When I am using this code I am able to open the zip file which i mentioned and was able to paste it in destinationPath ub UnzipAFile(zippedFileFullName As Variant, unzipToPath As Variant) Dim...

Hi Gurus, Good day! Could you provide your insight on how the macro can paste the data from a worksheet to another with merge cells? Workflow: 1. I have a main data worksheet and files to update. Files to update on this case is same with State provided in Source worksheet. All State data...

Hi So, I have multiple workbooks (they are called: Human Resources, Science, Corporate Management, Public Affairs, .... I intend to add more). Each workbook has a sheet called: "Staffing-Processes". The data in each sheet has several rows (over 500 in some of them) I would like to be able to...

Hi, I have a sheet in a workbook that displays results based on a drop-down list in that sheet. For example, if you choose "Site 1" from the list it will show the data pertaining to "Site 1" in that sheet. There are about 100 different options (100 different Sites) in the drop-down list. I am...

Hello. I'm using this code, but can only seem to get it to work if I add a redundant column at the end of my dataset. In order to to that, I'm referencing column M, but in reality, I'd like to just be able to reference column H. I'm almost positive that it has to do with the offset and resize...

Hello, What I am trying to achieve here is the following: I have a column with filenames that includes the extension (in this case, .pdf) - these are plain values, not results of formulas I'm trying to create a macro that loops through the column (that starts at B2), use the values on each row...

In the code below I am copying and pasting data from my pivot table into two other sheets. At the end of the process the pasted area remains selected on both sheets. How do I remove that selection and just have the cursor in say cell A1 or wherever I want to leave it on those two sheets? I...

hi, I have 3 sheets in this attached file where I record information in the data sheet and it is saved in the Save_Data sheet. In the Admin sheet, how can I write a formula that by entering the date and user name, the registered information from the Save_Data sheet will be called and placed in...

I'm completely stuck and needs help with some fresh code. Need to do. 1.- Copy numbers from sheet Data, to another sheet, for example sheet 14, only column C only 4 numbers that cell no has color 2.- Create macro for the rest 8 sheets. Sub new1() 'declaring the worksheets, Sheet2 and Sheet3...

Hi All, This is my first post so go easy on me, also let me know if I am posting wrong. I found an old thread relating to this topic that included a code however there is one change that I would like to make and my coding knowledge isn't advanced enough to figure it out. I am trying to have a...