occupied

Hi, I need some help on a formula that will return the sheet name if a certain cell within other sheets is occupied, aswell as the same cell within the first sheet. I do struggle to explain myself at times, so I have linked to a picture of my worksheet which has been simplified for ease. I am...

I need to start a C1 then go across row 1 and insert 3 columns after each occupied cell. Thanks F

I would like to be able to produce a number of line charts and place them into an existing worksheet. Is it possible to have them placed into a sheet in the same way something like Range("A1").End(xlDown).Offset(1,0) would select the next cell below the last occupied cell? Ideas?

Dear Excel gurus, In our rather small church cemetery, we currently have an EXCEL Worksheet containing those owners of cemetery plots that are either "occupied", "sold but not occupied" and those that are still for sale. A few of the cells are concatenated to show [ie. John Smith, interned 12...

I was wondering if you guys could help me figure out how to pull the dates from the table below into two separate tables. I want the tables to be organized into: Table 1: all "1" bedrooms that are "New" and their corresponding "Collected Rent" and "Move in" dates Table 2: all "2" bedrooms that...

Hi, I am creating a spreadsheet in which I need to have the user basically book seats and have excel update those results on another sheet within the workbook. On Sheet 1 I have the list of destinations they chose from and the seat class they would like. On sheet two I have a tracker which...