I need help with a worksheet. I have 0 experience with VB, but i feel this should be rather simple.
Sheet1 is my Source sheet. Source sheet has a start date, and a list of students with values. Each student has name, 3 values and calculate button associated with him.
Sheet2 and Sheet3 are my data sheets, they have date, name of the student and 3 formulas - one for each source value. Formula is always SourceValue * X where X is the value of Date formula cell.
When I click "calculate" button the desire is to
1) set date on Data1 = source date + 7
2) set name of Data1 = source name
3) replace value of Date1 C5 cell = Source Value1 * by the content of C5 cell. for example if Source.Value1 is 100 and Date1.C5 = 0.5, I want Date1.C5 cell value to be replaced with 100*0.5 = 50
I can record macro for 1) and 2) and it works, but I can't figure 3) part. Looks like I can't attach files here , so here is dropbox link https://www.dropbox.com/s/jd4erxps4q5efn0/Date_transfer.xlsx?dl=0 and if this doesn't work either below is copy paste from the file.
Source sheet:
<tbody>
</tbody>
Data sheet:
<tbody>
</tbody>
any help is much appreciated!
thanks
Sheet1 is my Source sheet. Source sheet has a start date, and a list of students with values. Each student has name, 3 values and calculate button associated with him.
Sheet2 and Sheet3 are my data sheets, they have date, name of the student and 3 formulas - one for each source value. Formula is always SourceValue * X where X is the value of Date formula cell.
When I click "calculate" button the desire is to
1) set date on Data1 = source date + 7
2) set name of Data1 = source name
3) replace value of Date1 C5 cell = Source Value1 * by the content of C5 cell. for example if Source.Value1 is 100 and Date1.C5 = 0.5, I want Date1.C5 cell value to be replaced with 100*0.5 = 50
I can record macro for 1) and 2) and it works, but I can't figure 3) part. Looks like I can't attach files here , so here is dropbox link https://www.dropbox.com/s/jd4erxps4q5efn0/Date_transfer.xlsx?dl=0 and if this doesn't work either below is copy paste from the file.
Source sheet:
Start Date: | 9/14/2014 | ||||||||||||
Student Name | Value1 | Value2 | Value3 | ||||||||||
John Smith | 100 | 100 | 100 |
<tbody> </tbody> | |||||||||
Rick Johnson | 150 | 150 | 150 |
<tbody> </tbody> | |||||||||
Katie Evans | 165 | 210 | 190 |
<tbody> </tbody> |
<tbody>
</tbody>
Data sheet:
Start Date = SourceDate + 14 days | 9/28/2014 |
Student Name = SourceName of the student | John Smith |
Formula1 = Multiply SourceValue1 by: | 0.5 |
Formula2 = Multiply SourceValue2 by: | 0.6 |
Formula3 = Multiply SourceValue3 by: | 0.7 |
<tbody>
</tbody>
any help is much appreciated!
thanks