Excel Project(repost)
$30-5000 USD
Pago na entrega
This is an Excel project with the following requirements.
1-the values in certain first range of cells is to be rounded up or down to the nearest predefined fraction.
2-the new values is then compared to the values in second range of cells.
3-When the matched values are found then the cells in the second set should be formatted exactly like the matched cells in the first range of cells.
## Deliverables
This is an Excel project with the following requirements.
1-The values in a predefined range of cells (which we call the? Range A) is to be rounded up or down to the nearest predefined fraction (e.g .01 or .05 or .25 ).
2-The new rounded values is then compared to the values in another range of cells (which we call the? Range B? ).
3-When the matched values are found in Range B then the cells in the? Range B? should be formatted exactly like the matched cells in? Range A? (i.e. font size, font color , background color ,etc...).
Note: the ranges that are used may be from different worksheets but are all in the same workbook.
* * *This broadcast message was sent to all bidders on Tuesday Dec 22, 2009 2:01:37 PM:
Attention all biders: Please take note that since the code will be used many times on many ranges in a workbook , there must be a user friendly way for me to define 3 pieces of information. 1- The fraction by which the values in range A to be rounded up/down.(e.g. 0.10 or 0.25 or etc...) 2- Range A needs to be defined. 3- Range B needs to be defined. Please adjust your bids if you need to.
* * *This broadcast message was sent to all bidders on Tuesday Dec 22, 2009 4:11:12 PM:
Thank you all for your bids . It seems a little more clarification is needed. Below is an example of how the code should work. Suppose Range A contains 5 cells with values 100.23 , 153.435 ,413.02 , 254.78 , 367.89 This range is rounded to the nearest .25 decimal which gives the following values : 100.25 , 153.50 , 413.00 , 254.75 , 368.00 Range B has 1360 cells starting from 80.00 to 420.00 (with 0.25 increments apart like 80.00,80.25,80.50,..to...,[url removed, login to view],420.00) Now what the code does is to find the value of the cells in Range A that match the cells in Range B and will format the same cells in Range B as they are in Range A.(same font size , color , background, etc...) Note: There are going to be many sets of Range A and Range B in the same worksheet and workbook and each set should operate separate from each other.
* * *This broadcast message was sent to all bidders on Tuesday Dec 22, 2009 4:15:31 PM:
By the way please try to provide the most efficient and user friendly and least time consuming method as this will have the greatest impact of your bid being accepted (with a reasonable bid price of course).
* * *This broadcast message was sent to all bidders on Tuesday Jan 5, 2010 6:17:47 AM:
It seems there are a lot of unresolved issues for many bidders so in order to answer all your questions I have attached a new zip file which contains four files to provide full explanation . Please start with the file named “Project description?? and after studying all the files please adjust your bids and time required to do the task accordingly.
ID do Projeto: #3059774