macro for calculate and compare

B

bhargavsiva

dear friends,
i need one macro for the following calculation.

my sheet1 has daily values in rows for each day.
it has about 100 columns
my sheet 2, row 1 has the Factor values for sheet1 columns
and row 2 has acceptable values for calculated result.
my sheet3 has the results

calculation

x=sheet1!(a2-a1)*sheet2!$a1
if (x < sheet2!$a3,error,y=x)

sheet3!a2=y

row numbers will be changed according to date.

i have to enter daily values in sheet1
i have to calculate the daily results
unexpectedly the whole values will be disturbed.
i want to run thro macro.

please help me
 

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

Insert full row from worksheer to another base on condition 1
Development combinations with exclusion of columns 0
Compare formula 2
Macro to copy data X number of times into a column 0
add hyperlink using sheet names and cells(i,j) 3
Match Copy/Paste Macro almost there 0
IF Statement Problem 4
macro works - very quick 6

Top