Đã hoàn thành

Update Excel Data Spreadsheet

Excel workbook - works ok but needs to be able to be printed with standard format and check links so they don't break.

The sheet was done but not completed. It needs the final touches.

What it is is taking a basic csv file of lab results and converting it into something useful.

At present we can into a data section, this uses macros to change it convert it into a sheet that can be printed - this sheet uses ranges to say whether it is high or low. We then examine this to give some recommendations and then using a drop down sheet we then add some comments.

The colours on the results page are too bright - there are some cells that aren't linked properly (just the paddock name and the property name (customer name) in the header (set at Dorrington at the moment), when i select the from the dropdown box in the recommendations it adds these and if i want to write something different i do this in the centre column. This is OK but when i use the format button it doesn't seem to print in the same type or size. It all just needs a tidy up and checking.

f you import the lines of data from the CSV lab results into the Data page of the spreadsheet you will then see the results in the Analysis results. This is fine other than the colour being too bright and the two heading issues i mentioned (sample reference and the Dorrington in the header)
The second page is where all the links are that need fixing. Firstly change the order so that the comments are first and recommendations are second - recommendations only need a small amount of room. Comments work by drop down box - firstly we choose a heading pH/Calcium from the dropdown box. and then in the second row the dropdown box gives the comments that we usually use to explain what is needed with the nutrient from the first list. If this doesn't say what we want we then use the third column to comment with what we want. If there are several comments that we need we have to choose the first drop box heading and then again the second. Once this is complete we then use the Add Visual Format button on the Button sheet and it formats the result page. This doesn't change the typeface or the size to the same so we can read it properly - an it is where there are problems if it is not done exactly as required. Finally there are multiple results where we would only need three at the most. See what you can d0.

Kĩ năng: Xử lí dữ liệu, Excel, Microsoft Office, Visual Basic

Xem nhiều hơn: Get Data Entry Done - 04/06/2017 02:56 EDT, https blog zazzle com 2016 04 22 featured designer julieerieewn x, excel summary spreadsheet workbook 2010, query update excel data using classic asp, update excel data sql table, generate urls excel data spreadsheet, fix phone excel spreadsheet, script update excel data source, excel filling spreadsheet data macro, update excel workbook, visual basic code update excel shared workbook, excel copy data spreadsheet macro, excel vba update imported data, excel macro script insert data spreadsheet, update excel data php, update excel data, visual basic update excel data, excel data workbook, fix css dropdown menu, marketing spreadsheet

Về Bên Thuê:
( 2 nhận xét ) Seymour, Australia

ID dự án: #16759550

Được trao cho:

fatimatuzzohura

Hi, I am experienced on Excel and VBA. I can start your job immediately also. Please contact me to discuss the project . Thanks

$117 AUD trong 1 ngày
(122 Đánh Giá)
6.1

19 freelancer đang chào giá trung bình $45 cho công việc này

deepabittu

ready now ready now ready now ready now ready

$55 AUD trong 1 ngày
(208 Nhận xét)
6.4
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc VBA/EXCEL Thêm

$25 AUD trong 1 ngày
(65 Nhận xét)
5.7
$25 AUD trong 1 ngày
(36 Nhận xét)
5.5
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

$250 AUD trong 3 ngày
(25 Nhận xét)
4.7
standarditech

Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. I will complete this task with your timeline and [login to view URL] give me a chance to serve Thêm

$25 AUD trong 1 ngày
(75 Nhận xét)
4.9
microwebtechs

Hello sir, I am ready for start work now and complete all soon, please hire me and share work [login to view URL]

$30 AUD trong 1 ngày
(28 Nhận xét)
4.4
datakillers

Hi I am ALISON certified for Microsoft Office specially Excel and Access Database. Data Entry and Processing is my passion with years of experiences. I am very hard working and know the value of time so, always Thêm

$24 AUD trong 0 ngày
(16 Nhận xét)
4.1
$24 AUD trong 10 ngày
(3 Nhận xét)
2.6
$25 AUD trong 1 ngày
(2 Nhận xét)
1.9
signeortasaso199

I will do this for only $ 5 in three days I’m 2 years experience in data entry and microsoft office I want to make myself a review so i work with little price and high quality .

$10 AUD trong 3 ngày
(0 Nhận xét)
0.0
amarendrayadav46

A proposal has not yet been provided

$25 AUD trong 1 ngày
(0 Nhận xét)
0.0
$15 AUD trong 1 ngày
(0 Nhận xét)
0.0
$15 AUD trong 1 ngày
(0 Nhận xét)
0.0
Louisleroux

Good day, I'm new with Freelancer, but I am experienced in Excel and I'm a registered Financial Accountant in South Africa with 7 years experience! My focus is on accuracy and time efficiency! I will gladly accept you Thêm

$55 AUD trong 2 ngày
(0 Nhận xét)
0.0
$25 AUD trong 1 ngày
(0 Nhận xét)
0.0
thsvo

Hello sir I am a data entry worker and i know how can i do it [login to view URL] you give me a chance i will give my best for you Thanks

$10 AUD trong 1 ngày
(1 Nhận xét)
0.0
crea8ivevibez

Hi there, I consider myself to be the perfect choice for your job post regarding Update Excel Data Spreadsheet. I am new freelancer on this platform. I have the required skills and experience in this domain, hav Thêm

$70 AUD trong 1 ngày
(0 Nhận xét)
0.0
berainy

A proposal has not yet been provided

$25 AUD trong 1 ngày
(0 Nhận xét)
0.0