My recent searches
Filter by:
    Job State
    135,932 jobs found, pricing in USD

    Each month I receive an Excel report. I want to combine all the monthly reports into one worksheet of one workbook. The 1st step is to write VBA code to run in the personal macro workbook which will organise this report into an Excel table. The report is not organised into neat columns. It has been designed to be printed out, page by page and viewed as such. The 2nd step is for the table to be attached to an existing (several previous months) table in another, target workbook. In this way an historical listing of all entries will be built up in the target workbook's worksheet. (In the target workbook, the table headers will have to be inserted one time only, manually before the intial entries are placed in the worksheet. Thereafter, the monthly data should simply be attached to the bottom of the previous month's data). The key tasks at step 1 are to: Move data for each entry which appears in the "wrong" column/field into a newly created one; Eliminate report page headers and footers; Concatenate items of data lying in different rows of the same column (e.g. lines of an address appearing in successive rows below each other, but all in the same column) and move them to a newly created column/field; Allow for variation in the number of rows occupied by each entry (e.g., 2, 3 or 4 rows used by an address in one column); Allow for blank cells in some entries. The key task at step 2 is to move the data from the source workbook into the target workbook at the bottom of the historical rows of data. The VBA code should be well written and annotated with comment lines describing clearly each step in the procedure. Further possible work: I receive a number of other reports in the same manner and there will be a future need to carry out the same exercise for some of these. I have taken some time to create a sample set of dummy data (names and addresses, etc.) by editing an existing report. I have uploaded the dummy workbook to this project website. The reports come in the Excel 2 format, so any software policy restriction would have to be removed by yourself. Note, unfortunately, the source workbook's worksheet name is not standardised in the same format each month. In practice, different people produce this workbook and, although generally, the worksheet name will be in the same format, e.g. "Report (07-10-2017-0344-07).XLS", that format can vary from month to month. So far, the fields to be used as table column headers in the target workbook that I have identified in the Excel report are:- Account Code Active Client name Client description Created Managing partner Client Type Source of business Client address You may have a different view on the fields/columns that are required. I look forward to your quotation. Thanks John

    $109 (Avg Bid)
    $109 Avg Bid
    3 bids

    Je voudrais qu'on me nettoie le code de mon application Android enlever tous les bouts de codes qui ne sont plus utiliser, supprimer intégralement les codes des annonces Admob actuels, et me les réintégrer d'une manière propre. Le travail devra se faire d'abord avec TeamViewer. Une disponibilité immédiate est souhaité car le tâche est urgente.

    $155 (Avg Bid)
    $155 Avg Bid
    2 bids

    We want to have the same Instant quote system : [url removed, login to view] With the same fields: -Source language -Target language -Word count -Subject field -Standard/Rusc delivery and the Paypal button for payments (no e-commerce system) It must be on our WP web and it must be responsive

    $174 (Avg Bid)
    $174 Avg Bid
    12 bids
    Joomla Website 6 days left

    I need some work and a few modifications on a Joomla website related with tourism business.

    $164 (Avg Bid)
    $164 Avg Bid
    5 bids

    I am into UPS manufacture and need professional to handle digital marketing or to train me on digital marketing.

    $23 - $192
    $23 - $192
    0 bids
    Uniform design 6 days left

    I need a logo designed.

    $463 (Avg Bid)
    $463 Avg Bid
    34 bids

    리눅스 기타 또는 불분명 I want to make three games like tetris or bubble bobble, arcade games which can be play on raspberry pi3. This project is actually for old people who is over 60. So size of block in tetris should be bigger than original one. The games should be based on Linux because this games will be played on raspberry pi. Frankly I am not friendly with coding and I am nor rich. Only budget I can give you will be under totally 1000usd dollar. Thanks for all [Removed by [url removed, login to view] Admin - please see Section 13 of our Terms and Conditions]

    $1215 (Avg Bid)
    $1215 Avg Bid
    4 bids

    I need you to write some content for a website. Name: Ryan Bridge stone Project: Sales of laptops and shipping

    $4814 (Avg Bid)
    $4814 Avg Bid
    3 bids
    Trophy icon Design a Logo for 2 days left

    Looking for a simple logo for my new company SaqEx. 1) Want color version with maximum of two colors. I have found "Saq" being one color and "Ex" being the other color might be the best option. 2) Want a version of black logo, want a version of white logo. 3) No mascots or characters.

    $50 (Avg Bid)
    $50 Avg Bid
    0 entries

    We need attached company deck redeigned and company logo redesigned. We need it done in powerpoint so it can be edited as the company will be updating content regularly.

    $285 (Avg Bid)
    $285 Avg Bid
    34 bids
    Build a Website 6 days left

    I need a website similar to [url removed, login to view]

    $490 (Avg Bid)
    $490 Avg Bid
    13 bids

    The project to develop a complete interior design for a home. The scope includes: 1- lighting distribution 2- flooring colour 3- gypsum design for ceiling 4- wall design for wall (gypsum, paints, wall paper) 5- Furniture distribution 6- Electric points distribution The home consists of: Master bed room (Including dress room & toilet) 5 bed rooms (Including dress room & toilet) Office Family halls (3 no) Guest hall (Majlis) Dining room Kitchen pantry Gem Study room The them required is Classic European Victorian Palace Style Project Time is 90 days Project milestones and payment schedule will be discussed with winning bidder

    $1000 (Avg Bid)
    $1000 Avg Bid
    1 bids
    Trophy icon Logo Design 6 days left

    We are a commodity trading company specializing in copper, nickel, silver and gold. Our company name is called CCTL Global. Please propose some nice Logo designs plus the Font Design for the company name.

    $88 (Avg Bid)
    $88 Avg Bid
    0 entries
    Design a logo 6 days left

    I need a logo designed.

    $21 (Avg Bid)
    $21 Avg Bid
    4 bids

    Hi, I need somebody with android and iphone to test our mobile apps. I would prefer a team of data entry. We will send basic instructions on how to access the Mobile App. Install the app, run the test and send us the screen shots. Each app testing may take 3 min to 7 min depending on the user experience with browsing and data entry. There is no technical experience required required for this job. Anybody with bigger circle of friends and family with have the bigger advantage. Once Ist job is completed successfully we will invite for monthly app testing. Thanks & Regards, Mike

    $4 / hr (Avg Bid)
    $4 / hr Avg Bid
    1 bids

    Require a freelancer to work on updates to an existing Wordpress website to include new copy, images and minor layout. Plus further project to develop, from design, another wordpress site. Based on 1 week 23rd - 27 October, working out of our offices SW10.

    $989 - $1978
    $989 - $1978
    0 bids

    I need an Amateur - a totally new freelancer for a private xxx show on webcam. Amateur and without any hangups please. You must be 18 or over

    $15 - $25 / hr
    $15 - $25 / hr
    0 bids

    hire a virtual assistant that can work long term monday to friday fixed 5 hours a day

    $115 (Avg Bid)
    $115 Avg Bid
    18 bids

    I need some help with internet marketing. Need SEO guys who willing to work as partners for our website

    $712 (Avg Bid)
    $712 Avg Bid
    3 bids

    Hello I need a Magento developer to fix and debug an error. Please bid only if you are available to work now. Thank you.

    $11 / hr (Avg Bid)
    $11 / hr Avg Bid
    22 bids