paste

  1. gravanoc

    Accessing an open Word doc from Excel causes "Locked for Editing" dialog to appear

    I'm experiencing an issue with exporting the contents of a Word document to PDF. After pasting a table from Outlook into Excel, certain parts of the table are retained, then the new table is pasted into Word. The Word document is saved using a specific filename, the date, and a number to...
  2. R

    Copy error - range is cutting and pasting to wrong sheet

    My code below: Sub arrange() 'all declarations for wkshts and wbs stated at top unless stated here Dim g1 As Range Dim g2 As Range Dim g3 As Range Dim g4 As Range Dim g5 As Range Dim g6 As Range Dim g7 As Range Dim g8 As Range Dim g9 As Range Dim g10 As Range Dim g11 As Range Dim g12 As Range...
  3. Woozypictures

    VBA Code to copy specific rows from one sheet to another, based on cell value

    Hi All, I've been using this fantastic forum for previous VBA issues I've had, seeing other peoples posts and using the brilliant answers people have provided, however It seems Im going to need the extra help on this one! I have a workbook that I use as a report for Aged Debtors, with a query...
  4. R

    Creating a variable list of columns and ranges to copy to another sheet based off values in cells

    I've got an inputs tab and 3 other worksheets in one wkbk. On my inputs tab, i've got cells I2:I14 that have column letters in it (A, AB, N, E, etc.) - these can be changed so they are variable. They correspond to the other worksheets within the wkbk. So 13 cells of columns to ID while...
  5. S

    Compare and Copy Data from Columns in One Sheet to Another Sheet

    I am looking for a VBA code/macros that does the following... Compare the data in a cell from Column A from Sheet 1 to the data in a cell in Column B in Sheet 2. If the data values are equal, then I want to take the values in the row from Column D in Sheet 1 and past them into the row in Column...
  6. R

    Search copy paste delete the workbook with date time in the name

    1. Open the file that has name, time and date 2. auto filter zero in a specific column "AL" and remove all the rows that has zero 3. disable auto-filter than save and close the file 4. copy the same file to another folder and paste it 5. delete the old file that is already there which is 30-45...
  7. B

    Copying Horizontallyand Pasting Vertically

    Hi, I am using the below code copying horizontally from one workbook and pasting vertically to another. but once pasting it's making a mess. Sub Alldrrdata() Dim sourceworkbook As Workbook Dim currentworkbook As Workbook Set currentworkbook = ThisWorkbook Set sourceworkbook =...
  8. R

    Copy multiple columns to end of range without using .Copy or .Cut

    I'm trying to get better at this and in doing so, I've seen over and over again to stop using .Select and .Copy/.Cut to move things I know I can move my columns with copy and insert no issue, but I'd like to step into the next level. On one ws, i've got columns P to AB and need to move them to...
  9. F

    VBA Copy Paste column to next blank column

    I have a data tab populating values for months running from Jan- Dec in Columns B-M. The current column is formula driven as it pulls values from a separate table/query in the spreadsheet that is filtered for the current month.. lets assume the current column is Column C (February)- “C2:C6” is...
  10. L

    VBA to copy rows where Date is greater than mentioned in cell

    I have a excel file with two sheets. Secon tab stored all previosu data and in the first tab I am adding new data every day. I need to comapre dates in column from 1st sheet and 2nd sheet and then copy from 1st tab only those lines where date is greater then in second tab (of course copy and...
  11. R

    Copy data on daily basis dynamically

    I have an excel sheet that contains all of my data named (Book1), and that excel sheet (Book1) updates on daily basis. What I want is to transfer the data for each date to another excel work book (Book2) on daily basis, without over writing the old data on the work book (Book2). For example if...
  12. I

    Mass Export Whatsapp chats to Excel

    Hi All I have recently used a VBA code, which works with selenium. The code allows you to use an excel spreadsheet to send messages via whatsapp, automatically. You may have seen the youtube video for the guy who wrote and offers the code, along with the spreadsheet: However I have vast...
  13. Jyggalag

    Have formula data appear as text, maybe VBA solution?

    Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...
  14. N

    Need advice about pasting sheets

    Hi guys, i really need your help! So I have many tabs of sales of products per week (so each tab is dedicated for sales of that week). It took me some time to manually calculate the sales of each product in that sheets. I was thinking to prepare the sheets for the upcoming week and prepare the...
  15. R

    Copying formats, then formulas down to dynamic last row not working

    What I'm attempting to do: copy all the rows from an open workbook, insert them into my other workbook that is a template, between to placeholders with formulas. my data in the template goes from A:CE. I've got the first part working where I insert the rows, but I don't know how to paste formats...
  16. P

    VBA Cut a row based off of the data in a cell and paste it into a table on another sheet.

    Hey! Hoping for some help once again. I have a table that tracks my rentals: Job Number: Job Name: Equipment rented: Employee: Company Rented from: Rental Start Date: Length of rental Estimated Due Date: Date Returned: Returned By: Total cost of the rental: Rental Complete Scissor...
  17. G

    VBA to Only Highlight cells with a Value

    Hello, I'm looking to edit this script such that if there is no value under the first row and then don't copy it. So only copy the cells with values inside Range("D11").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select...
  18. M

    Conditional format not working when pasting values

    I have a sheet with various conditional formats, I have noticed sometimes when copying value only into the work sheet that sometimes the conditional formats work instantly and some times i have to click into the cell and click back out to get it to pop. is there something I can do to get them...
  19. E

    VBA code insert, copy and paste with formula and formats for the Number of rows given as input.

    : hi all, please help me in the below vba code, as beginner in the work sheet, just want to insert the multiple rows through input box and insert after which row through input box. then i make which row to be copied through input box. i cannot paste the copied row to the number of...
  20. H

    Simply copy-paste(all) changes the font

    I am attempting one of the most absolute basic things in Excel -- copy a range of cells in one workbooks and paste them to another --- fonts, colors, values, formulas, EVERYTHING. Both files are .xlsx -- both sheets have the EXACT same font set for the entire sheet (Candara) -- yet every time...

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