pasting

  1. T

    Cutting and Pasting using a Command Button

    Hi There, I have read a couple of forums on this but am still not getting it right. Lets say I have 2 worksheets. Sheet 1 and Sheet 2. I would like to have my command button do the following: 1. Cut the selected cell from my existing worksheet (this I have achieved albeit through assistance...
  2. N

    Pasting data containing a formula into a table modifies the formulas in the table

    Hi, There may be a neat solution to this already, but pasting copied data from one worksheet (A), to the bottom of a table in another worksheet (B) changes the formula in the table in worksheet (B), to the formula within the worksheet (A). I thought (hoped), the logic would be to preserve the...
  3. C

    Google Sheets: Decimal to Fraction Script

    could anyone correct my function. tired of copying and pasting this formula over and over. Trying to get it to work in a script. cell D3 is an example of what id like to input. Thanks https://docs.google.com/spreadsheets/d/13Dr8cFYFE9xNTGSYyFbAY4_vKjANavSa7GcSd-6hRhk/edit?usp=sharing
  4. Kernst650

    Copy range and skip blanks from one workbook to another using tables.

    Hello, I'm trying to copy a range of cells into a table. I want the code to skip blanks, and only enter the cells with information in them. However it keeps pasting all six rows, generally only the top line has information on it. This code works perfectly for what I'm doing, with the exception...
  5. I

    Practing vba code with copy and pasting , need help

    How do i go about consolidating this VBA Code for copying and pasting Sub Button24_Click() Sheets("General Information").Select ActiveWindow.SmallScroll Down:=27 Range("D53:F53").Select Selection.Copy Sheets("Mechanical Design Summary").Select Selection.PasteSpecial...
  6. N

    Pasting data from one sheet to last blank row of another sheet (Macro)

    I have 3 data files "Data1", "Data2", and "Data3". All 3 files are stored on desktop. I need help in pasting this data on Sheet1 of "Final Data" file one below another. Data in all 3 data files are not fixed and last row may very every time. This needs to be done very frequently and hence a...
  7. I

    Why is the table not populating correctly?

    I can fix the #N/A errors later. Im trying to match the row header and column header in the big table with the table on the left. But is not pasting the correct value where it should be at.
  8. T

    Paste Formula Issue

    Hi I am copying A4:BK4 that contains a combination of plain data cells and formula and I am pasting to A34:BK37 by selecting this full range of cells and "Pasting Formula" only. The formula are pasting ok but so is all the data from A4:BK4 and not just the formula as I require and just leaving...
  9. H

    Multiple Cells Cut and Paste

    Hi, Is there a way to code for cutting and pasting multiple cells that are not joined. So cutting E8, F3, G13 in sheet 1 and D1, H5 in sheet 2 and pasting to A3, B4, C7, E1, J10 in sheet 3? I have coded to do it individually, but i'm getting inconsistent results. I don't know if going back...
  10. B

    Macro code not pasting where I want it to

    Hello- the below code from my macro is not pasting in cell A1 on the sheet I want it to, but instead is pasting into a random place on the sheet. Can I add something here in order for the results at the end of my macro to paste in A1? *It selects data from another workbook and then opens...
  11. L

    Cutting and Pasting values in a range of cells, with losing cell formatting?

    I have a worksheet with many separate users. There are large ranges of cells being cut/copied/pasted frequently within the spreadsheet. The data is separated out into a nice clean grid using borders on the cell formatting. the issue is that when cutting and pasting the cell formatting of the...
  12. V

    Coping and Pasting with VBA on Active Cell

    Hi everyone, I am trying to copy and paste the value from B57 on the active cell using the code below, but right now it's pasting on D4. Is there a way to change D4 to be the active cell instead? Thanks in advance for the help! Sub copypaste() ' ' copypaste Macro ' ' Keyboard Shortcut...
  13. C

    my VBA Vlookup function pasting number instead of the original text

    I need help (first timer!). I have a little vlookup VBA to paste a text but it keeps pasting a number. (Application.WorksheetFunction.VLookup(Range("C1").Offset(i, 0), Sheets("example").Range("A:I"), 5, 0) example -- C1 has the lookup 4000 and the column 5 has a text 044356 the vlookup...
  14. M

    copying and pasting ranges with hidden cells vba

    Hi All, my query is to copy and paste the data in other work book whereas some of columns need to be hidden before pasting the data. I have used below code but not getting prom results code : Workbooks("CustomReport").Activate...
  15. Z

    Formula ? on scrolling down

    Hi I am trying to scroll down all 3 at once and only change the number going from 8 9 10 11 leaving the letters the same. I cant figure out a way to do this and been copying and pasting and taking forever. =IF(Data!I8=0,TEXT(Data!I8,""),Data!I8) =IF(Data!J8=0,TEXT(Data!J8,""),Data!J8)...
  16. W

    PasteSpecial Error

    I'm copying (Ctl-C) tabular data from a website and wanting to Paste it into my spreadsheet. When I manually select the destination cell and type Ctl-V it works just fine. However, when I try Pasting it via VBA I'm getting the Run-time error 1004 (PasteSpecial method of Range class failed). My...
  17. K

    Excel Freezing when Pasting data consecutively

    Greetings, Context: I have three tables (formatted as tables) with the same data going into them. Each table has different formulas for calculating different things. Duplicates from each table are removed differently, to accommodate different reports, which is why there are three (in case you...
  18. T

    Unable to paste data copied from a browser - get a bell sound

    Hello, I'm using one of our (USDA - NRCS) applications that gives a table-like output to my browser. Sometimes there are less than 10,000 records with 11 columns. Many times this output is mostly null fields. But many times the output could be more than 10,000 records. What I do is run the...
  19. A

    Populating Column "A" after copy & paste

    Hi Again, Can anyone help me with copying/pasting using a userform. I have a master spreadsheet that I'm copying data from an pasting to a different workbook. I've got this bit working fine but once the pasting over has happened, I need to populate column "A" from a textbox value all the way...
  20. T

    Store a Row Location Before Pasting and then Paste to that Location.

    Hi All, I am trying to copy a cell from 1 sheet and paste it in another sheet After pasting a template. The problem is, I am using the paste after last row command but this mean that if I ever change the template dimensions, I would have to change the code. So I am trying to solve this problem...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top