paste

  1. M

    PasteSpecial & xlPasteValuesAndNumbersFormats

    Hi All, I can't seem get my code to work where on the Input tab I want cell D4 to copy and paste just values and numbers into the B column on the KM Tab. There is a formula in D4 which is (=MAX(Detailis!B4:B51)+1) which results in 'D005' and will increase when new items get added to the list...
  2. M

    Find, Copy and Paste across all worksheets

    Hi, I'm really need help with this. Been trying to achieve this for the last 2 days. On my first worksheet, I have Values in column A and column B there are also values but they are hyperlinks. I'm trying to find the cells with the values from A across the rest of my worksheets and and replace...
  3. M

    Copying cell range (if not blank) to new row in table

    Hello, first post here - I'm not overly familiar with VBA but would really appreciate some help with this task - Background - I've created a fixed range of cells (on a "Submit" sheet) where a user can quickly input some data as required. The sheet is seven columns (with headings) with enough...
  4. P

    VBA- Making Log/History

    Hi Guys! I have a sheet that is going to be used every day and i want to press a button and cut today's data and copy in a history sheet. Im kinda new to VBA but was able to cut and paste the data of the day successfully but when i press the button to log another day, the data overwrite the...
  5. N

    VBA Copy, Find and Paste Values to Different Sheet

    Hi All, I have a file which is essentially a record of projects (+150) e.g. project title, leader, start date etc., and there is a second sheet containing some formulas to calculate project value. I'd like to be able to copy the calculations from sheet 2, and paste them as values on a specific...
  6. E

    Copy paste specific cells from a row based on cell value of column C

    Hi Everyone, I am new to the forum and I am great at Excel - whilst also being terrible at VBA! Which I guess in itself is an oxymoron. I am really stuck. I need to paste information from columns on one sheet to columns on another (not entire rows and in a different order). The source...
  7. C

    VBA / Macro Copy, Paste, Loop

    Hi All A little help please for a complete VBA / Macro novice. I am trying to automate the coping of data from one sheet to another whereby the macro I have takes all the data in the first data row (row 2) of sheet 1 ("Standard report - Items"), copies this to a new sheet, then selectively...
  8. 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...
  9. 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 =...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top