Hi Sanaz
Not at all angry. I know you are new to this forum and thought would guide
you about the usage. Unless a user respond; the contributor will never know
whether the response has helped or not or whether the user did even looked at
the response.
Since you have posted your query in the Excel Programming group ; Patrick
would have given you a VBA solution. When you say
VB; here we are talking
about Visual Basic Editor in Excel (VBE) which is integrated with MS Office
products.
Open Excel and on your keyboard click on the "ALT" key (left of the space
bar), hold and click on the "F11" key (the F11 key is at the top of your
keyboard). Here is the Visual Basic Editor. Click again and you are back to
Excel.
When you have sometime refer the below link; (starter)
http://www.excel-vba.com/
About posting queries/responses etc; refer the below link
http://www.microsoft.com/wn3/locales...APostAsHelpful
Cheers !!
"sanaz" wrote:
hi jacob,
since yesterday that i sign up in this discussion board every one are so
angry with me. i feel so bad. yes actually i ve just noticed patrick answer,
but I dont have vb
and i need to use either macro which have matlab or just staments with if,
and, ...
thanks jacob
"Jacob Skaria" wrote:
Hi Sanaz
Few suggestions
--Please avoid multi-posting.
--Did you review the response from Partrick for your other post. If not
please do
--If you have reviwed that already; please respond to that post with whats
wrong, what you are looking for referring to what he suggested...
"sanaz" wrote:
hi,
I need to produce a table in excel, but its not just simple table it need
different conditions.
first row: time 0 0.25 0.5 0.75 1
1.25 1.5
second rw: load
ok my second row might have one of the 3 conditions below or it could have
all of them, the three conditions are
1- the load stay the same in all time intervals
2- the load is changing constantly with some increament dq
3-might have sudden change of load at some time
what i need to do is that ,some how, put all these conditions in one statement
eg:if load is constant during the whole time then put the same value all
over, but if it is changing with some increment then add each together, and
if you have a sudden jump at say time 0.75 then add one colume in between (so
that you will have two column that have the same time ) and add or subtract
the sudden change from the first colum of the time 0.75 and put its value in
the second colume and either increase constanlty or stay the same according
to the load.
I am desperatly waiting for help!!!!!