Putting last three cells with data in a row into a set three cells

J

Julie

I have three columns of data per month. (Jan=RST, Feb=UVW, March=XYZ,
etc for 5 years) and I want to look across rows 16-200 and copy the last
month (3 columns) with data in it into the columns OPQ.

Specific issues:
I want the data pasted with values only because the first two columns of
every month have data validation.
I want all the data from rows 16-200 pasted even if they are blank so
they will cover over the data that was there from the previous month.
The cells that are not used are blank, but the last column for each
month has a formula in it: =IF(OR(R16="",S16=""),"",R16*S16)

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 
F

Frank Kabel

Hi
do you want a macro for this or are formulas also o.k. for you. What
I'm not so sure about is what you really want to tranfer:
- what is the last month?
- after this you said you want to copy ALL the data from rows 16-200

So you may explain this with some more detail / an example
 
J

Julie

I will need a macro. Here is an example for you:
16R=.5, 16S=1, 16T=.5, 16U and on =Blank,
17R=.6, 17S=5, 17T=3, 17U an on =Blank,
18R=.4, 18S=2, 18T=.8, 18U an on =Blank
I will need the last three columns with data in it (R,S,T) from rows
16-200 copied and placed in cells 16O:200Q. So 16R:200T would get
pasted special with values only into cells 16O: 200Q.

Answers to your questions:
The last month is the last three columns of data from rows 16-200.
The reason I want to copy all the rows from 16-200 is because I don't
want previous data left over from the previous month. For example if
16R:18T was pasted into 16O:18Q and then the next time the macro button
was clicked, if only 16U:17W were the cells with data and if only those
cells got copied into 16O:17Q, then 18O:18Q would have old data in it.

Hope this helps explain. Thanks for your help!
Julie

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top