S
Suzanne
Is this possible?
Active Workbook = the open workbook (variable document name)
Active Worksheet = Data Entry
Surveyed Buildings = a worksheet within a closed workbook (2009 Surveys) a
different folder
Activeworksheet("A2") = building #
Activeworksheet("B2") = survey date
Activeworksheet("C2") = next scheduled survey cycle (1 year, 2 year, 3 year)
Surveyed Buildings("R:R") = building #
Surveyed Buildings("S:S") = survey date
Surveyed Buildings("T:T") = next scheduled survey cycle
Surveyed Buildings("U:U") = next scheduled survey
If Activeworksheet ("A2") matches a building number in Surveyed Buildings
("R:R"), place values from Activeworksheet(B2, C2) in corresponding cells of
Surveyed Buildings: otherwise place the data on a new row
Calculate the Surveyed Buildings next survey date: survey date(S:S) + 1
year, 2 year, or 3 year
Also! If the next scheduled survey date is calculated on the
Activeworksheet, can the data be sent to Outlook (on the calendar or a new
task?)
Active Workbook = the open workbook (variable document name)
Active Worksheet = Data Entry
Surveyed Buildings = a worksheet within a closed workbook (2009 Surveys) a
different folder
Activeworksheet("A2") = building #
Activeworksheet("B2") = survey date
Activeworksheet("C2") = next scheduled survey cycle (1 year, 2 year, 3 year)
Surveyed Buildings("R:R") = building #
Surveyed Buildings("S:S") = survey date
Surveyed Buildings("T:T") = next scheduled survey cycle
Surveyed Buildings("U:U") = next scheduled survey
If Activeworksheet ("A2") matches a building number in Surveyed Buildings
("R:R"), place values from Activeworksheet(B2, C2) in corresponding cells of
Surveyed Buildings: otherwise place the data on a new row
Calculate the Surveyed Buildings next survey date: survey date(S:S) + 1
year, 2 year, or 3 year
Also! If the next scheduled survey date is calculated on the
Activeworksheet, can the data be sent to Outlook (on the calendar or a new
task?)