Select table without empty cells?!

**solty89** · 12-14-2023, 06:54 AM

Hi, i meet the following problem, a have excel sample with functions from A-Z and rolls 1-2000 into sheet "A" . I paste data to this sample less than 2000 rolls, so could be for axample only 500 rolls from 1 - 500 . Than a have macros selecting this table and paste all data into new sheet "B", but paste only Values for reason. But after that i have another macros selecting the new sheet "B" , and the problem is here: It selects all 1-2000 rolls from the sheet "A", even if NO data in 501 - 2000 rolls, becouse i paste only Values in the previous action, and i dont want to be selected? I guess there is simple solution?

Thanks,
Vladimir

**AliGW** · 12-14-2023, 07:00 AM

Which version of Excel? Still 2013?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

**solty89** · 12-14-2023, 07:21 AM

it is 2016!!

**AliGW** · 12-14-2023, 07:22 AM

Then please update your forum profile, which says 2013.

Waiting for a sample workbook ...

**solty89** · 12-14-2023, 08:21 AM

Okey, I hope I attached the files!

So I copy all the data from "book2", and i paste it to "calc acc 2023 v2". I follow the process and than in "Final Sheet" i wanna hit Ctrl+A and select only the data (1-33 rolls) automaticaly, not all 1-2000 rolls!