''select the sheet where total appears
sheets("INCS&DECS").select
If range("A4").value="Total" then
rows(6:30).copy
' select the sheet you want to copy from
sheets("INPUT").select
'select destination and paste
INPUT.Range("A5").Select
activecell.pastespecial


-----Original Message-----

Greetins to all,
I would like to THANK all in advance for your generous
help. This is
my question. I have a file with two spreadsheets - INPUT
and
INCS&DECS. On row 4 of "INCS&DECS", i have an IF
statement to show the
word "Total" when appropriate. I would like to copy data
for rows 6 to
30 from the "INCS&DECS" spreadsheet to a specified area
in the "INPUT"
sheet whenever the word "Total" appears in row 4 in
the "INCS&DECS"
sheet. I am still an absolute beginner, although I have
tried in the
past - slow learner. Therefore, I am ashamed to say that
I don't even
have a piece of code to show for because I don't even
know where to
begin.

I would be greatful for any help with this problem.
Thanks again!


--
oakman
----------------------------------------------------------
--------------
oakman's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=9172
View this thread:
http://www.excelforum.com/showthread...hreadid=272818

.