copy & paste using vba

  1. X

    Copy Worksheet Name for every sheet in workbook and paste in master sheet

    Excel vba noob here, I have 10 sheets in a workbook, I want my code to create a new sheet called "Master"; and for each sheet in the workbook, I want the sheet name in the cell A2, A3 , A4 etc in the "Master" sheet. I want the output to look like the below for the "Master" sheet: Cell A2 -...
  2. D

    copy-paste from one Excel file to the other

    Hi guys, The code I've been using doesn't give me the results I want. Basically, I want it to copy-paste the two selections (which contains functions and graphs) to another Excel file (paste values and graphs). When it sends the data to the other file, I want it to create a new sheet based on...
  3. N

    VBA - copy coulmn with value from cell in row 1

    This seems straightforward so I thought I'd be able to find it, but I've been searching for an hour now without any luck. I'm new to VBA so I appreciate any help! Sheet2 has a bunch of data organized in columns, with each column identified by a unique number in Row 1. If I type a number in a...
  4. G

    Copy Only Cells With Numeric Values Onto New Sheet

    Hello Mr.Excel Gurus! I am currently attempting to copy data from a column that has a mix of cell values; some are numbers, some are words, and some are blank. I am trying to create a list that will copy over only those cells with unique number values, ignoring the blank and word-filled cells...
  5. PritishS

    Copy a Button (with Macro) in 10000 Rows of a excel sheet-Shortcut method required

    Dear Sir/Madam, I am new to this forum and same in excel macro VB programming. I need some expert advise. My Requirement: a. My first requirement was copy data from one sheet to another using a button. I have found the macro code for that in this forum. b. Secondly, that same button should...
  6. B

    Macro to copy data from source workbook sheets to historic workbook sheets

    My aim is to write a macro which will copy monthly data from the source, which is a workbook with data in multiple sheets, into my historic workbook which has the same multiple sheets but obviously the previous historic data as well. So far I have managed to pull together some code which allow...
  7. S

    Append data from Table1 to the end of table2 on click of a button

    Hi there, I'm totally new to VBA and macros, so will need some deep level steps and code to perform the task. Thanks in advance for helping me out. On sheet1 i've table1 which is populated by MS query refresh from oracle database. Usually user query data from the last month. On sheet2 Ive...
  8. M

    Extract information from Word Archives 1999-2015 to Excel to import into Access to create databases

    I am wanting to extract word archives from 1999 to 2015 the following into Excel for the purpose of create Access databases of 1000s of pieces of information. 1. Subject: Ad Removal November 20 <database of subjects 2. From: John Smith, Project Engineer <database of senders 3a.Personnel: Ron...
  9. S

    Copy and paste a row of data based on the location of the active celll

    Hello Everyone, I am in need of a macro that, upon a double click, copies the data in a row based on the active cell being located somewhere on that row. Once Copied I would like it to paste the selected row into the next sheet in the next empty row. The first row is D1 to J1 and then goes...
  10. A

    Copy and Pastspecial only copying 5 rows of data

    Hi, I've ben pulling my hair out trying to figure out this simple code. It's supposed to copy values and formatting only from selected rows from a table in one worksheet to another worksheet, removing blanks and duplicates . I've tried multiple ways, which either work and then stop working...
  11. G

    Copy and paste special in vba

    Hi All, I'm trying to create a macro that should do the following things: 1. Look for a cell named "Pippo" (named through Name Manager) in the worksheet called "Pluto" or through the application vlookup 2. Copy the cell found (named Pippo) and paste it as link in the cell L11 of the sheet named...
  12. M

    VBA to copy data range from multiple sheets to mastersheet - Urgent help required!

    Hi, I've been reading numerous posts, watching multiple youtube videos, and wildly searching the internet for several days now trying to figure out how to create a VBA/macro to suit my needs, but am still stuck scratching my head, so hopefully someone here can help me! :confused: I have a...
  13. D

    Iterate through cells in a column, if contains criteria, copy row to new sheet

    I have a spreadsheet similar to the following: <pre> <b>Name Title ID</b> Person 1 Title 1 1 Person 2 Title 2 11 Person 3 Title 3 111 Person 4 Title 4 1111 Person 5 Title 5 12 Person 6 Title 6 121 Person 7 Title 7 1211 Person 8 Title 8 1212 Person 9 Title 9 122 Person 10 Title...
  14. B

    Do...Loop Until - C&P values into tables

    All, I'm a relatively new <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym>-user, and am putting some feelers...
  15. B

    Check if condition is true, then copy/paste data

    Heyho everyone I've got the following situation: 2 different workbooks (WKB2 with multiple sheets / WKB1 with only 1 sheet). I need to check in a range in WKB1 if a cell value is the same as in a range in WKB1. If yes, then the macro should copy the corresponding cell.offset 1&2 to the left...
  16. S

    Copy&paste values only from one worksheet to another

    Looking for some help with a piece of code I am trying to modify.. The code below copies & pastes the values on a separate worksheet ("Report") within the same workbook. What I would like to do is copy & paste the values onto a completely separate workbook. Dim irow As Long Dim ws As Worksheet...
  17. C

    VBA to copy User selection to next empty row(Column B)

    Below is the code i have that works for me with no problems at the moment, the green comments are a description of what the macro should be doing the red text is the code which needs revising AND the blue text is what i am trying to achieve rather than the red text If you need anymore...
  18. S

    Copying a tab from the active workbook and pasting in another workbook as a new tab.

    I am trying to add this template to every excel file in a folder. I have the loop down to run the macro on every excel file in the folder. however, I cant seem to get the macro down to copy the tab and paste the tab. I appreciate all your help, I'm new at this! Sub...
  19. M

    VBA code to replace contents in a Powerpoint table using Excel data

    I would like to copy Excel data into an existing Powerpoint table using VBA in order to keep the Powerpoint table formatting, e.g. I need a VBA code to open an existing PPT presentation, select a predefined slide let's say Slide(1), select the Table1 shape in Powerpoint and copy the Excel table...
  20. J

    VBA To copy specific cells to new sheet

    I am looking to go through a large chart (A19:CC219) and paste rows with a specific criteria from one of the columns to another sheet. Anyone have a code that can do this? The goal is to auto export info added to the 'master' sheet to sub sheets with that certain column of criteria. Thanks for...

Some videos you may like

This Week's Hot Topics

Top