endxlup failure because of table of formulas?

Can anyone tell me why the code below copies an entire table of blank rows instead of only those with data? And more importantly, how do i fix it? The tables i am trying to copy are a set amount of rows and each cell in the table has formula. I've also attached the full workbook if that helps more, SchedulesNew.xlsmThanks in advance guys

Please Login or Register  to view this content.

I've asked this question on MrExcel but haven't been able to solve the issue yet but here is some code provided by a couple of chaps from that forum...thanks JMonty and lancerj017 for the efforts

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

hey japandave, im not sure why but nothng happened when i ran that....except the screen blinked...so i guess it did something....but i can't tell what. Any idea?

Maybe you can find it here?

http://www.excelforum.com/excel-prog...-formulas.html

hey japandave, i tried that but still no results...can u make it only ignore blank result formula's? because the data that needs to be copied is also from formula....thanks again

Robert that is phenomenal, worked like a charm. So I'm trying to edit it to pick up tables across the "Tables" sheet. i thought i would just copy and past it and edit the letters....and that worked the first time, but the 2nd time it isn't bringing in the 3rd table like i expected. Is there an easier way to make this get all 15 tables other than to copy and paste the awesome code you've provided already and edit the letters? Here is the code as i've edited it

Please Login or Register  to view this content.

Hey Robert, again thank you for the code....I'm having a problem while editing this though....and im not sure where I am going wrong but now that i've added most of the extra loops i have noticed that it is returning alot of duplicate results.....multiple copies of one record. i was going to add the code that i have so far but its saying that my post is 10,000 characters too long lol...thanks again everyone for the help

I just realized i was saying Robert instead of Trebor76....Trebor76 it is your code that has worked...sorry for the mistake, thanks

hey trebor76, The problem i am having is that there are multiple instances of the same record being copied. It doesn't happen on the first table that I am moving or even the second or third....but after about the fourth table for some reason it begins making multiple copies of one data set. I'm not sure why as I don't completely understand the code you've provided. Is there a way to edit the code so that I don't have to copy and edit it 15 times to pick up all 15 tables.....the tables are all the same as the first and separated by one column. I marked the thread as solved because your code does everything i asked for in the post.....i always just assumed i would know enough to edit what someone provided to make it work for all 15 tables....I marked as solved before i found the duplication problem. Thanks again Robert

hi Trebor76, thanks for the reply again, i haven't had a spare moment for this in a couple of days, but I try out your code as soon as i get home tonight and post how it went

YAY!!! Robert you have done it. That works marvelously, thank you so much for your efforts, i can't tell you how useful this workbook will be for me and my office mates. again, YAY and THANK YOU!!!