If Statement to Copy Multiple Cells to Another Worksheet
I have a template with data in columns A through F. When I change the value in column D for instance greater than zero I want A-F on that row to be copied to a master sheet. I also want this function to be continuous for every time I change column D it copies to the master in the next available row.
Is this possible?
Thank you!
Assuming your data start in row 2,in A2 of your Master sheet this ARRAY(confirm using control+shift+enter-not just enter) formula.
Copy down and across.
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks for the quick response!
I'm still having issues. my worksheets are titled template and master. from the template when I change the value in column D starting on row 10 I want top copy columns ABCD to copy to the master starting in cell A11. I want this to continue on the master every time I change the value of D on the template. Not sure where I'm going wrong on the formula.
=IFERROR(INDEX(master!A$11:A$1000,SMALL(IF(template!$D$2:$D$1000>0,ROW(master!A$11:A$1000)-1),ROW(master!A10))),"") cntrl+shift+enter
I love excel.
Last edited by cdh1234; 01-08-2013 at 12:00 PM.
=IFERROR(INDEX(template!A$11:A$1000,SMALL(IF(template!$D$2:$D$1000>0,ROW(template!A$11:A$1000)-10),ROW(template!A1))),"")
Cheers mate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks