Hello,
I am using MS Excel 2010 . And want to create a macro that will edit a cell range based off two criteras .
Meaning
if cell = sheet name then look for list box item in cell range . user input "date" then search sheet ref and row ref to input data in matching cell.
to further explain
B2:B80 all have a name and in E2:E80 have black cells i want to put dates in, i have devloped a advace filter to sort all over due dates and populate them in a listbox.
but what i like to do is update the open items in that listbox with a new "edit" userform , this user form alread has a working sheet target , and it has the listbox and a clear funcution. I would love to have it edit the cells and lookup the row based off the user inputs (ie listbox for open content and sheet verifacation.
Please bare with the typing i have a busted ( broken ) hand .
I am using MS Excel 2010 . And want to create a macro that will edit a cell range based off two criteras .
Meaning
if cell = sheet name then look for list box item in cell range . user input "date" then search sheet ref and row ref to input data in matching cell.
to further explain
B2:B80 all have a name and in E2:E80 have black cells i want to put dates in, i have devloped a advace filter to sort all over due dates and populate them in a listbox.
but what i like to do is update the open items in that listbox with a new "edit" userform , this user form alread has a working sheet target , and it has the listbox and a clear funcution. I would love to have it edit the cells and lookup the row based off the user inputs (ie listbox for open content and sheet verifacation.
Please bare with the typing i have a busted ( broken ) hand .
