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