copy/paste

Hi guys, Stuck on a problem with my code, I am creating a new sheet and then doing a copy paste function to get the data onto my newly created workbook/Sheet but for some reasons I can't deselect the pasted cells. Maybe someone can see a problem or a solution for my issue. My code: With...

Hello. I am looking for VBA code to copy data from a column in Excel to another column (to the right) on the same worksheet. Trick is if the destination column has data in it, I need to go to the next column to the right that does NOT have data. In my example, I have data in range C4:C25. I...

Hello, First time poster, long time listener. I'm am looking to do the below: 1) Formulas located in A2:S43 2) Copy/Paste those formulas in row 46 (leaving row 44 & 45 blank) 3) Copy A46:S87 (just pasted box), and paste the values and formatting into itself (A46:S87) 4) Loop 1-3 times the...

Hello, I am building a macro, I am in a section with a With / Next Loop. I need to copy/paste in every loop the content of cell B3 because there is currently a vlookup formula where I bring data to excel. Thus, I need to copy/paste in value that cell. Could you please help me with the code? I...

Hi Folks, I have this copy/paste VBA which copies a range from one workbook into another workbook. Public Sub CopyPaste() Workbooks("GenericGRNReport(Excel2010).xlsm").Sheets("GRN_Data").Range("$E$3:$F$5000").Copy...

Hi all, The following formula is from one of the bosses spreadsheets. He is a heavy spreadsheet user but his formula skills stop around =a1+b1. He is a huge fan of copy/paste. So needless to say there is a lot of 'fixing' to be done, by yours truly. I am usually able to figure out what he did...

First time posting here.... would like to take this opportunity to say that you guys rock and visiting this site has provided more excel answers than I care to count right now. Keep up the good work! So here's my scenario. I have a table.. and I have another table. We'll call them "Source"...

Is there a simple way to copy/paste values when you have a filter on? I often have formulas in spreadsheets I want to work with and want to slowly get rid of them as I'm working through a column. I will filter on the results on want and want a way to remove the formulas just from the visible...

Hello, I am trying to record a macro that copies an entire worksheet to the next worksheet (tab). The original worksheet has 4 macro buttons currently (one of which is the macro to do this copy/paste). When I run the macro below, it copies and pastes to the next tab but pastes as a picture...

Is there a way to deny a cut/paste to users while allowing Copy/Paste, and clear contents for the Workbook?

Hey Guys! Im looking for a VBA code that will copy row 1 from column A to M , and will paste row 1, a line below every time it finds a merged cell. And I want this to loop until the last Merged cell. Please refer to my code below and see if it makes any sense to you. Can someone please help...

I need to speed up my code. This code is looped through hundreds of times and is super slow. The problem is that the range of cells I need to copy and paste changes. Here is my original code: Worksheets(Sht2).Activate Worksheets(Sht2).Range(Cells(13, 1), Cells(LastPt, 15)).Copy...

Is there a way to run a marco that will copy select ws and paste them into a new wb even though it is password protect? Thanks

Hello All, I am looking for help to fix a macro, or build a new one. Goal: To create a looping macro which will copy/paste a column of store numbers into into a single cell in another sheet (on a 1 by 1 basis) and then paste 2 sets of returned results into the original sheet. The two sheets...

Hi Guys, I create a template with some text on it that I can copy/paste to other apps with a copy button, really basic, selecting, copy to copyboard and pasting it where you want by doing a Ctrl+V but it's creating a lot of space or blanks between the text. I still want to be able to add some...

I've recently been trying to consolidate VBA by leveraging Add-Ins. I THINK that might be at the root of this issue, but am obviously not positive (or I wouldn't be posting this). I have a simple User-Defined function that just returns the NAME of the office user ("Mark Stepan") by retrieving...

I know this issue has been discussed, but for the life of me I cant get it to work fully. Hopefully, someone can point out my mistake. Okay, I have a workbook with two sheets for two of our locations (Cincinnati and Chicago). The sheet structures are the exact same and are formatted the exacts...

Hei, I´ve tweaked a code to copy/paste two different dynamic tables into one dynamic table in another sheet. However, it seems that the latter part of the code (copying the last table) overwrites the first one. I´ve used lastrow to determine the last cell with data, but it failes. Sub...

Hello, I pulled some raw data of 15000 rows, and trying to fill in some of the blanks to be able to convert into a pivot table. The challenge is: 1) Each date has several rows corresponding to it: <tbody> December 5 Cat 15 345 Dog 36 564 Rat 56 654 December 6 Frog 22...

Hi, Let's assume some data in A1 through A10. A1 through A5 contains one group of data and A6 through A10 another. I have referenced A1 in B1. When I copy/paste B1 to B2, I would like the cell reference to increment by 5 (to refer A6) instead of just 1. What would be the easiest way to achieve...