"Taking only numbers and avoid blank and totals"

[Marwan69]

Hi guys,

As stated above, I've got 12 sheet tabs and opened a new sheet tab to copy the numbers without the total.
The structure of these 12 sheets is each row has a total and grand total at the end. I want in my new sheet tab that I opened to copy only the numbers without the total.

Hope is clear!

Many thanks,
Marwan

 

[Joe4]

The structure of these 12 sheets is each row has a total and grand total at the end.

So, it sounds like that these totals are in columns at the end of each row. If that is the case, you should just be able to exclude these columns from your copy range.

If there is something more to it, you will need to provide us with a bit more details of the structure, maybe even some examples.

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.