activesheet.paste

Hello everyone, I have recorded a macro and it works fine. I have 18 sheets that are numbered 1 through to 18. I would like this macro to loop through each sheet from 1 to 18 as I will need to extract data from each sheet about 4 times (I can change the range(D25) each time I run it. Thank you...

I am having a problem running a macro I originally created in one workook in other workbooks. The code is a simple copy paste, remove duplicates, and sort alphabetically. However, I want to be able to run it without the original workbook open. I put it in VBA Project (PERSONAL.XLSB), but when I...

Afternoon, I have tried recording the below macro which looks to combine the data on 9 tabs into one tab. Problem I have is that the data on each of the 9 tabs is dynamic and may vary in number of rows. I believe I have identified the problem and have made the code bold and underlined. Any...

I have the following recorded VBA code to copy a value from a particular cell in to a new workbook and then copy the value from the adjacent cell in to the same new workbook. Currently it only runs for the two workbooks I recorded. Is there a way for the VBA code to run through all the workbooks...

I have two cells, O14 and U14 that contain variables. The code works when Cell O14=5 and U14 =1 and the code works if O14=3 but when O14=5 and U14 = anything else the last set of code for ELSE: does not run. What am I doing wrong? Sub Dump_Data() If Range("o14").value = 5 And Range("u14") =...

Hi there. I had the following Original Code, working well. The purpose it to feed a dashboard file with some source data, for analysis. What is being done is opening a file, copying the data into a "Stage" file, adding few columns with formulas, copy-pasting values, deleting some columns...

Hi all, I would really appreciate your help as I am struggling with one VBA, I've already spent a lot of time and I can not find the solution so I would appreciate your help a lot. Below you can find the code and the result: Sub rcalc() ' ' rcalc Macro ' ' Windows("BC...

All - I know this Macro can be cleaned - can someone please help me? I also wanted to know if I can change the value of my H and AH columns to only auto fill based from the value of number rows on B. Thank you so much!!! Rows("2:2").Select Range(Selection, Selection.End(xlDown)).Select...

Hello, I am having issues copying the same thing 'n' amount of times to every 'n' row. i have a range of cells and would like to post it every over and over again (i have a code to get the respective values). I do this several different times and paste it a different amount of times. Here is...

Aloha, I recorded the following macro and would like to extend the macro to row 1,000. The macro inserts a row, deletes column C, then cuts cells A5 and B5 and paste the cells in F2 and G2. It then deletes 8 rows. Then it repeats the process Thanks Sub Macro1() ' ' Macro1 Macro ' '...

Hi all, I have the following Macro but want to clean it up, Essentially it inputs a cycle step Number on one sheet then copies the values in a named range and pastes them into a another sheet by selecting a named range. Any help is much appreciated. The code Module is in the following...

I have this macro that I just recorded using the macro recorder and it is way too long and messy. I would like a more efficient way of how to do this (so I could write something like this on my own). I have 6 columns in a report where i want to insert a blank column, rename each one of them and...

What I need to achieve is as the second column below. I am a noob to VBA so any help will be much appreciated. <code>abc1200 abc1200 MACHINE supplier cost address invoice number abc2400 abc2400 MACHINE supplier cost address...

HI I am very new to VBA and i have done the code below where it transfers selected cells into another sheet into cells i have designated from a 'add' button, what i cant do is automatically add a new line when the 'add' button has been clicked on. Pleased can you help with the code below so it...

Looking for VBA help to complete this task... Goal is to copy and past from cells into a templet, print a defined area with this information then repeat until there is a blank cell. The macro for doing 1 row of information looks like this... How do I get the macro to loop until there is...

Hi Everyone, i was wondering if this code Range("A1").EntireRow.Copy Sheets.Add After:=ActiveSheet ActiveSheet.Name = "Pending" ActiveSheet.Paste Cells.EntireColumn.AutoFit Sheets.Add After:=ActiveSheet ActiveSheet.Name = "Closed" Worksheets("Sursa").Select Rows("1:1").Select...

Everything in my code works perfectly except the line marked below. Can someone help me figure out how to get it to find the next blank row and then paste. If I take the line of code out, it works but it replaces the previously saved data. Private Sub CommandButton1_Click() With...

I've read using the SELECT function slows down VBA. Is there an alternative method for the following code: Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets("SAR").Select Range("B62:U62").Select Selection.Copy Range("B63:U121").Select...

I am having a hard time inserting this formula into my macro, keep getting a debuggin error. My Macro is this Sub HWI_INV_CODES() ' ' HWI_INV_CODES Macro ' ' Range("A1").Select Selection.AutoFilter ActiveSheet.Range("$A$1:$BX$29470").AutoFilter Field:=6, Criteria1:="HWI"...

Hello everyone, I need some help. I'm trying to create a macro which converts a (really bad) SAP report to a good table with only the necessary info. The table is about vendors. Till the last step everything works correctly. But there is a little problem, the report contains the existing data...