Create list of data on Sheet 1, based on date on sheets 2,3,4 & 5 (ignoring blanks)

[OSP67]

Hi folks,

I'm looking for some help to create a macro that will pull data from several sheets, ignoring any blanks and produce a combined list.

For example, if sheets 2 and 3 looked like this in a coloumn of data:

Sheet 2
Column A
Answer 1

Answer 3
Answer 4

Answer 6

Sheet 3
Column A
Answer 10
Answer 11

Answer 13

I need the following to be created on Sheet 1:
Answer 1
Answer 3
Answer 4
Answer 6
Answer 10
Answer 11
Answer 13

The macro will be attached to a button on Sheet 1 that when pressed will pull all that data. (I can do that no probs, but don't know how to get it to ignore the blanks!)

[KOKOSEK]

Is it the same thread here:

https://www.excelforum.com/excel-pro...oring-bal.html

Check Forum rules #5.

[Pepe Le Mokko]

re opening thread, the duplicate one contains no data.
Closing the dupe

[OSP67]

Thank you Pepe, much appreciated.

[nigelog]

Please Login or Register  to view this content.