paste

  1. A

    VBA grammar for sum of two fields in SQL table

    I have an SQL statement that sums up two fields and is working find in SQL Select w.Forecasted_hours + w.actual_hours as 'TotalForecast' however in VBA I'm not exactly sure what would be the right way to do it. If I paste the SQL it seem like not recognizing a plus sign. Can anybody please...
  2. M

    How to copy formula text ONLY from a cell then paste it into a cell in another workbook?

    Hi I'd like to copy the text of a formula in a cell, then paste that text into a cell in a different workbook, without the formula changing. I can't use 'copy' then paste special xl paste formulas, because the reference changes when the formula is pasted into the other workbook. What would...
  3. M

    Finding the end of the body of an Outlook Email

    I want to paste two ranges into an Outlook email. I can create the email, filter for the range, copy and paste the range. The problem is with where the second range pastes. In the first three emails, everything works correctly. Then, the code does not correctly find the end of the message to...
  4. I

    Advice for code copy / paste userform to cell range

    On my worksheet called Sheet1 i have a range I26:I35 with values in. My intensions are to press a transfer button on a userform & select a Month. This will copy the cell range values shown above to 1 of 13 possible paste locations on the same sheet depending on the MONTH selected from the...
  5. S

    Remember the last thing copied

    Hello ppl! I googled my problem before posting but couldn't find anything helpful so i decided to ask here. Is there an option to remember the last thing i copied and paste it after doing several actions in between ? For example > I have to copy some text and paste in one cell, than i change...
  6. H

    Offset after loop

    Hi All I would like to copy all non-blank cells in range R5:X7000 into the adjacent cell in Range K5:Q7000 as paste values. Essentially any non-blank cells will paste as a value in same row but 7 columns to the left. I have what I think is a good piece of code but need some help how to edit it...
  7. V

    formula/code/vba

    There is any code or vba or formula which can do the following 1. We are copying a data/formula 2. Now we want to paste it as values in a active cell, My problem is that every time data size is changed so formula/code/vba will work when we use that command/vba/code for paste values on that cell
  8. C

    Conditional formatting

    In conditional formatting I would like to highlight the whole row when yes is entered into cell M2 then each row after that. Sorry cannot paste table into here Thank you for any assistance <colgroup><col><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>...
  9. E

    Data Validation Circles Blank Cells Even With 'Ignore Blanks' checked

    I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find the...
  10. E

    Data Validation Circles Blank Cells

    I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find...
  11. J

    VBA Copy & Paste Data Loop

    Hello, I am looking for VB code to copy data from one sheet, and paste it onto another sheet in a different format. Here is the current format: <colgroup><col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="88" style="width: 66pt...
  12. A

    Chart expanding

    Hi Folks, I am currently working on pivot tables and charts. I have charts on one sheet and when I copy a pivot table and paste it onto the charts sheets the charts expand. How can I prevent the charts from expanding when I copy the pivot table or for that matter any text. The expansion is...
  13. T

    Macro to go up one line

    I have a form that adds data to a table, I have a macro that adds a new line to the table, but I would like to copy and paste as value the previous line once I've added a line. When I record the macro though it puts a specified range in but I would like to just have it say go up one line and...
  14. A

    VBA - Paste Data AS a table

    Hi all, Im using the below macro to copy filtered data from a table on one worksheet, and paste it on a new worksheet, below the last used row. This all works perfectly fine and as expected, but ideally i want the PASTED data (on Sheet4) to be pasted as a table. Is this possible and easy to...
  15. V

    Copy active sheet range and paste into new workbook

    I've seen various threads where many different variations of what I'm trying to do are explained but all seem to be just a tad bit different. What I'm trying to accomplish is write a script that will copy columns A:L in the active worksheet and paste into a new workbook. I would also like to...
  16. C

    VBA To find match of cell value and copy adjacent cell when match found

    Looking for vba code to see if data from 2 different cells on 2 different sheets if it matches then it copies the cell to the right on sheet 2 and pastes it to the cell on the right on sheet 1. All the data in sheet 1 column M is present on sheet 2 column A. So when it finds a match in column M...
  17. D

    Need help to find formula to replace copy and paste when handling massive data

    Hello Guys I need help to copy information from one column to another using an appropriate excel formula. I want to do away using cut and paste methods because am dealing with lots of data hence want to save time. My excel skills are basic but catch up quickly. So a step by step guide will do...
  18. K

    Combining multiple cells into one

    Hello! This is my first post on Mr Excel :) I am trying to collate a list of numbers so they have an exclamation mark at the start and a semi-colon at the end. I wish for these to all end up in one cell so I can copy and paste them into a business intelligence system that requires this format...
  19. J

    Help with VBA

    Hello Folks Ive had help to get as far as I have from people on this forum, thank you. but I'm after a little more help please. the code does what I need it to I just need a little tweak. it allows me to copy but when I select the next cell but it won't let me paste because it locks the cell...
  20. T

    Copy Row 2 and 3 from a closed workbook and paste it into my active workbook

    I'm trying to create a macro that sets up my reports with a header and spaces above and before the data Essentially what I want to do is add a column in the front of my data, add 6 Rows above my data, turn gridlines off, and open my workbook that contains my header and copy and paste it into...

Some videos you may like

This Week's Hot Topics

  • VBA code giving errors and stopping Excel
    Hello Experts, I have this code being used to loop through files in a file path, and copy specific data to another sheet. It is giving me several...
  • Disable MsgBox message
    Morning, I have a userform where if i leave a ComboBox empty i see a MsgBox warning me that i must enter an invoice number. It is this MsgBox i...
  • Macro Recorder into VBA, Copy Paste Data Filled Cells
    Hi Everyone, I have a macro recorder file that takes a selection of data, copies, then pastes into a new sheet on ("A2:B2") The issue is my...
  • Number format changes while pasting into a cell
    Hi, I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as...
  • Collating data
    Hello all. Could someone please help. I am trying to pull all column data from multiple sheets (24 I total so far) into 1 master sheet without...
  • Sum Multiple Columns Based on Multiple Criteria
    I am trying to consolidate data by summing columns G through M based on material, plant, vendor, and fiscal year being identical. The period does...
Top