copy & paste using vba

Hi, I have been searching for the past week, and can't find anything to help me out. I have a report that displays usage data for groups from the previous month and I want to export that data from the workbook that it is stored in to an existing workbook and existing sheets based on the number...

Hello all: First time poster and I want to let you know that I have no Macro VB or VLOOKUP experience. I have a workbook with two sheets. The idea behind the workbook is an Interview Guide to be used just before an Interview. For now my problem is this. Sheet 2 "Competencies" is just data. It...

I have a pretty big task in mind, and I'm stuck on a lot of parts. I've outlined it below: 1. search for a specific phrase in the spreadsheet (exact phrase, match entire cell contents). Store its index. This is easy enough: Cells.Find(What:="Vendor Terminal p/n", After:=ActiveCell, LookIn:= _...

Hi guys, I'm new to the forum and VBA in general, just started using it a couple of weeks ago and am having trouble trying to write a code for something I am looking to automate. Basically, I need some help with copying data from a few worksheets in a workbook to another worksheet in the same...

Hi All I have this range of data B C D E A1|60% 50% 67% 78% A2|90% 65% 78% 45% A3|60% 50% 67% 78% A4|90% 65% 78% 45% A5|90% 65% 78% 45% A6|60% 50% 67% 78% A7|90% 65% 78% 45% A8|90% 65% 78% 45% ---Contains formula When the value of a particular cell (F3) changes I would...

Let me start with saying that I am running Excel 2010 on Win 7 and the user will be using Excel 2007 on Win 7. In my first sheet 'Daily' I have a form and the info typed in is summed up in Column G. G11:G36 is the first of a few ranges I want to work with. Now my other sheet 'Summary' has in...

Have been trying to do this with macro recorder and then realised not possible. With workbook open check if worksheet name 'Combined' and if not create it. With workbook open check if worksheet name 'Errors' and if not create it. Activate first worksheet. Read each row and if cell A = "Y"...

I want to write a code that will copy a worksheet (Sheet2) x number of times and copy a differebt row of data from Sheet1 to each new copy. For example: If I have data in rows 2 - 4 of Sheet1 I would want to copy Sheet2 three times and copy row 2 (Sheet1) to the first copy, copy row 3...

I apologize, I'm struggling and those wiser than I on this forum may have a quicker solution. I have a very nifty costing estimate spreadsheet I wrote for doing project cost estimates. I set it up to do some cool things BUT if someone wants to add a task (set of rows) and they don't know what...

Hi, I'm needing some help modding this code. WS "Activities" has a list of dates in col B (Inputted as 02/01/2012, 04/01/2012, 01/02/2012 etc.) (Formated as 02-Jan-2012, 01-Feb-2012 etc.) WS "MonthReport" is where the rows are being pasted Currently the code will paste rows based on the search...

HI... i have cell a3 as a reference to another cell lets say z4 is written in cell a3 i want a code to help me select z4 from cell a3 my code goes as follows: Range("A3").Select Application.CutCopyMode = False Selection.Copy ' I WANT TO WRITE HERE A CODE TO LET THE COMPUTER...

Hello Experts, I have been trying to get this to work for some time and feel I’m very close. - I’m a beginner to VBA so by combining several other threads I was able to get this far. What’s meant to happen, Prompt user to open a directory and then copy pre-defined cells from each tab (except...

Good day to you all, and thank you in advance. I am running Excel 2003, having severe difficulty performing what feels like it should be a very simple macro. I have cells from Column A through M, and the text in column A has multiple data points of various character lengths from 2 to 8...

I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In column H, I have the date each work order was completed and the dates are formated mm/dd/yyyy. I would like to have a code that will copy the work orders...

I would like to be able to copy data from one workbook (one a user chooses) to another (the one the macro is ran from) I will not be copying all data so I would like to use Cells(r, c) to determine which ones to copy. I currently have this... hopefully you can understand where I am trying to go...

Hello again Excel Guys, Hope you guys doing fine! Just have 1 quick question for All, is it possible to paste data from excel into another application like VB 6 forms? If not, then its fine. However if Yes, appreciate if someone share knowledge on how to make it work. Example would be, I have...

Beste, ik moet voor mijn stageopdracht een sheet maken waar cijfers van de dag in worden geplakt. ik begin met een userform en voer daar de datum in. deze wordt geplakt in sheet 1. (A2 = DD B2 = MM C2 = JJJJ) ik heb al een macro lopend die externe bestanden importeert. die bestanden worden...

Sorry about the rudimentary nature of this question, but I am relatively new to VBA and can't work out what I am doing wrong. What I want to do is very simple: I have a sheet with four values on a row, followed by three blank rows and then another four values below that. What I wish to do is...

I have 3 workbooks in a folder: sample report , AAA and BBB. · The workbook,” Sample report” has 2 sheets –‘ overall’ and’ Proj wise’ · The workbooks “AAA” & “BBB” has 3 sheets ‘overall’,’ proj wise’ and ‘cost details’. The sheet ‘cost details’ is filled and the other 2 sheets are blank I...

Error: 9 - Subscript out of range I have written the following code , it was working before on my Test Excel sheet when I tried to run on the live xl Sheets i.e. Source and Destination its giving me above error on the line(red font) given below: Aprreciate your help. The code is written in...