copy & paste using vba

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 -...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...