copying

Hi Folks, I am trying to run a macro to find last row in column A and paste the value in column H:J. I am copying value from another workbook (OldWkb) and copying it in to new workbook. (NewWkb) My data starts from cell A10. I have left some space at the top to insert some pictures. Is it...

I am trying to copy and paste information on another sheet that isnt the active sheet. Here is my code It is giving me the error on the first line and im not sure why. Sub Copy_Paste() Sheets("Dough Information").Range("H3:J152").Select Selection.Copy Sheets("Dough...

Thanks in advance for the help. The calculation sheet has several API keys that determine distances between multiple start points compared to one end point. The data dump sheet list all my end points that I want to know the optimum distance. Instead of manually going line by line, I would like...

Hi all Can I share a workbook from the cloud but prevent people from downloading it or copying it? Thank you! Russ

Sub Tapcon_134() ' ' Add_Fastener Macro ' Sheets("Hardware Load List").Range("C" & Rows.Count).End(xlUp).Offset(1).Resize(, 6).Value = Range("B9,D9,E9:F9,G9:H9").Value End Sub The above macro is only taking the value is B9 and copying it across all cells in "Hardware Load list". I want to copy...

I am working with 2 sheets. Sheet1 is an inventory sheet (name of sheet is "Location") and Sheet2 is an Order Form (Name of sheet is "Supply Usage Form"). "LOCATION" A B&C (combined) D E F G(week1) H(week2)...

Hi, I know this must be a simple answer, I have the following cell D5 = A5, and E5 = A6. I want to be able to drag these down so D6 = A7 and E6 = A8 and so on down. Obviously i am dragging and getting D6 = A6 and E6 = A7. what is the solution? Thanks J

I read on a website tutorial that a more efficient way of copying and pasting ranges was to use the following: ' This is faster Range("A1:A10").Value = Range("B1:B10").Value ' This is slower Range("B1:B1").Copy Destination:=Range("A1:A10") I was led to believe this way made the code run...

Is there faster way of creating multiple copies of a certain sheet on the same workbook rather than the conventional way of copy a sheet one at a time? Regards, Zed

I have a document with 48 sheets of data, and want to copy the same row from each sheet into a new document. Is there a way to do this simultaneously to avoid copying and pasting from each sheet?

Hi All, i have about 50 workbooks all in the same folder. In each workbook tab 3 is named "commercial" is there an easy way to extract just this tab/worksheet from each in to another workbook. Kind regards DM

I am currently trying to copy an excel worksheet and paste it into a word document and turn it horizontally. I know about to create a text box and turning it to be horizontal then copying special the excel sheet in. But when doing that the excel spreadsheet is too big to fit on the whole page...

Hello, I need to take multiple rows with same information as below: And organize in columns like this: I have a thousand of these to do and copying and pasting with transpose is not an option :(

Hi, Is possible to copy a hidden sheet from one workbook to another without unhiding the hidden sheet? I have been looking for a solution to this but can't seem to come up with anything without unhiding, copying then hiding the sheet. Can someone help with this please

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

Hi all, quick one I hope. I'm copying 4 tabs from one workbook into a new workbook, only copying the values, formatting and column widths along with the tab name and colour. I've done this by recording a macro, but have ran into a problem. When the Macro gets to Workbook.Add, it adds a new...

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

As you can see in the attachment there are two worksheets in the lower left corner. Worksheet and worksheet2; I'm trying to copying all the cells in the tab "worksheet" and copy them to "worksheet2". How would I do that? Thanks. https://ibb.co/ibQPQq

hello! How to copy conditional formatting rules to different cells have already other formulas instead of copying the formulas? Thanks!

Hello, I am trying to write into my code that if a cell in therange I am searching has any text to select it for copying. I am using the.TEXT function and the wildcard is not working as a part of the code. Howshould I be putting it. Here is the code I have not: Sub Sort_Deployed() a =...