...June 2018 file. There is a tab in the GRv June 2018 file called Weekly Floats. This contains around 4 different tests conducted on different dates. I need the code to copy the data from each test to the appropriate columns in the FSHT. This code needs to be able to work if the GRVN June 2018 file is changed. It also needs to work if regardless of how
...DO First I want to scap data from the job marketplaces on a daily basis. Second I want to check how long (in days) the job postings are available on the market places (and track the days). WHAT YOU SHOULD DO Step 1 (data scrapping): Please review my VBA sample code (attached) and update it in order to scrap the relevant data from the website. You will
For excel workbook: 1. Clean "Full Article" column of unnecessary tabs, characters, etc 2. Separate the text by paragraph (using tidytext or tokenizers) - save as new column 3. Create column for or count of paragraphs 4. Filter for paragraph 1 only 5. Search for keywords (provided below) 6. Add keywords as its own column 7. If keywords appear in paragraph
Module required to split UK postcode (zip codes) as per attached spreadsheet. The table on left is an Access table. The yellow table on right will be the resulting query, The module needs to b run to create a query as per the yellow table. So the new row is created after each space and then at the end of the cell. Unless there is a space the group will remain together e.g. BD1-22,97-99 1 B, BB...
Have a hand me down Access file that takes a spreadsheet and uploads it to a database. now have an error and would like help resolv...database. now have an error and would like help resolving the error to find the specific place to add table modifiers as I am not strong in VBA. would probably take someone 10 minutes to figure out who is good with VBA.
An Excel spreadsheet on an iphone is being further developed and assistance with coding for two columns is requested. IMPORTANT: Due to the limitations of Excel running on an Apple Iphone environment no VBA code can be used. The two columns to be coded draw on the surrounding columns to decide what data populates each cell.
Need create a excel file with two sheets, the fisrst sheet with organizational info (Name, Department, Manager) and in this sheet create a button to call the VBA to create a new sheet with Smartart organization chart populated.
...ending from cell A2 (8) Read data from URL: [login to view URL] (9) 20180617 is the date from cell A1 (10) Dump data in sheet HB_Houston for only column selected from (2) above (11) Use formula in column C for sheet HB_HOUSTON and create column DateTime (12) Average the hourly data and create summary table starting
Looking for a manager to manage our advertising - to start from basic - creating and setting the right way, and manage all advertising for our platform. We need FB Adword, native ads... etc Must have experienced proof! for Saas platforms and eCommerce. Must speak English Must know to bring results!!!!
we are trying to insert excel data into a word table using the insert>table>excel spreadsheet function and retaining the underlying link to the excel workbook. Have that part down but can not figure out how to format the linked excel table to match the formating in the underlying excel file and can't get it o re-size to fit to one...
I currently have a userform (triggered by the "Add New" button on Sheet1) that is supposed to autopopulate the data that is typed into the textboxes and listboxes into the next available row in on my Sheet1. Currently, only the listboxes are populating once I press my Submit button. Please help my debug my textboxes, which are name as txt___. I also
Conversao planilha excell em sistema utilizando VBA
hello i have 4 macro that needs to be simplified as much as possible. Makro 1. checkfelter 2. checkfelter indtastning [login to view URL] tapet [login to view URL] I wish it at a fixed price I have previously used another freelancer but he did not have much time so I want new freelancer.