macro - copy/paste

Hello All. I'm creating a macro wherein data captured from SAP scripting will automatically pasted on another sheet of its last row i.e Range "A", what will be the starting script for this? Here is my sample script. I really appreciate any help you can provide.

I am a beginner trying to maintain my business data using Excel. I created a macro that copies the information from a sales info table and pastes it into an adjacent table that records the customer's name, items bought, total sales, etc. But when I rerun it the next row is not being used and it...

Hello, I have some pretty basic code that copies some data from workbook (ActiveWorkbook) to multiple named sheets in another named workbook. It checks to see if Cell A3 on the first sheet is blank and if it is, copies a bunch of data. One piece of data it copies is a specific number (between 1...

I have 2 sheets, call it ‘upload’ and ‘final’. There are calculations that are run behind the scenes I.e. other tabs that require Columns E:AN from the upload tab to be copied and pasted one at a time to the Final tab. Need a macro, that essentially does this. Copies E56,E61,E66 from Upload tab...

I named 4 different sections of cells as a range name, specifically sheet 2 a1:a5, a10:a15 and a20:a25. named it "split" I wanted to copy paste into same range on sheet 1 and named it "splittgt" It gets all the way to paste then gives me this error. "This action wont work on multiple...

Hi everyone, I'm very new to VBA, so really hoping you guys can help with this. I have a very painful that I need to do every week and I am trying to automate it to some extent to try and save some time (and my sanity!). I get a file from HR with the email address, name, title, and email+name...

Hi, I have an excel file where employees can submit projects they are working on and amount spent on the project each month. The names of the months are therefore in the columns as headers. When I make a PivotTable out of the table I have the persons in the Row sections and the month I want to...

Can anyone tell me why this macro takes over a minute to execute? Or perhaps offer an alternative way to do these commands? Sub Clear() ' ' Clear Macro ' Application.EnableEvents = False 'Move Stock Range("NHKStock").Copy ThisWorkbook.Sheets("Lanes").Range("AI4") 'Move Leftmost Lane...

I'm not sure if it's even possible, but I need help in the following: so far, I made a made to insert rows, by the value of D minus 1, each time column D is >1. The macro is working from bottom to top since its trickier for the macro to function if the last row keeps changing as its going top...

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 All, I'm making myself a task list, in this list i will have repeating tasks. Once the task is done (and dated) it needs to be done again (think how the laundry is in an never ending loop of despair). I'm VERY new to VBA and despite a few days of google searching (which I, previous to...

Hi guys, can you help me. I need a macro for this problem. Thanks in advance! :)

Needing a macro that can copy cells on a line in columns B, C and D to a variable range in those same columns defined by the next line of the spreadsheet that has text in columns B, C and D and then repeat. I have tried a number of loops but failed miserably. I have attached images of what the...

Hello Gurus, Do you have any thoughts on how to code this scenario (see image below)? I was thinking of using Cell I2 in SHEET 1 as reference in order to pull the info from the different sheets (specific Data sheet and Others sheet). Appreciate the thoughts. :)

I've been working on a report that I clean and collate using PowerQuery, and it's been fantastic. However, I'm facing a slight issue when it comes to taking the output (which has been split into worksheets, with one worksheet for each work group) and creating a new workbook for each sheet. My...

Greetings, I would like your help to create a macro excel to track numbers and copy to next sheet. Here can you find the excel file with the data. When we updated the data, we have to clear the rest of sheets, to copy new numbers. https://www.dropbox.com/t/9aKMLs4JnMAUkZom

Hello can somebody help with the following problem please? I'm trying to create a macro which I will then attach to a button. Macro steps: 1. Select next available row after row 3 on 'sheet2' 2. Insert current time of day into column B on selected row 3. Copy cell C7 from 'sheet1' and paste...

Looking for a macro that will copy a range of data and paste it repeatedly into the next available columns 'x' number of times. The number of times will be specified on another worksheet, cell A1. In the example below, data was copied from range B1:C4 and pasted into D1:E4 and F1:G4, so 2 times...

Hi, I need help, please. I saw a few options but nothing worked so far. My problem is this: I work with two sheets on the same file, "RawData" and "FinalData" RawData is summarized data from PowerBI and it varies in the number of rows. I added a column on that sheet with a condition, with Copy...

Hi. I'm looking for advice on how to update my simple macro. I would like it to copy selected data from Sheet 1, and paste into the next empty row in Sheet 2, before deleting it from sheet 1. Here's what I have so far: Range("B2:F2").Select Selection.Copy Sheets("Sheet 2").Select...