Auto COPY-PASTE from one spreadsheet to another

Closed
JahSent Posts 1 Registration date Monday December 15, 2014 Status Member Last seen December 15, 2014 - Dec 15, 2014 at 07:08 AM
joshdupler Posts 2 Registration date Thursday March 12, 2015 Status Member Last seen March 12, 2015 - Mar 12, 2015 at 06:43 PM
Hello.

First of all thank you that you are willing to help. This is much appreciated!

I am new to Excel (but I know how to apply macros) so please excuse the fact that I don't express my mind with a proper technical terminalogy.

English isn't my native language. Hopefully you will understand what I am trying to achieve. I will explain it as detailed as possible but please ask me if in doubt.

I have 2 excel spreadsheets. LabData.xls and Review.xls

I want to copy cells from LabData.xls selection is: D1 to CI1 ; D2 to CI2 ; D3 to CI3 => $D$1:$CI$3 => Selection contains 3rows and 84 columns.

And paste it accordingly to Review.xls B5 cell which will fill everything from B5 to CG5 ; B6 to CG6 ; B7 to CG7 => $B$5:$CG$7 The same number of cells, same order - 84 columns x 3 rows.

The paste point is to be changed upon Date variaty. I want the copy selection cells be always the same $D$1:$CI$3 LabData.xls but paste point is different. B5, B9, B13 etc B(X+4) Review.xls depending on Date:

In LabData.xls I have a cell which indicates the Date of report data = LabData.xls cell B4. In Review.xls I have a coresponding date cell which is either A4,A8,A12 etc A(X+4)

Lets say that 1st of December is A4 (just for example), 2nd of December is A8, 3rd = A12 etc in Review.xls. If LabData.xls B4 cell is indicating 1st of December then Paste the selection to B5 of Review.xls. If LabData.xls B4 cell is 2nd of December then Paste it to B9 of Review.xls.

Basically I want the macro to compare LabData.xls B4 cell with A4,A8,A12,A16,A(X+4) cells of Review.xls and if Date in B4 cell of LabData.xls is equal to one of A(X+4) cells in Review.xls then paste it accordingly to B5, B9, B13 etc.

For example in LabData.xls B4 cell is 4th of December (which is equal to A16 Review.xls), then copy $D$1:$CI$3 LabData.xls and paste it to B17 Review.xls which will fill all cells $B$17:$CG$20 because B4 LabData.xls = A16 Review.xls

If cell B4 LabData.xls is equal to cell A80 Review.xls then copy $D$1:$CI$3 LabData.xls and paste it to cell B81 Review.xls ($B$81:$CG$84)

If cell B4 LabData.xls is equal to A224 Review.xls then copy $D$1:$CI$3 LabData.xls and paste it to B225 Review.xls ($B$225:$CG$228)

Dates in Review.xls aren't constants. One day cell A4 Review.xls can be 1st of December, the other day it can be 4th of July. Macro should understand it.

BIG THANKS IN ADVANCE!

2 replies

ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 16, 2014 at 01:31 AM
you should open both files together and go to destination cell which is B5 in review.xls and type = then you should select D1 cell in Labdata.xls. now d1 cell in Labdata.xls is equal to B5 in review.xls after that you should extend B5 to right and down,
i hope it helps,



0
joshdupler Posts 2 Registration date Thursday March 12, 2015 Status Member Last seen March 12, 2015
Mar 12, 2015 at 06:43 PM
Quick question. I have a main input page and would like to have the Project name (which is same as the sheet) to copy the info and past it in the correct sheet in the next available space. Please help and Thanks
0