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
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.
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
리눅스 기타 또는 불분명 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]
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.
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
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
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.
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