create a button to reference values from source page

strelec

New Member
Joined
Sep 16, 2014
Messages
1
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:

Start Date:9/14/2014
Student NameValue1Value2Value3
John Smith100100100
CALCULATE

<tbody>
</tbody>
Rick Johnson150150150
CALCULATE

<tbody>
</tbody>
Katie Evans165210190
CALCULATE

<tbody>
</tbody>

<tbody>
</tbody>


Data sheet:


Start Date = SourceDate + 14 days9/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
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,215,737
Messages
6,126,559
Members
449,318
Latest member
Son Raphon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top