copy paste

  1. J

    Auto copy rows from one sheet to another based on sheet names and cell values

    Private Sub CommandButton1_Click() Dim ws As Worksheet Dim ws2 As Worksheet Dim lastrow As Long Dim lastrow2 As Long Dim rownum As Long Dim ws2name As String Set ws = Sheets("RAW DATA") lastrow = ws.Cells(ws.Rows.Count, "E").End(xlUp).Row For rownum = 2 To lastrow Select Case...
  2. J

    Excel macro copy from a single sheet to different sheet

    I am using the below code to copy data from a sheet to different sheets if the sheet name matches with text of column E Sub CopyToSheets() Dim ws As Worksheet Dim ws2 As Worksheet Dim lastrow As Long Dim lastrow2 As Long Dim rownum As Long Dim ws2name As String Set ws = Sheets("RAW DATA")...
  3. T

    Googlesheet - How to skip empty cell in macro loop and continue filled cell?

    Hi, would greatly appreciate if anyone is able to help! I am working on editing a macro that involves vlookup copy/paste data from Worksheet A (IB) to Worksheet B (Inbound POs). However, it copies empty cell in Worksheet A and overwrites the filled cell in Worksheet B which i do not want...
  4. B

    Pattern Transfer: Excel copy-paste tool, for data transformation

    Hi everybody I'd like to share my Excel copy-paste / data transformation tool called Pattern Transfer: PatternTransfer.co.uk The tool allows you to configure source and destination data "patterns" so that you can transform the data structure of many records, quickly and accurately. There's a...
  5. A

    Change size when is pasting

    I'm trying to copy info from one file and paste to another file, but when it pastes, it changes the font size. I'm still learning VBA so I'm probably missing a something... ''' Sub Sites() Application.ScreenUpdating = False Dim InputFile As Workbook Dim OutputFile As Workbook...
  6. D

    VBA code or other solution to color cells white if they contain no data

    Hello everybody, I am currently facing an issue. I would like to create a code that colors my cells with a complete white background and no borders if they contain no data (numbers, letters, signs or anything else). Please see the following snip: For the blank cells from Cell A135-D135 and...
  7. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  8. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  9. C

    Cut/Paste row with specific condition

    Hello Team, am ready reach to a point that am stuck, cant find the proper solution, so i want some help from your expertise. basically i have 2 sheet, current employee (sheet1) and leaver employee (sheet2), to move the employee from sheet1 to 2 very simple, i use ActiveCell.EntireRow.Cut...
  10. A

    Where in my code can i insert or modify the paste as value snipped?, is pasting formulas.

    Hi, Sorry to bother vba experts. I have a code that it grabs values that match in a range in sheet1 and the matched cells copy on sheet2. But it pasting the formulas instead,, I need to paste as values. The problem is that i can't identify where to insert the paste snipped I'm sorry but for me...
  11. M

    VBA Code Improvement - Copy if date is less tan today -

    Hi, I am looking to improve this macro as it is really slow to run. Context: I want to copy 2 Columns (Room & Price Actual) into my Forecast columns IF the date is less than today. I need to copy paste with values. > I am looking for a code that paste using a range method as I believe it...
  12. L

    VBA to Copy data from many workbooks to one workbook

    Hello everybody, I just found a similar thread by fatman003 on https://www.mrexcel.com/forum/excel-questions/1112324-vba-copy-data-multiple-workbooks-into-master-wkbk.html. My problem is almost the same, but I couldn't adjust it for myself. I hope you can help me. I have an evaluation of...
  13. T

    VBA Copy Paste

    can anybody explain how to copy from a range of cells in a column and paste into a data driver cell. the thought is building the copy paste out so it takes the first number (sheet a cell b1) copies it. pastes it into a different page in lets say sheet b c4 goes back to the other page copies the...
  14. M

    Copying and Pasting Format Issue in Gmail

    Hello, I never had this happen before, can't figure out what I am doing wrong. I have a excel sheet that looks like this...(note the blank columns) But when I paste into an email, it looks like this...(note the spaces are no longer separated) DateTypeDebit"CheckNumber"...
  15. D

    Simple Copy Paste Formula Question

    Hi, I have a question, in my A1 cell thare is a value 35 no formula but if I copy it then paste > formula to B1 the value 35 from A1 is also copied why is that? I was expecting blank. Thanks
  16. A

    from sheet1 Copy w relative reference and paste as a value to sheet2 but next empty row

    Hi, My code copy and paste well, but it's pasting Formula. (i need to paste as value) i'm missing the spot where to insert the snipped to paste as a value to sheet2 Please can someone help me? This is my code ActiveCell.Range("C1:AE2").Copy...
  17. B

    VBA macro to copy/paste data from sheet to another

    so let's say I have to worksheets, Sheet1 and Sheet2. I would like to search for a column header in Sheet2, and if found, copy all the data in that column (except for the header) and paste it into a particular column in Sheet1 beginning from row 2 (to account for the header). I would then...
  18. Y

    Copy Paste Automation

    Hi all, i'm not very good with VBA. Will it be possible to copy and paste as values data from 1 workbook to another? Made a table as an example, both Workbook have 8 identical Sheets except for the data. Workbook1 contains actual data(with formula) while Workbook 2 contains projection(values)...
  19. R

    VBA - copy multiple column data in to a list

    I need a vba code to copy multiple columns from sheet1 and paste as list in sheet2 Here is current data format in sheet1 <tbody> H G H I J K L M 16 001/2018 002/2018 003/2018 17 8000 9000 9500 18 London NewYork Paris 19 GL acct Name Plan...
  20. L

    Copy a Formula in a Loop

    I have this formula, but if is more than to rows it doesnt work, maybe on a loop it will work, someone knows how to do it? Sub CopiaSuma() ThisWK = ThisWorkbook.Name LastRows = Sheets("Draft").Range("C" & Rows.Count).End(xlUp).Row Workbooks(ThisWK).Worksheets("Draft").Range("P7").Copy...

Watch MrExcel Video

This Week's Hot Topics

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
Top