say I have data in cells B27:J27 and B28:J27 on workbook sheet 1 and I want to copy it to cells B27:J27 and B28:J27 on workbook sheet 2. What does the code to do that look like?
say I have data in cells B27:J27 and B28:J27 on workbook sheet 1 and I want to copy it to cells B27:J27 and B28:J27 on workbook sheet 2. What does the code to do that look like?
Hi,
http://www.ehow.com/how_6317912_copy...-workbook.html
or http://www.techonthenet.com/excel/macros/copy_range.php
Does this help? Did you know your two ranges are different sizes? Is that the real question?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I think there is a typo - Nicole has B27:J27 and B28:J27 to be copied. Maybe the 2nd J27 (see bold text) should be J28?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
This seems overly complicated. I have attached the workbook I am working with to this posting. All I want to do is take the highlighted cells on sheet 1 and place them in the highlighted cells on sheet 2. I tried just copying from one sheet to another but formulas don't carry over right. I want the formulas to work such that as changes are made to sheet 1 the data in the highlighted cells are ported from sheet one to sheet 2.
Last edited by nicolelschramartin; 12-13-2012 at 01:48 AM.
There is no highlighted section in Sheet2. If the cell addresses in Sheet1 are the same in Sheet2, the formulae should copy properly.
I don't want to copy I want it to automatically place the data from sheet 1 in the some other cells on sheet 2.
So you want to place the data including formulae or only the values?
I just want to place the numbers and not the formulas.
Then this code will help you -
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks