copy/paste

Hello folks, I have the following issue and will be very grateful if you provide some help: I have one sheet which I need to manipulate some data and copy/paste from it (sample below): I need a script which searches for the word 'Open' in column A and next finds the first non-empty cell in...

trying to debug a former teammates macro (novice user myself). object is to copy a small range, formatting and all and post in the same location in multiple worksheets that match certain criteria. in this case, moving July end of month (range g6:k8) to daily breakdown worksheets (all of July...

Not sure if this is possible but I'll give it a shot... The reports I run for payroll render an alphabetical sheet (with hundreds of employees) and their respective revenues earned in an adjacent cell. Our payroll spreadsheets are broken out by office location, so the destination formatting is...

I hope somebody here can help me with some coding issues. I have been trying to do it via Record Macro but I am stuck. I need to accomplish this report as soon as possible. I have tried to add the code using Mrexcel HTML maker but it didn't work. I also have a workbook but I don't know how to...

To use copy/paste I have to turn off Events. On all my workbooks that have events, I have to include a button, "Events off/on". Its a pain. This is not a new problem I am having but I'm wondering if it is just a feature of Excel and I have to put up with it. Help appreciated.

Hi all, first post of mine to this forum. I've been working with this bit of VBA for a few hours now, but haven't been able to figure it out. Needless to say, I'm not very good in VBA. I am trying to copy several rows from one sheet to another, making sure that the pasted content starts on...

Hi all, I am running into a macro problem when trying to create separate file based from a master list based on each persons name into a template file. The objective is to create a file for each person based off of a template file. I need then need to copy and paste information related to each...

Hello, so far I have below VBA, which is great and does what I need it to do. However, I cannot get it to special paste just the values of the cells to the new worksheet. What am I missing? Sub Submit_Click() Dim ws1 As Worksheet, ws2 As Worksheet Dim DestRow As Long Set ws1 =...

I have this Workbook("Test"), worksheet"Countries" - I have this column "R" which holds certain values ( America , India , Canada , Japan) - I want to copy/paste all the "America" rows in "America Worksheet" into Workbook2 - I want to copy/paste all the "India" rows in "India Worksheet"...

Hello all, I've been finding some difficulties in writing simple VBA macros constructed to copy/paste values between different worksheets. Can someone explain me why the following code does not work if my active worksheet (the worksheet from which I am running the code) is different that...

Hey everyone, What's given: I am working with an excel folder with an overview sheet with several columns and 40 rows. The cells of each row is in turn retrieving and manipulating data from a corresponding separate sheet labeled 1 through 40. The manipulation done by each row with the...

I am trying to format my worksheet. I am trying write a macro that finds the last used column (in this case it is Column V) and select the rows range for each company(Column E to Column J) and paste to the Column W( next to the last used column). And finally delete the empty rows. What I need is...

I need a macro that would copy some data from say A1 on Sheet 1, then paste it on A1 on Sheet 2, then perform a text to column, delimited by space. Is this possible? Thanks a lot

Hello all, I am working on a project and hit a road block. I have a spreadsheet that users will populate using various dropdown lists and such. Data begins on B17:M67, a user could even add in additional rows if needed using a macro. My specific question is, if a user decided to enter data...

I'm trying to write a code that copy/paste from one worksheet to another. I'm trying to choose specific columns in the Worksheet titled "FY 13 S3 FR PUF" and copy those into "ProvCBSA AHW Analysis." Here's the code I have written but cannot get it to work: Sub CopyData() Sheets("FY 13...

copy/paste Every Sheet Single ( P Column ) and Paste to Note Pad and take P1 As file name for note pad.

Hello all, Long time reader, first time poster. I am trying to create a dynamic range using R1C1 that will let me loop through (I have this piece solved for) a number of matrices and copy from one sheet to another- basically, I want to increment the R1C1 values in my loop and step through the...

I need to copy the first 8 characters from every row in one column into the cell in the next column using a formula in the cell, not a macro. Thanks for any help you can offer.

I have a column filled with 17 character identification numbers. I need the next column over to automatically replicate the first 8 characters from the same row in the column next to it, and also to lock this column so that the data can not be modified??

Hello. I am trying to speed up macros that were written by people before me. I have basically just removing the Copy/Paste code and using Sheets(destination).Range(putithere)=Sheets(source).Range(data).value This works fine for data assignments within a single workbook, but when it comes to...