memot
New Member
Hello,
I have two questions, first one; in my excel i'm getting some values from the excel add-in. When i press the F9 my new dates and some values are written automatically. And some cells must be written manually. After i write my new value manually i must copy the formulas from above, However my charts' ranges must be expanded for my new values. What can i do here?
Please have a look at to my example-set.xls, after that you could understand me better.
My another question is familiar; in my this work i need to find the unique values number everyday and the source is changing day by day. But i don't want to fix my formula every day, maybe some tricks make my formula understand the range automatically.
Please have a look at to my example-check.xlsx.
Best
Mehmet
I have two questions, first one; in my excel i'm getting some values from the excel add-in. When i press the F9 my new dates and some values are written automatically. And some cells must be written manually. After i write my new value manually i must copy the formulas from above, However my charts' ranges must be expanded for my new values. What can i do here?
Please have a look at to my example-set.xls, after that you could understand me better.
My another question is familiar; in my this work i need to find the unique values number everyday and the source is changing day by day. But i don't want to fix my formula every day, maybe some tricks make my formula understand the range automatically.
Please have a look at to my example-check.xlsx.
Best
Mehmet