...in merged cell, so paste all the rows wherever merge occured.- TO BE DONE 6. Search may be for a keyword or a small sentence of 2-3 words. - DONE 7. Code should be password protected. - DONE 8. The data sheets will keep on adding in future. There should be no limitation to it.- DONE 9. If data is not available in Column A but if available on any other
...an excel file, but the data didn't come out quite right. the list is 6386 rows and 4 columns wide. it should be 8 columns wide, but half of the data for each record is on the second row of the spreadsheet. so there are really about 3,000 records but their data is on two rows. it is not consistent as to whether the data in the first row goes with the
I have an excel spreadsheet that lists people (and their contact detail) against a number of contracts that they hold with our [login to view URL] contract is listed on a separate row of an excel spreadsheet. I want to mail merge my data to email such that a person with multiple contracts will only receive one email listing all contract details. I can see how to do this with word documents but n...
...logic. The idea is that as an item in one column is selected from a dropdown, the next column gives an option to populate it, followed by the next column thereafter and based on the filtered selections, results are displayed. The combinations are all laid out in the sheet. There is under 150 rows of data in the document and only 5 columns
...input of 3-4 letter codes. User interface for the program will be fairly simple with rows+colums and settings such as save, insert row/column and which data categories they would like displayed. Only 2 cells in each row will be editable - the 4 Letter code and a Notes Column. I have a concept design showing an example layout and identifying parts of the
.... I need a new tab created in the attached Excel file with a dynamic chart / line graph like the image attached. The graph is a monthly count of rows that include the following terms in EITHER column I or J. The graph will need 10 different color lines 1. hinge 2. broke OR damage OR dissa 3. replace OR return 4. mesh 5. wall 6. block 7. insert
...15 minutes and per minute) vary based on the service type - source data o The source data will be updated frequently (but will be in the same column format with variations on the number of rows). - calculated data Need calculated billing amount for each line (assignment). this needs to be able to refresh each time we update the source data
...from rows 2 through 52 (51 rows in total) and turn each row into a separate Word document (51 documents in total), with a different section for each Column heading (14 sections). Each document needs to be named using the Column D heading (UniqueWellID). Here is the order the sections need to appear on each document: Column D Column E Column ...
I just need quick calculation in Excel spreadsheet, 123 items on product price list. 2 columns ( and Q) to calculate discount percentage and 1 column (R) to calculate 0.75% fee. Only Rows 4 - 124.
In total nearly 40.000 records need to be cleaned. A test file of 500 will be delivered.
Insert multiple rows using form and PHP and (PDO with Prepared Statements) My code in attachments Please I want to fix it to Insert multiple rows using form and PHP and (PDO with Prepared Statements) The source of my code below [login to view URL] (Very Important) Please I don't want complicated way of
...populating. Process Checks: Whilst processing the data during the populating stage, the following checks should be carried out - Check 1: The "State" field should be checked (column D). If the state says "Cancelled", the data should not be imported. Any customers with Cancelled orders should be shown in the dialog box at the end of the import. Check 2:
...('encoding' 'latin1') ( 'album_name' "This_Album_Name" ) ('album_track_number' 2) I would like the following information extracted out to columns / rows an excel file. Column names: Artist Name, Song Title, Instrument Type (Guitar, Bass, Keys, Vocals, Drums, Pro Guitar, Pro Bass, Pro Keys, Pro Drums, Harmony ...
I need an Android app. I would like it designed and built. Need a two column to do list, nice and pretty and eye-catching. The left side has a cold weather theme, and tasks are added here, any number of tasks. The right side is the hit weather theme. You drag tasks from left to right or right to left. You can delete a task. You can add new tasks on
Need hours of operation added to an existing CSV file. any website businesses or .com's will be 24 hours Other businesses will be different ranges of operating hours. Must place all businesses alphabetically and then append hours
...the columns) * Ability to process all CSV Files in a folder (easy - recursive) Datatables needed: 1. Node Database with Unique Identifier and all information in the first 2 rows (see example spreadsheet) 2. Tags Database will use the Unique Identifier for the node to determine which CSV file the 'tags' came from. CSV Specific Requirements: * Node Database
I getting a SQLSTATE error message in the backend of Magento 2 on the order page. SQLSTATE[42S22]: Column not found: 1054 Unknown column '[login to view URL]' in 'field list', query was: SELECT `main_table`.`status`, `main_table`.`color` FROM `sales_order_status` AS `main_table` WHERE (`status` = 'pending') And i getting also a error message if i whant