copy and paste macro!

[lfourtner]

I am making a scheduling sheet with excel and am having problems when I cut or copy and paste cells from one "Machine" to another "Machine".
Machines are referenced on the attachment as "Machine #1 and Machine #2.
Each machine has 2 variable cells. One is a "date" and one is "hours".
Each "machine" has 5 rows and 8 colums for entering data.
There are 18 machines total on the worksheet. 5 "machines" in the first column(s), 5 "machines" in the next column(s) over and 3 "machines" in the column(s) after that. I will be adding more "machines" as needed. Each "machine" is formated the same with the same amount of cells etc.
I want to be able to move one or more "jobs" from one "machine" to another "machine".
When I copy or cut and paste the information to the next machine I want the reference in the formula to use the variables in the "machine" I move it to. (Hopefully somehting in the formula and automatic ut I will take any advice I can get)

I hope that this is explained better in the example I have attached. I have attached it in pdf format but can attach it in another format if that would help.

Thank you in advance!

[shg]

I have attached it in pdf format but can attach it in another format

A workbook?

[lfourtner]

I have attached the actual workbook I am working with. There are hidden cells with calculations in them just so you know if you need to unhide them.

Thank you!

This another forum I have posted this on:
http://www.mrexcel.com/forum/showthread.php?t=360980

[lfourtner]

Bump No respone yet

[JBeaucaire]

Do the first machine setup properly, but manually, and remove the $ signs from the K2 ad F2 references so they become relative (changing when copied) references. But you have to manually setup the whole first machine.

Then copy those range sets to the next machine and they will all point to the correct relative position in the new machine set.

I would also build into the formulas some "checks" so if there is no data the row shows blank without having to delete the cell formulas.

Please Login or Register  to view this content.

I noticed you have two "sizes" of charts, you'll have to manually set one up for each chart size, then you can copy from matching chart-size to matching chart-size.

[lfourtner]

I tried this and I get an error #DIV/0!. The problem is if I copy and paste the first row of "machine#1" to the first row in "machine #2 it works fine. But if I want to move the 1st job on "machine" #1 to the 2nd, 3rd, 4th.............. row in "machine" #2 I get the error above.