Very simple requirements: 1) create excel vba code that will open a text file (e.g. [đăng nhập để xem URL]) 2) code will then do the following: 3) look for person's name in the line (e.g. Dr. FirstName Last Name) 4) remove the firstname and leave only Dr. LastName) 5) save text file without any further edits [đăng nhập để xem URL] - SHOWS YOU THE INPUT FILE (sample) after_edits
I have an excel to save information about a music performing business... file with this estructure: I use a worksheet for every presentation. Saving information such as: date, client, amount charged to client... In that sheet I select from a dropdown list the artists that performed in that presentation and their rate... Everytime we have a presentation
...(2+2+2+1) required on 5973, 5974, 5986, 6393. So, if there're 7 QTYRQRD while 5 FONHAND, we're short by 2. I want you to write a custom Macro or a custom excel function which does that for me. What I want Excel to do is, sort the QTYREQRD by DATE, and allocate them by First Come First Serve. For example that we have here, Job Number 5986 required
I am having a hard time creating a macro to ‘call’ a SharePoint. I am needing a VBA Excel macro code to ‘call’ a SharePoint so I can chose a file within the SP and have it automatically populate to a tab within the Excel spreadsheet.
need a macro that selects only cells with number format (including cells that display as text but actually have a number format e.g. cells with "n.p" ) and copies all number format cells from the input tab to the output tab. Have tried using the goto special function but it won't select the "n.p" cells or cell with a minus figure. plus goto special
Hello , I want you to split my excel data to individual files(macro or something) Example: lets say there are 100.000 lines in my excel, I want splite them to 10.000 x10 files. But the first lines on each excel will be a specific value.
...see file timesheet report_2018-0805_thru... That file is that copied on to file Construction Tsheets-CRM Transformation and we press CTRL->L for a built in macro to transform into file After Macro Construction Tsheets-CRM Transformation. We need to have the original file timesheet report first mentioned..... have a daily over 8 hours overtime calculation
Hi Leah A., You helped me with a project a couple of months ago. I wanted to see if you could make some modifications to the excel macro document you created. I added more rows to the original (2). thank you, Lauren
There is a requirement to produce a consolidated Group Daily Sales Summary Excel report from separate (and slightly differently formatted) Excel spreadsheets from each of 10 different brands. The Group Daily Sales Summary report Excel template (1 page) has already been designed and already uses the data from each of 10 separate Sheets in the same Workbook
...i'm wanting to build a budget based app that helps me track my practise,the information and produce built must remain Intellectual Property (IP) Agreement ,i have built a excel macro as a prototype their are a number of macros ,but would like some help CC+ Software or program into a live app ,or iPhone, Mobile App Development, iPad, Objective C, Android
Create a tool (eg. Webapp or Excel-macro) that can load a list of URLs and return number of hits on 5-10 Keywords pr site. Purpose: The tool should help qualify which websites are communicating about a specific topic. Eg. Return hits on the keywords "Events, Conferences, Seminars, Expos, Calendar" on the loaded list of keywords. Design: Not important
Combining several files with certain layout (the data will keep adding every month until 1 full year ) do data processing by macro , presenting summary using pivot and chart
Process daily store sale summary report from text file format into excel database. Based on the excel database stored data, able to search data to analyze sales data by each category by day, by week, by month and generate report and charts. Report need to be intelligent to show where the sales are good and weak. Need report for ordering item based
...can easily be imported to a MySQL database table. I have sample .SIM files, an Excel spreadsheet with a macro that currently parses the .SIM file to populate cells in itself, and a macro to pull just the data needed that was started that doesn't work. I need an Excel macro expert to get this working. The attached .zip file has the sample data - a couple
Create Sa...DECIMAL NUTS CODE etc. Ability to select # of data records Ability to select values for few fields which will be static throughout the sample data file. Deliverable is an excel macro workbook which takes some input parameters including the static field values, # of data records, type of template and then the output is a sample data file.
I have 4 excel macros running on windows 7 that need to be rebuilt so they will run correctly on windows 10 system. Issues to be resolved: 1) auto run the Excel tasks every 3 hrs (using Windows Task Scheduler - or other app(?) if Task Scheduler is not stable) 2) avoid memory leaks 3) ensure that data imported from source CSV's is fully loaded before
Needing a quick macro developed that will use one source of data and compare it to an Excel workbook with multiple sheets. It will identify matches within these sheets and change the matching text in GREEN and the non-matching text in RED. Must be able to accept uploaded information, not cut and paste.
Macro: ORDERMENTUM_IMPORT Purpose: To open a file exported from the ordering website and populate the the excel order spreadsheet with quantities matched to the product codes for matching customers. Pre-processing: Prior to populating the spreadsheet, a number of checks should be performed on the exported data. Any negative results of the checks should
I have a report in Excel with 4 different Graphs p/sheet and those graphs are taking the information from the same file with all the data by day included in the same sheet. I need to have a button that says "Weekly" and move all the information of the graphs from Daily to Weekly, of curse summarizing and combining the daily data into weekly data. another
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.
I need someone to design a macro that will copy and paste a range of cells to other sheets based on the values of certain cells. You will see the list of requirements on the "Main" sheet
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates.
click each link and indicate in column 'i' with an 'x' if link is leads to photo. If error occurs and link cannot be followed then leave column 'i' blank. Link is in column 'h' EXAMPLE in file: row numbers 228,645 & 228,644
create a simple excel macro that looks up a stock ticker online and place a current price value in an adjacent cell. to have a refresh button on the excel sheet that allows for multiple refresh of multiple cells with one click.
We will provide a set of input files in a folder. Each of the input files need to be read from the folder and based on logic, needs to be converted into another format (excel sheets)
This project is about a Word macro that builds letters off another Word template files and retrieves data from an excel spreadsheet and pushes the data into bookmarks. Please see the attached PDF for a more detailed overview.
...am developing a few reports in excel that requires mid to advanced level of expertise in Excel and Macros. I have mid-level expertise in Excel. However, I need someone to guide through the report building process. The work will be on an ad-hoc hourly basis. I am looking for advanced level expertise in excel and macro development. Power BI expertise
Write a VBA/Macro Using Excel for analysis a huge number of property information, including all particular, Historical and Current rental status, Rate of Return, Historical and Current Market Value, Profits or Loss and Banking Facilities Information for each of the property.... Steps 1. Design "Master Data Sheets" to contains all information 2. Design
We use the following macro for gathering information from invoices on spreadsheets and compiling them into a larger database type spreadsheet. The Macro has been working fine for years but has stopped working in our last update (running office 365). Macro gets stuck on this Err5 With Application ChDrive (Left([đăng nhập để xem URL], 1)) Hopefully
Attached is a spreadsheet that has readings from the new data site. Every site can have up to 3 sensors (identified by a sensor #) connected to a base (identified by a base #). I need a blank spreadsheet where the user can input the following: Input: Base #, Sensor # (or all sensors connected to that base), Date (single date). The spreadsheet would generat...
Volkswagen has a site, https://www.volkswagen-car-net.com. Here I can log in and turn on my car heating/air-conditioning. I would like to automate this task so I execute it from Eventghost webserver.
I want you to develop a macro that will run every time a PDF document is [đăng nhập để xem URL] rest of the message will be [đăng nhập để xem URL] expert bid me . thank you deadline 24 hours