1. S

    Paste Multiple Selections

    Hi, I'd like to be able to paste two ranges from another workbook (the data source) to a final workbook using with two macro buttons (one in each) one will say copy and the other paste (in the final workbook). Copying seems to be okay as you can do something like the below or use a Union...
  2. B

    Keep Excel text formatting when transferring data to Word with Excel VBA

    Hi Guys! I'm using the following Excel VBA code to generate a WordDoc and then transfer text from my ExcelDoc to the WordDoc: Sub Generate_WordDoc() Dim WordDoc As Object Dim FileName, TagName, TagValue As String Dim CustRow As Long Dim WordContent As Word.Range With Sheet1 Set wordapp =...
  3. E

    Problem with macro to copy vba to new workbook

    Hi, I don't know if anyone can help, I am not that experienced when it comes to VBA, I have found the following code online & modified it slightly to fit my needs. I am trying to copy a module called PrintQTYPAGESASCELL() If I am honest, I don't understand what each line is doing, I think I am...
  4. B

    Excel VBA - Paste Data to Specific Tab Name

    Hello, I have a workbook containing two data sets, one on Worksheet1 and one in Worksheet2. Within each data set, Column A contains a standard mapping (this mapping is dynamic and is based on the rows of data). I have an existing macro that filters on Column A in Worksheet1 and create a new...
  5. R

    Create random list then keep it unchanged

    Hi, I'm using randbetween() to create a random list of ten numbers. Repeats are ok, so it's just randbetween(0,300) in every cell. After I have created the list (and without using VBA) I want to keep that list as text. So I'd want it to generate the ten numbers but then somehow keep them as a...
  6. M

    Convert VBA Application.Filesearch Copy/Paste

    I am trying to update some old code I used years ago to work in a current process. The code below, for every source workbook in the same folder, will open, copy a specific range, paste that range in a summary/master workbook, and close the source document. It loops through this process for all...
  7. S

    VBA Paste Date

    All, Need some help with date pasting, the sheet where the data comes from is a formula and the code that pastes is this Sheets("Sheet3").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:=xlNone, SkipBlanks _ :=False...
  8. S

    Copy and paste at each change in data

    Hi Folks, Looking for Some code to copy and paste but each time the data changes to fill in the blanks. So in column a and b have are the range. I want the code to copy a and a and paste it to the where b starts... then copy b and b and copy that to c.... and so on (the values in them cells is...
  9. G

    VBA Loop for copy and paste with search

    Hi There, Thank you in advance for taking the time to read this. I've tried to search for the answer but to no avail so I'm hoping some very kind person will be able to help put me out of my misery. I'm trying to search for a specific term within a column of a worksheet, if that is found...
  10. Q

    Code works however, I need it to only bring in the values, not the formula

    I have vba code that matches up to a list of worksheets in a column, in column B i need the code (which I have, however just want the values) to relate to "D1". Please see the code I have already. Many Thnx Private Sub CommandButton3_Click() For Each wkSht In Sheets For Each cell In...
  11. C

    VBA copy and pasting into different tab at the end of the last empty row

    i currently have this: Set wb = ThisWorkbook Set sh1 = wb.Sheets("Query") Set sh2 = wb.Sheets("Credits") Set sh3 = wb.Sheets("Duplicate") Set sh4 = wb.Sheets("Rev Rvsd") Set sh5 = wb.Sheets("Rebills") Set sh6 = wb.Sheets("Pivot") Set sh7 = wb.Sheets("Work") Set sh8 = wb.Sheets("Removed") Set...
  12. bepedicino

    VBA, Copy, Remove Ants, Keep Clipboard

    I have the following VBA which copies a dynamic range. However, I want to clear the marching ants, but retain the clipboard so I can paste into another application. Can anyone assist? Sub CopyData() Dim a As Integer a = Sheets("Classification").Range("A" & Rows.Count).End(xlUp).Row...
  13. R

    VBA - Copy row based on text in cell to a new sheet into first empty row

    Dear all, I've been looking high and low for a macro that will help me copy a certain row based a specific string in a cell to a new sheet and the first empty row in that sheet. Please help me figure this out. Context: - One Excel file - Two sheets "JiraData" and "Dash". Please note that...
  14. bepedicino

    Disable Copy and Paste for Specific Range, VBA

    Looking for VBA code that will disable copying and pasting "only" for a specific range in Excel?
  15. A

    Applications blocks Subroutine from continuing

    I want to automatize the following procedure: I want to attach an email after sending it to a document in SAP, but as soon as the "select Files:" windows appear my code is blocked from continuing bc this window belongs not to the SAP application itself (I don't know if these are the correct...
  16. J

    Copying data with same headers from sheet 2 to sheet 1. VBA???

    Hello everyone. I have had this issue for about a week now and it has been killing me slowly. What I am trying to do is move data from “sheet 2” to “sheet 1”. I only need the values to move over from sheet2 to sheet1 (the headers are the same). For example, on both sheets lets say I have...
  17. P

    vba copy and paste number of times based off cell value

    I cant figure a vba code to do the following: --------sheet1----------- -----(A)---------(B)------ -----Qty.----Description 1]----3---------sofa----- 2]----1---------chair---- 3]----5---------table---- based on (sheet1 column A's value)......copy and paste (sheet1 column B's value) onto sheet2...
  18. N

    Copy, Paste into different worksheet until last row and Print

    Hi Members of MrExcel, I am in need of help and unable to loop my sheet. I have a workbook with 3 sheets 1) Input 2) Front 3) Printt In the "Input" i have to columns G and H with Dates for the month I am trying to paste the value from Sheets("Input").Range("G2") into Sheet...
  19. R

    Issue with a macro

    Hi guys, I am not an expert with macros, but, I have this macro: Sub CombineData() Rows("4:99999").Select Selection.Delete Shift:=xlUp ActiveWindow.SmallScroll Down:=-15 Dim Sht As Worksheet For Each Sht In ActiveWorkbook.Worksheets If Sht.Name <> "Master" Then Sht.Select...
  20. D

    Copy Paste two rows to two separate areas on another sheet

    I have Excel 2013. I need a macro that will do the following. I have two rows that need to be copied to another sheet, say "XXXYYY" at the bottom of different columns, in the first unoccupied row, depending on the name in cells C7 and C8 Row one occupies A7:J7 Row two occupies A8:J8 If the row...

Some videos you may like

This Week's Hot Topics