pasting

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...

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

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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

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...

Hi There, I have read a couple of forums on this but am still not getting it right. Lets say I have 2 worksheets. Sheet 1 and Sheet 2. I would like to have my command button do the following: 1. Cut the selected cell from my existing worksheet (this I have achieved albeit through assistance...

Hi, There may be a neat solution to this already, but pasting copied data from one worksheet (A), to the bottom of a table in another worksheet (B) changes the formula in the table in worksheet (B), to the formula within the worksheet (A). I thought (hoped), the logic would be to preserve the...