Very simple requirements: 1) create excel vba code that will open a text file (e.g. [login to view 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 [login to view URL] - SHOWS YOU THE INPUT FILE (sample) after_edits
Can anyone write a script to automate data update/upload to ms project from ms excel. I have standard forms and need to update the project data through outlook inbox or by any other means.
You should have 5 years of experience in Graphic Designing for web Portals, You have complete grip on photoshop. Should be individual. Budget is $100 We have one job portal which is already developed, but need some modifications and needs to update almost 10 pages. So you should be ready for it, need a person who can help for one week and should be free.
...marketing agency! The name of the agency is: Xclusive Digital Marketing Agency The logo needs to have Xclusive as big and authoritative with DMA smaller on the bottom or next to it. This logo needs to show authoritative, transparent, edgy, catchy, etc. We haven't decided on the colors, but would like to see your recommendation and once the
I’ll try to explain this the best I can. I want to setup 3 loops to pull data for college basketball games. I'm experienced in VBA but I'm having trouble creating a loop that does not error out after 15 games or so. There is some kind of security on the ncaa's site that prevents this type of data scraping I'm told. The workaround which has been mostly
Olá, Trabalho com varejo e atacado, venda de roupa feminina. Estou precisando de uma planilha em excel VBA, para otimizar meus processos de vendas e demonstrativos. Vi na internet muitas planilhas muito semelhantes a que eu preciso, precisando somente de algumas pequenas alterações, mas infelizmente quem as vende não faz alterações. a seguir as i...
We have all assets, 2 example displays (for structure), rough design complete. We really need this done in the next 6 hours for an emergency meeting.
I need an excel vba expert to write a two phase code for me, with the first phase being to import data from two different workbooks based on a userform where a certain value is entered, and the second phase to import data from another workbook based on certain letters that are entered for the value talked about in the first phase
...can see that there are 7 quantities (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
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.
Hi, I receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it man...receive constantly a data sheet that is always in the same format. The problem is that it is not a proper table and I need to amend it manually. I would like to have a little VBA code that does it for me.
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
...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
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 onto the consolidated Daily Sales Summary...