copying between sheets

Hi everyone, I have a fairly large, but fairly simple spreadsheet which is used as a budget. I want to be able to create a copy of that spreadsheet, but instead of the cell values being the same, they're actually all ='Originalworkbook'!A1, for example. I want to do this because I want to...

Hello, I can't seem to get my module 8 to paste the values of Sheet1 (workbook where the VBA code is) onto another workbook's cells, I will briefly explain my code: I have three workbooks, one workbook (with Sheet1 being the "Operator" sheet) where the VBA code is written in, and another two...

Hello everybody, I am trying to write VBA code to copy cells from a range of non-contiguous columns (A:K, O:Q) to a new sheet if certain criteria is met (a cell in columns O:Q is populated and cells in column F do not contain a key word). I am able to specify the criteria but the code I've...

Hi all :) I'm having a problem getting this macro going ... I have a file with 2 sheets, 1 named "DagelijkseKassa" which contains dates next to other info, the other is named "Fiscale attesten" which contains cells with the same dates, but on different locations. Row 8 of Fiscale attesten...

Hello I have a problem with duplicating a worksheet within a workbook that includes scroll funtions and dynamic chart calculations. I downloaded this template https://templates.office.com/sv-se/Månadsbudget-student-TM02930047 (it's in Swedish, but don't worry) from office's webpage to make a...

Hi Everyone, I have a requirement to copy data from Sheet A to Sheet B. But the constraint is as below. 1. Sheet A has more columns than Sheet B. I have to copy only few columns to Sheet B from sheet A. 2. There is a mapping in another control sheet available to what cols from Sheet A should...

Hiya! I'm using Excel 2003 to keep track of grades in a college class that I teach. Each category of graded items has its own worksheet with all grade data for all students, and I have an Overview worksheet that calls up data from the other worksheets that tell me total items passed / points...

I have two sheets, one called Master and another called IEP. Data is entered into the Master sheet in rows from Column A to Column O. If Column J has an "X", I would like Column E of the same row to be copied into the next available row in Column A of the IEP sheet. I also want Column F...

Hello everyone, I have a workbook with several worksheets of accounts, and I have a "Master" worksheet that contains the list of all the accounts on Column A. I want a macro that goes through each worksheet, go through row 1 to 100 in Column A if Column A contains the word, "Subtotal"...

Hey Everyone, I have a little experience with Excel but I'm getting into bigger projects and I need to copy information from one worksheet to another. Worksheet A has information in Column A and the information could be anywhere from 50 to 450 rows. It changes. I want to copy 15 rows of data...

Hi all, I am a novice to vba and macros so I apologize in advance. On one tab (data), I have a list of project numbers in column A ranging from A2:A12. Each project has a Construction date (column b), Construction cost (column C), Top phase date (column d), top phase cost (column e) so on and...

Hello all professors out there. I have searched the forums but at a loss on this one. If it can be done via formulas rather than VBA great but willing to try anything at this point! I have two sheets. The first sheet contains a long list of Postcodes of our customers and I am trying to do the...

Hi there All! So i have looked for a similar thread and can't find, so posting my own. here goes.... I have a database that I dump into an excel spreadsheet every 6 weeks after new updates get done to the db. So I have created a separate sheet in the workbook to make up a birthday list. So in...

https://docs.google.com/file/d/0B4AdUEYBpN4dSm5TLVY0NWtmXzA/edit?usp=sharing Hi thank you for taking the time to try and help me with my query, I am attempting to feed through data form a master sheet to an additional sheet depending on the choice a user makes by selcting from a drop down on...