Incrementing cell references

  • Thread starter Thread starter emm8080
  • Start date Start date
E

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
 
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
 
Back
Top