pasting

  1. D

    Adding copy-paste into loop VBA formula

    Hi everyone I have a quite simple Excel sheet with two tabs in it (Sheet1 and Sheet2) Sheet 2 contains numbers in row Q and hyperlinks in column T Basically any time when there is a number "1" in row Q, macro should copy paste hyperlink from reflective row to A4 in Sheet1, call few macros and...
  2. T

    VBA - pasting data in the last cell of a column

    Hi, I'm trying to paste data from cell L1 (the word "Rental") to the last cell in column G, but it's pasting in the wrong cell, it should paste in cell G40 as that is the last blank cell, but it's pasting in cell G6988 and then I want it to copy the word "Rental" to the last cell that has data...
  3. N

    Pasting in Data from File Path

    Hi, question on pasting in data from an excel file into another excel file - and I'm not even sure this possible, but wanted to see if it is. I basically want to have a macro that pops open a File Open Box that allows you to select an excel file. Once you select that file, the macro references...
  4. S

    Folder Names into excel

    How can I populate the names of folders into excel with out copy and pasting each of them?
  5. W

    Pasting a formula into a dynamic table column

    I am pasting a Vlookup formula into a table (information) that is dynamic. The formula goes fine, however I run code after that to replace #N/A with a 0. I have a line of code that finds the last row, however all my #N/A code does is find the last cell and place a 0 in it. Sub...
  6. S

    Avoid workbook recalculation (?) when copying & pasting.

    I use Microsoft Excel 2011 on a MacBook Pro. I have a large workbook with hundreds of thousands of values & related formulas in a handful of tabs referencing each other. Working in manual mode is very helpful. When I hit 'recalculating', it usually takes a few seconds, but not a very long time...
  7. J

    Pasting Excel Data Into Multiple Cells of a Webpage

    Hi All! Thanks in advance for the help! On a daily basis, I am taking hundreds of cells of data fromexcel and typing them into a webpage. With the webpage, each field of inputis separated by a tab. Is anyone familiar with a way that I could take thesehundreds of cells and get the data into the...
  8. D

    Pasting data at end of the data range, ignoring uniques

    Hey all, quick question, if Im having a macro for pasting data from certain sheet (that comes on daily basis) to general sheet and adding multiple data every day to it - I have a formula which is working just fine. Nevertheless if in that range are data that are already existing, is there a...
  9. M

    Copying and Pasting A List Not Matching

    Basically all I want to do is update the altmanwatchlist1.xls with the My Stock Screen.csv name and symbol/ticker data. I tried clearing the data and copying and pasting the name and symbols. They match on the names worksheet, but not on the atman watchlist worksheet. File I made but data...
  10. C

    Pasting some big formulas

    I am pasting a large amount of formulas. Is there any way to check that I have not stalled excel. I do not yet see a progress bar. The little circle keeps turning, is there any way to see if this has not stalled for good. Usually I will just wait for a period of time and then reboot. Is there a...
  11. C

    Help with a formula reference

    Hi all. Is there a way to amend the formula below so that it references column B and not B2 when pasting Into any cell in column B. =IFERROR(INDEX(Sheet3!$D$2:$D$4000,MATCH(B2,Sheet3!$A$2:$A$4000,0),1),"") Thanks for looking. Graham
  12. R

    Intermittent problem copying and pasting in data tables

    Help!! Why is this happening? It seems to be intermittent so not sure why. Sometimes it works and sometimes it doesn't. It obviously slows my productivity right down. Pasting Text into Headers from outside the Table or even copying existing headers into new columns will not work. It was...
  13. S

    how to use VBA to adjust the data selection range in a powerpoint chart.

    I have a vba code that copies some data from Excel, and then pastes the data into powerpoint to create a bar chart. It does this this by pasting the data into the bar chart excel sheet. The issue I'm running into is that I the data that gets pasted to the powerpoint chart will differ in size...
  14. J

    Pasting HTMLmaker into "Test Here" differs from "Excel Question"; misleading errors

    Pasting HTMLmaker into a "Test Here" posting behaves differently from "Excel Question". The "Test Here" paste looks wrong; and get misleading errors about too many tags. As a consequence, I had previously concluded that HTMLmaker did not work for me. But today, I was "brave enough" to paste...
  15. Jaafar Tribak

    Find out if worksheet change event was triggered by editing cells or by pasting data ?

    As you know, the worksheet change event is fired either by entering data with the keyboard or by pasting from clipboard . The goal is to figure out how the change event was triggered . I am ignoring for now "Fill Down" and "drag&Drop" operations which also fire the change event. I have tried...
  16. S

    Auto Replace Text after Pasting

    When I "Paste as Value". I would like to have the text automatically replace itself to something new in the same cell. IE: "POS DEBIT - MCDONALDS" --> *Paste into cell* --> "MCDONALDS". I cannot seem to find a function to fit this once I paste it. Is there a VBA script to help? I will...
  17. M

    Macro is getting ruined

    I have been re-working this macro for quite some time. First started by pasting info to new sheet on last row, then successfully changed the macro to insert a new row on top and paste to new sheet. Then noticed that the sheet i was pasting to only was moving the row down in certain columns. I...
  18. B

    Pasting issue with VBA (Simple)

    Looking for help on this, I'm erroring out on my pasting line... Sub TEST() i = 1 n = 2 lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row For n = 2 To lastrow With ActiveSheet .Range("A" & n, Range("A" & n).End(xlToRight)).Cut .Range("A" & n).End(xlToRight).Paste End With...
  19. Skybluekid

    Formula explination

    Hi All, I am using this formula, SUMPRODUCT((S2>=$S$2:$S$110)+0)+1, (S2 is a text string), which I got from searching on this forum.Not being one for just pasting formula's, I would like to understand how this works. Thank you
  20. W

    When pasting text w/ VBA it puts it all in 1 column

    I am automatically extracting data out of a Text file and pasting it into Excel. When I do it puts all the columns from the Text file into Column A and you cannot easily separate them. I need to be able to keep the source formatting from the text file (i.e. Columns) when I paste. Any help is...

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