copy & paste text

  1. S

    Copy and paste a row of data based on the location of the active celll

    Hello Everyone, I am in need of a macro that, upon a double click, copies the data in a row based on the active cell being located somewhere on that row. Once Copied I would like it to paste the selected row into the next sheet in the next empty row. The first row is D1 to J1 and then goes...
    • sncr137
    • Thread
    • copy & past rows copy & paste text copy & paste using vba
    • Replies: 11
    • Forum: Excel Questions
  2. E

    Copy text only to paste into merged cell

    I know that the usual way to copy-paste text only is to Copy and the to Paste-Special-Text only, but this does not work in my case. At least in Excel 2010 (and I'm sure it is the same in all of them), when you try to do that and the destination cell is a Merged cell, you receive an error...
  3. Z

    Prevent Excel 2013 from distributing copied content into several cells when pasting

    Hi all, I'm trying to find a solution to this problem but I've been unsuccessful till now. I have data from an SQL Server query rselut that I need to import into an Excel 2013 worksheet. The SQL query result consist of only 3 columns but one particular column is causing me a lot of trouble when...
  4. L

    Copy a word from a cell with a sentence in it

    Hi, I am having trouble trying to write some code that will extract a word(s) from a cell that has asentence in it as can be seen below: <tbody> <tbody> (Class 4) (4yo+) 2m3f Heavy 10 hdles </tbody> </tbody> I have tried Text to Columns but when I change from Race to race the amount of...
  5. T

    VBA: Copy and pasting severall sets of equally spaced data from one workbook to another

    Hi Guys, I am currently trying to write a macro to cop and paste severall sets of data from one workbook to another. There are two parts to my problem: 1) The workbook name will be pasted into a cell which the macro will refference (the refference workbook will already be open so we do not need...
  6. B

    Select Text and Inserting into Pre-determined Text

    Hello, I am new to macro's, but I learn very quickly. <tbody> slot port 1 21 6 23 6 11 </tbody> I would like to select these 3 rows(or any number of rows) and insert them into text that looks like this: This will need a loop based upon selected rows? I don't know if this is...
  7. Gingertrees

    Copy different parts of text file, invoke text import, for file that changes daily

    (Reworded repost of http://www.vbaexpress.com/forum/showthread.php?t=39170 ) Overall questions (details to follow) =========================== QUESTION 1: Is there a way for VBA to search for specific data in a text file, copy a set length to another text file, before opening in Excel? QUESTION...

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