Hi!! can u pls help!!!
I need to copy table from sheet1 to sheet2
horizon B14:F23 (qty of rows may vary depending on the amount of inputs from customer)
expected result: table copied to sheet2 with exact amount of rows as in sheet1 (i.e. macro inserts more rows if needed & inserts the table from sheet1)
thank uuuu
Last edited by arkharova.s; 02-18-2014 at 03:53 AM. Reason: wrong title of the post
Your title says that you want to hide rows.....
Your text says that you want to copy cells...
Finally what do you need to do?
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.
Duplicate post:
http://www.excelforum.com/excel-prog...ining-n-a.html
Hi
Id use a do or For cycle & then if to find rows where is #N/A
Please Login or Register to view this content.
I think thar OP used by mistake the same title as in his other thread. In this thread the describtion of what he wants to do is different....Let's wait for a while...Originally Posted by JOHN H. DAVIS
dears, my apologizes for misleading u, i was opennig 2 threads simultaneously, & used the same subject for different questions.
my 1st qs on : marco to hide rows containing #N/A was answered by 2 members, both options work great! thank u all!
my open qs: i want to copy table from sheet1 to sheet2 via macro; amount of rows in table sheet1 may vary depending on # of requests from customers. Current horizon is B14:F23 (but it may change to F27,50,150 etc). So, macro should copy this table to sheet 2 & insert/delete rows if needed, i.e. make exactly the same amount of rows as in sheet1.
Hope it clarifies
thank uu, awiaiting for ur responses!!!!
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
Hi Fotis1991,
done, thanks for ur help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks