In Progress

Excel macro

I maintain an Excel database (the Excel version included in the Office 2000 suite) which includes a column of weights (Imperial, ie stones and pounds). The range of weights is from 7st 7lb to 12st.

9st 12lb is entered in a single cell as [url removed, login to view], 7st 9lb as [url removed, login to view], etc.

I would like the macro to be able to convert a run of up to 36 cells in a column from the data as entered to the values representing the difference between the values and that of the value in the top cell of the run. Thus if the values of six cells in a column were:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

I would like to be able to select the cells and apply the macro to produce the following values:

0

3

-21

-12

-16

11

Skills: Excel

See more: macro, macro excel, excel 7, cells, range macro excel, entered values, excel cell, macro convert data, macro cell value, macro excel database, imperial excel, excel macro convert range, excel macro convert data, macro values, convert database excel, convert macro, excel macro run, column data excel, excel database macro, convert excel macro, column excel, excel macro range, excel run macro, convert imperial excel, range macro

About the Employer:
( 34 reviews ) Harrow, United Kingdom

Project ID: #580937

Awarded to:

KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$30 USD in 0 days
(4 Reviews)
2.8

13 freelancers are bidding on average $30 for this job

vserv

Pls see your PMB. Thanks

$30 USD in 1 day
(60 Reviews)
5.8
blueocean09

Hi I can start immediately. Many thanks.

$30 USD in 1 day
(4 Reviews)
3.1
neelu7779

hi, I have done good quality Macros work. Please check the sample attached in the pmb

$30 USD in 2 days
(2 Reviews)
2.0
mjl78

I do a lot of work on Elance, and am interested in also making use of freelance. I am very experienced and proficient in Excel and VB. Your request sounds very simple. Per your example, it appears you convert the en More

$30 USD in 2 days
(2 Reviews)
1.6
subhadippal

I have experience in developing excel(vba and UserForm) based [url removed, login to view] will take few hours .

$30 USD in 1 day
(2 Reviews)
1.5
WaxonWaxov

Easy as pie. Been programming Excel VBA since Bush Sr. Administration.

$30 USD in 1 day
(0 Reviews)
0.0
sivaprasad183

hi, Interested ..See PM

$30 USD in 1 day
(0 Reviews)
0.0
rjancoski

I am looking to get started in the freelancing arena. I have a lot of experience in Excel and Access VBA and macros.

$30 USD in 1 day
(0 Reviews)
0.0
hsshah

Please see PM

$30 USD in 1 day
(0 Reviews)
0.0
umairahmad2009

i have a four memebr team. i am expert in micorsoft offcie and especially in excel.i willdo work in time and according to oyur term and conidtion

$30 USD in 1 day
(0 Reviews)
0.0
uttamdikshit

Respected Sir, I can do it very easily so please give me a chance.

$30 USD in 2 days
(0 Reviews)
0.0
dicadio

Please check your PMB, thanks

$30 USD in 1 day
(0 Reviews)
0.0