Incrementing cell references

[emm8080]

Hi

I have a list of hotels and their availability - I want to create a ne
sheet (Sheet 2) with the availability days in column B.

Sheet 1

A

Bell Hotel
(Thurs, Fri, Sun)
Oak Hotel
(Thurs, Fri, Sun)
River Hotel
(Fri, Sun)

Would like

Sheet 2

A B

Bell Hotel (Thurs, Fri, Sun)
Oak Hotel (Thurs, Fri, Sun)
River Hotel (Fri, Sun)


Obviously, Sheet 2 column A would be = sheet1!A1

What cell reference would I put in Sheet 2 column B - as it would hav
to reference every other row.

Thanks

Emm

 

[Jack Schitt]

If it is just a one-off exercise:
Autofilter the data
Filter by Custom criteria "Does not begin with", (
Copy the filtered data and paste to column A in Sheet2
Filter by Custom criteria "Begins with", (
Copy the filtered data and paste to column B in Sheet2

 

[emm8080]

Thanks, I was over-complicating the issue!

Emm