Réalisation d'une macro qui 1- enregistre une feuille courante avec un nom structuré et un path 2- Effacer les zones saisies 3 - mettre à jour le n° de pièce suivant 4- Enregistrer le classeur
Bonjour je voudrais quelqu'un pour Budget c'est l'equivalent du 50USD en divise mexicaine. 1 enregistrer le macro montré dans le video [se connecter pour voir l'URL] entre les minutes 2:40 - 4:40 sur Adobe Photoshop en utilisant TeamViewer chez mon ordenateur. 2 Aussi, je voudrais que quelquen me montre comment faire un "clipping
Bonjour je voudrer quelqu'un pour 1 enregistrer le macro montré dans le video [se connecter pour voir l'URL] entre les minutes 2:40 - 4:40 sur Adobe Photoshop en utilisant TeamViewer chez mon ordenateur. 2 Aussi, je voudrais que quelquen me montre comment faire un "clipping mask" avec GIMP, exactement comme il est fait dans
Nous avons pour but de séparer chaque article d'un fichier Word à l'aide d'une macro Word. Explication : À l’intérieur des fichiers, il y a des chapitres, des sections, des sous-sections et des articles. Nous avons besoin de séparer chaque article par chapitre/section/sous-section. Voici la façon dont nous voud...
...base de données Excel pouvant avoir un nombre de colonnes et de lignes fluctuant, je souhaite avoir un tableau double entrée dont je fournirais le contenu et l'apparence. Je l'ai déjà fait avec l'enregistreur macro, cela fonctionne très bien, sauf que lorsque le nombre de colonnes ou lignes varie, j'ai un message d'erreu...
Réalisation d'une macro pour extraire données de plusieurs fichiers pdf et word (Date + tableau) pour les intégrer dans un tableau excel.
...J’ai besoin de rajouter une macro sur un simulateur tarifaire permettant de générer en un clic mon tableau en PDF et de l’envoyer en PJ à un ou des destinataires à la fois. Je précise que mes destinataires sont variables. Je dois donc pouvoir facilement changer le destinataire lors de l’envoi. J’ai réussi à cr&e...
As discussed, As discussed,As discussed,As discussed,As discussed,As discussed,As discussed,As discussed,As discussed,As discussed
I need a VBA expert who can help me highlight certain cells based on values in given cells. I would prefer a strong English speaker as the content is quite difficult and I have a very tight timeline! I will share the file with candidates and fully explain what I am looking for. Thank you!
Looking for an assistant who is available for approximately 20 hours per week to help; transcribe interviews for blog content, add photos and inventory data to company website, create spreadsheets, respond to emails, research market trends, provide research and examples for new business plans and grants, monitor social media channels and suggest new online influencers. Currently I manage marketin...
We have a few medium to complex excel macro (depending on your level of Excel Expertise) that needs to be created or modified based on our existing macro. Background: We have two worksheets in a given workbook file. We need to have various "column transpose" and lookups from sheet2 to sheet1. This is an ongoing progject meaning, if we need to add
...like: example: copy usbflash1:1234 usbflash0: copy usbflash1:abcd usbflash0: this code will stay same copy usbflash1:(only this should be changing) usbflash0: --------------------------------my code-------------------------- wait 'Router>' sendln 'ena' wait 'Router#' inputbox 'Router ID' 'ID' sendln inputs...
We are a Home Decor company. Require sales agent on commission basis to sell decor ascents and corporate gifts. We offer attractive commission on each successful conversion of sales order. If you are interested, we can discuss further.
...(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
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
New summer school starting 2019 in WILTSHIRE, UK. Loads of amazing activities all inclusive care, accommodation, teaching, food, activities £950 per week not including flights. Dates are - 29/7/19, 5/8/19, 12/8/19, 19/8/19, 26/8/18. I’m looking for 10 to 15 paying students aged 8-16 per week to come over for as many weeks as they would like from 1 to the full 5 weeks.
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
USA ENERGY CAMPAIGN LOOKING TO HIRE FEW CALL CENTERS TO WORK ON THIS CAMPAIGN A. SEATS : 5-10 ' B. SHIFTS : EST (USA) C. SHOULD POSSESS GOOD COMMUNICATION SKILLS AND HAVE TELE SALES BACKGROUND D. SHOULD HAVE AN EXPERIENCE INTO CALL CENTERS
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...
All warehouses have different lead time. Demand is monthly whereas demand fulfullment should happen by maximum 15th of each month at each warehouse.
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.
- Distribute digital surveys in the form of Google forms to locals in tier 1 cities in all of the following markets: Indonesia, Vietnam, Japan, Korea, Taiwan and UAE. - Sample size of at least 100 in *each* market - Timeline: 1 week Requirements: - An experience pollster preferably with proof of work in the markets mentioned above
In each tab in the associated excel workbook, there are 3 tabs. In each tab there is a source1 data and source2 data columns. Need to match the dealer_names in source1 and source2 by examining each of thecolumns in the sources and mark the the last "correct" column as 1 for match, 0 for different, and 2 if not sure. Needs fuzzy matching on dealer_name
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.