copying

I need some help for when I am copying data from a cell and pasting it into a text box on a website. Every time I copy the cell and paste it, it has quotes at the beginning and end of the data string that I have to manually delete. Is there a way to do this so it does not paste the quotes...

Hello friends. I have just discovered the consolidate function and was very excited to start using it to remove the manual process I have previously used. For some reason the function is copying each line in twice, which you can't initially see, but there are 'group' expanders on the side of the...

Hello, I am trying to sort through an ever updating spreadsheet and give items a priority. Once the priority is given, I hit my Update command button to populate 5 priority tables (high, med. high, med, med. low, and low). I feel like the below code should be correct for a single priority...

Hi! I am trying to copy information from one sheet in excel to another, if the condition that the part is late and hasn't arrived is met. So I want to look at column c (delivery date column) and look for any cell in that column that is empty. This means the part is not here yet. Then I want it...

Hi, I am trying to write a simple VBA that will allow me to copy a file into a given folder, run the macro and then copy this file into multiple other folders (i.e. 5 or more other folders). I am struggling to figure out how to add the multiple paths into the code. The code: Sub...

I wish to copy data from a from a multiple of workbooks located within a specified folder. Each file has data in cells C1, C2, C3, G1, G2, G3 This data needs to be copied into cells A2:F2 I then need to copy data from row A7:J7, to the last row of data located in column A The data in A2:F2...

Hello, I am wondering if it possible (and if so, how) to keep formatting when creating a new worksheet in excel, similar to a template. For example, I have a sheet with a photo, text, and column headers that I want to keep on all worksheets within this workbook. Ideally, I would like to click...

Hi, I did look for someone to help me copy data from one spreadsheet to another. There is a slight catch, the data original source changes name and file path every month however the destination doesn't (if that makes things easier). What i need you guys expertise is to copy data from original...

I've got this working on a couple of other similar sheets but I must be missing something here. In short I'm opening a workbook, copying a range, pasting the range in to another Workbook. However, now when I paste it is pasting an image file not the actual cells. :confused: My code is here...

Dear all, I'm a newbe in this macro world and I have been trying to get my routine working. I don't have any error apparently, but the issue is that I'm not copying anything and that's exactly what I need to do. I checked names, ranges and everyting is fine. Could you please help me? This is...

I was so proud when I modified the VBA code from JLGWhiz' reply to "VBA: Copy all rows with data from one sheet and paste on bottom of another" from this forum in order to copy/paste the rows from ten sheets, and it looked at first glance like it worked! On closer inspection, I found that the...

Hi there, I have an excel problem. I have set up quite a complex workbook over multiple sheets. I have a list of names from one sheet, as below: What I want excel to do is to copy the name to another sheet if that name is referred to once (which I have been able to do), but if the name is...

I'm working on a code in VBA to copy rows from sheet "ALL FILES" and paste them into "VIEW STUDENT" based on "JOHN SMITH". Right now it copies the entire row, but I only want to select columns D, E, H-AB (4, 5, 8-28) in the same row. Any ideas? Sub RunMain() Dim r As Long, endRow As Long...

Hi Guys, I am new to the thread, and I have a question. I am trying to determine how to copy data from "workbook2" into "workbook1". "Workbook2" has in the first row of each column a name. I would like to match the first row of each column in "workbook2" to a worksheet who has the same...

Hey, I am new here and I've been browsing to find a solution but I may be missing it. I have information on Sheet1 and I want to copy everything in Column E, Y, and AH. I want to copy and then paste this information into Sheet2. Let me know if anyone can help. Thank you!

I have 39 characters in a cell something like this 101010000614021350229003000000000011.10, when I copy the same in Excel 2007 version it comes out like this 101010000614021000000000000000000000.00 Would someone help me on how to copy it exactly in Excel.

Hi, I just wanted to know if there was a quick and easy way to copy the format from a cell to another when I include the cell in a formula. I have a cell that I put text into and want it to show up with the exact same format (includes bold and underlined words, etc.), but this won't show up...

Hello Everyone Wondering if anyone has come across this before. I have a Excel sheet which I want to protect except the a certain range in this range I want the user to be able to select the range & copy the data but I don't want to give them the option to edit. I have tried playing around...

Problem copying Dynamic graphs with Offset formulas (Excel 2013) I have a workbook with many sheets with the same graphs plotting different date related information – each sheet has in it its own data In the first worksheet I have set up dynamic graphs (quarterly rolling) with offset formulas...

Hello, I am currently writting a macro which requires that the data after the macro is ran, to be put into a new workbook. However, I need some Macro code to go over with it for use later on the data present. Is it possible to have the macro copy another macro to another workbook? Thanks in...