copy and paste cells

  1. J

    VBA Copy and Paste Code with filename

    Hey All! I have my trusty old glorified copy and paste code but I am looking to link the line that has my Workbook name to a cell in one of my sheets. Can't seem to figure it out. Sub GrabIndEquity() 'Update Data Workbooks.Open Filename:= _ "T:\FILE1\FILE2\FILE3\FILE4\FILE5\DATABASE...
  2. B

    VBA: Find (match) from a list, then copy and paste into different sheet

    Hi, I’m wondering if someone could help me please as I’m struggling to get this working. A button click runs a sub containing two with statements. The first one (with ws) works fine. This finds certain records from the main list in worksheet ws, it copies selected columns and pastes the...
  3. J

    Copy from Excel to Word Doc as Multiple Images

    I have a spread sheet that consolidates multiple worksheets into one. Then, the user sets the page breaks. Next, the user can hit a "PDF" button and it will export to pdf. It looks great - exactly as it does in excel. But, I cant quite seem to get the Word export to work. When the "Word"...
  4. H

    VBA Copy and Paste into certain location with restrictions

    Hello all, I am trying to create a passenger manifest form. I have sheets for each day. I Have a userform that outputs to sheet called "Master", need to copy Cells D2:N2 from sheet "Master" and paste into a specific location on a specific day based on user entry. I would like to prompt the user...
  5. K

    Macro for Button: If Cell = Name then Copy to Another Spreadsheet

    Something like: In spreadsheet "Complete Backlog", if a cell in Column K = "Open" AND the cell in Column G of the same row = "Snodgress" THEN copy cells A?:J? and paste into cells A?:J? of the "Snodgress" sheet. Of course skipping to the next available row and also the content should not repeat...
  6. T

    Need VBA to open multiple sheets, copy, and paste certain values

    Hey Guys, I know you have gotten this one a bunch before, but I can't find a way to do the couple things I need this to do. I'm really close however, so it shouldn't take more than 5 minutes hopefully. What I need. Open multiple files at one time, copy and paste certain cells in those files, to...
  7. A

    Macros need whole line moved to new worksheet automatically

    I want to create a macro that when date is inserted into certain cell, have the whole line moved to a new worksheet, and re move from original sheet.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> attempted to create the formula, but...
  8. E

    HELP!! Searching Excel with Macro's

    Hi all, this is my first post so I apologise for my lack of forum lingo and knowledge! I have a situation where I have a rather large spreasheet, that we populate each week with 35 columns and 20,000 rows worth of data. At the moment we have to manually go through this data and look at certain...
  9. B

    Copy (range} from worsheets to "Results" sheet

    Windows 7<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Excel 2007<o:p></o:p> <o:p></o:p> PROBLEM: I have completed my loop through all the sheets in my workbook. All my data is copied to a “Results” sheet that looks like this. Player 1 has been copied...
  10. B

    Looping through an Array of Wooksheets.

    Windows 7 Excel 2007 GOAL: My intent is to create a single workbook. Sheet1(pga_list) will be used for data purposes and will be referenced by all other sheets through a data validation variable and vlookup values. This I have done. I wish to add an indefinite number of sheets beginning at...
  11. J

    Copying Hyperlinks Question

    I have an Excel Workbook that has approximately 200 sheets in it. What I am trying to do, for example, say I have two sheets that are essentially identical. On sheet one I want to create hyperlinks to the same cell in sheet 2. I know how to do it one at a time, but I would like to do is be able...
  12. E

    Help with macro for copy cell data from one worksheet to another in next available row.

    Hoping someone out there can help me. I am new to macros and do not have a clue where to start. I have a worksheet called "Entry" and there are certain cells in which data is entered into. There is also a command button that when clicked I would like it to do the following: 1. Copy data that...
  13. T

    How Do I Late Bind This...

    Hey all! I was wondering if anyone knew copy range G15:H600 from excel to word, paste it, and then copy it back from word to excel in the exact same location from whence it came - all using late binding. I've been trying everything I can think of, but I have very little experience in this...
  14. P

    protect number format

    I have a column (A) that can contain wither text or numbers. I have set the number format to be with four decimals and % (ie. 12 would be 12.0000%). I want to protect that number format. The column is already protected, but if people copy a number from another column X (say, the copy the number...
  15. S

    Macro to copy/paste in new location from a filtered list?

    Morning all, Can anyone help me with this one: I need a macro to look at a list (which has been previosly filtered by the same macro) and copy certain columns in that list to be pasted into another workbook. The problem is, the length of the list will change frequently depending on the...
  16. M

    Loop through a worksheet and populate data into another worksheet if criteria is met

    Hi There! I have Sheet1 in workbook "DATA.xlsx" that has data. I.E. column1 column2 567 John 567 May 123 Kate 567 Larry 456 Bill I would like Sheet1 in ANOTHER workbook "SUMMARY.xlsx" to list all of the people who meet the number criteria I type in...
  17. P

    A trivial macro that recursively moves cells in a row.

    It is a trivial problem but I am so newie, sorry.. The Idea is that recursively with a for check the value of a columm if the value is "I" then I should cut some consecutive cells from that row and paste them in the same row but with some cells displacement... it is pretty much a selective copy...
  18. J

    Help for a newbie!!

    I've just signed up and i hope somebody can help me out. I'm tryin to write a macro that will: - find the condition columns in a spreadsheet (their headings are coloured light turquoise) - check if each is populated - if it is then copy each individual cell's info and the column name,(e.g...
  19. A

    autofil matching adjecent columd

    I am working on a project that reqiuers book2 to cpy from book1 and paste ifromation in book2.:( But book 2 must copy from book 1 a single cell that has a letter to match informatin copied before then place the letter to auto fill to the end of information coppeid first it should look like...
  20. dukeofscouts

    VBA copy paste code... Where did I write it wrong?

    Over the past several posts I've tried looking at the diffrent issues I was having trying to create my vision of macro that would allow me to transfer data from one sheet to another and place it correctly in the second sheet using a copy paste tool. Well I thought I had it all in place. I...

Some videos you may like

This Week's Hot Topics

Top