Trying to edit data in other cells from a formula

  • Thread starter Thread starter Samuele Armondi
  • Start date Start date
S

Samuele Armondi

Hi everyone,
I've run into a problem with the fact that an UDF can't edit anything
apart from the cell it was called from. I'm developing a wages spreadsheet,
something like this:
NAME | RATE |STD HRS |ACTUAL HRS|PAY | where PAY =
CalculatePay()

I have a function called CalculatePay, and if the actual hours are less
than they should be it asks for a reason and updates another sheet in the
workbook. This is where I run into problems, as I can't modify the cells.
Can anyone suggest another approach?
TIA
S. Armondi
 
Hi
not possible with UDFs. The only thing that could do this would be
event procedures (if you require and automatic update)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Annual Wages Sheet to pick up info from Time Sheet 2
Runtime error 1004 when trying to insert formula in cells 11
Using code to edit spreadsheet formulas 5
Reference Global vars in cell formulas? 3
Help with Cell Formula 1
multiply criteria in a range using sumifs 1
Displaying zeros in cells 2
Convert all cells in a column from hrs into mins 1

Back
Top