copy & paste macro

For an order system I have a problem. When we order parts we push button. All the parts are copied to the DB sheet. The problem is as follows: The macro is fixed on 25 lines (part lines). This means that the macro always copies the 25 lines (even if there are only 2 parts to be ordered from...

I am trying to export data from a master workbook, into my current workbook, based on 2 values in my current workbook. Current Workbook: C1: Employee C2: Bob D1: Month D2: July Workbook I need to get data from: V1: Employee S1: Month Is there a way to write a macro in my current...

I have a macro that copies a row of formulas from row 1. Then skips over a column header in row 2 then pastes the formulas into rows 3 through to the bottom of a data dump that grows monthly. I then recalculate before copying again and pasting as values. I am using the command "Range(Selection...

I am very new to vba, which i why i am asking this, I'm sure to most people on here this is a very simple process, but I just cant get it to work. So here is what i am trying to do. In sheet one i have a table. in column A, i have an ID number with leading zeros. what i need to happen is when i...

Hello, I am slowly building my knowledge up by trial and error and tons of money on books. However, I cannot seem to figure this out. I have a workbook with 4 sheets, Home, Team 1, Team 2, and Team 3. On the Sheet "Home" I have a simple 4 cell system. "C9" is a drop down box with 18...

Hello All. My name is Joe. I consider myself an intermediate user of excel. I do NOT speack any Visual Basic. I am trying to create, what I feel Should be a simple Macro but I am stumbling over one detail. I need to copy information from one Workbook to another. But I need the macro to be...

Hey there everyone. There is probably already a question about this somewhere, but I can't seem to find it, so I'm creating my own. What I'm trying to do is this: I have a macro that uses drop down menus to populate certain fields. I'm working on creating a second macro that will run immediatly...

Hi, Hopefully this explanation is easier to understand of what I'm after... I have created a worksheet, I need to carry data over from the last sheet to the 'active sheet' (this will always be the same cell on the worksheet) so that once I add values into the relevant cells it 'autosums'...

Hi, I am looking for a VBA solution to copy data in the same format from 13 separate worksheets (months of the year 3 letter abbreviations: "Jan", "Feb" etc and "2014-15") across into a "High priority" worksheet. The criteria I am looking for are either "high" found in column M OR "likely"...

Dear Users, I'm trying to copy a range of filtered cells to a destination range of other similar filtered cells. Here is a little example I'm trying to use with some VBA code I found below. Refering to...

Hi all, This is a lot to ask but i am really stuck at this point. I almost completed my file but I am looking for a solution. I have a partlist for every product (named as Aricle 1,2,3,etc). This file contains 1 sheet with like 20 rows of data. I am looking for a way to copy the data from...

Hi All, linkback : Do Copy Paste on different Cell, when type "OK",Macro newbie, Help! I Have this problem. I want to when type OK, it'll copy and paste it as value based on its row. and select other cell like this pic below. so when i type OK : - on D5, it'll copy F5:H5, and paste to J5:L5...

Hi, in the code below I am grabbing a workbook from a folder and pasting it to the target wb. It works right now, what I'd like to know is how can i go about having it pull other workbooks and pasting into the target wb. So after the macro pulls the first wb(JH A MIP COPY) & pastes it into the...