Melakukan sejumlah pekerjaan Excel Mampu mengoperasikan Ms Excel Mampu mengoperasikan Ms Word Mampu mengoperasikan Adobe Photoshop ++Design Grafis,membuat logo pada Adobe Photoshop dan Corel Draw ++mengoperasikan Ms Excel dan menguasai VBA project dan formula pada excel.
Membuat aplikasi VBA- excell untuk tracking portofolio saham dengan ketentuan sbb: 1. Menggunakan Real time data (1-5 min) 2. Update data saham secara otomatis ke portofolio saham 3. Dapat melakukan penambahan dan pengurangan transaksi saham pada portfolio 4. Dapat melaklukan sorting berdasarkan Nama saham, keuntungan (jumlah atau %), berdasarkan
I have an Excel tracker file from which two dashboards and graphs are to be generated. The tracker gets updated regularly. The dashboards and graphs are to be updated automatically. Time line to complete task would be 2 days. More details will be shared with short listed freelancers.
Hello, i am looking for someone who can scrape the DHL parcel information with MS Excel vba. The tracking number is given (Column A) and the tracking information (Column C:L) should be scraped from DHL page (Link in Column B) This should regulary be done for up to 50 tracking ids.
Hello, I have a task I need help with... I need you to go into this app called "PepTalks" and in the beginning before signing up the app will prompt you with a screen with quotes. I need you to write down all the quotes (or 100 at least) into a google sheet document. Grammar must be impeccable. All punctuation marks must be present, including quotation marks.
I want to pull data in from [log masuk untuk melihat URL] and other sites, and rearrange the data with auto-updating where it will store the data. I am looking to make graphs and charts. I am looking to have
Saludos cordiales, estoy trabajando en un proyecto de una hoja de excel para uso de pro-formador y base de datos, para una micro-empresa en el área textil, he avanzado algo con la programación y la obtención de costos en de los productos, y necesito ayuda para darle el acabado de presentación y que esta calcule algunos parámetros, necesario para el
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
Hi , I need demo ro using u...build this simple demo userform in outlook step 2 : set appoitment based cretiria the vba code should look for appointments in the calendar in date 14.11.2018 in this exemple if from example there is appointment in this data from 10-13 then the new appointment will be from time 13-17
...have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned
I need a VBA expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.
Crimson is a brand that deals in chic fashion accessories and has to come up with a website soon, therefore we need a content writer for the brand who can also make line sheets and catalogue.
Necesito un código en VBA que extraiga la data que está en la siguiente web: [log masuk untuk melihat URL]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
Tengo un hoja en Drive (Google Sheets) en la misma necesito que cada vez que me ingresa una venta en MercadoLibre se coloque en los datos del cliente que posee en en su cuenta: Nombre Apellido DNI Ciudad Provincia Ciudad Código Postal Teléfono El Código (SKU) de el o los productos que compro Cantidad de artículos Valor unitario Valor total de la compra
I need to extract only the dimensions (like 12 x 24 x 36 inch) from our product description column in our product csv file, and have the dimensions put in a separate column. I am hoping I can get this done for $200. There are roughly 2,500 product in the csv file. I think this could be done with a script or something instead of manually, but I do
Hi, I have 7 spec sheets in English for a salmon company which I need translated into Italian ASAP - much of the information in them is the same so it should not take too long. They are technical, but easy to understand.
I have a client server business application which is basically an accounting, sales, purchasing and inventory control package. I need to create a Qlikview dashboard with multiple sheets. One to give overview of company performance, one for sales and customer performance, one for suppliers and their performance and finally one for product performance
Google sheets script to send email and pdf attachment. The pdf name will be referenced on a google sheet. the drive is static. only email where cell C = N
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
please only German programmers Das Projekt muss mir VBA in Excel realisiert werden. Die genaue Beschreibung ist im Anhang zu finden. Es sind zusätzlich Dateien nötig, um die Aufgabe zu erledigen. Dies ist ebenfalls im Anhang enthalten. Die Programmierung soll in der Datei "[log masuk untuk melihat URL]" erfolgen. In dieser sind bereits Module und Code zur vorgese...
..."spreadsheet A" and apply the same modifications on "spreadsheet B". The "spreadsheet B" also contains one order per row but some columns are different and data is organised in a different way. There is a column named "order ID" that is used on both spreadsheets, it can be used to connect both spreadaheets and identify which row must be ...
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
Hi I need the following formula. We use Google sheets for tracking projects. We need to be able to know when we have assigend a person too many tasks for them to complete in one day. So if we assign them too many hours, something goes red to highlight it. Here is a sample spreadsheet: [log masuk untuk melihat URL]
I have an Excel spreadsheet that uses the worksheet_calculate function within VBA to monitor changes to a cell on Sheet1, which in turn triggers a timer whenever a change is made to that cell; worksheet_calculate is used instead of worksheet_calculate because the cell contains a lookup formula that references a table on another sheet within the workbook
Manufacturing business wants to take a daily download excel file from GE Appliance website and create a Macro/VBA tool for non-excel users. The tool would look up our internal part number and box count from a table and output a pick sheet for shipping with customer part number, our part number and number of boxes. Should be able to select time range
Need the file automated. I can provide a full walk through on how its currently done, but would like to automate the file! I have to filter every interval and it pastes data. I would like to avoid filtering every interval.
...couple/few hours of design help: I have a set up a simple online store for selling domain names, using Wordpress and Wordperfect. I'm experienced in other platforms (sql/vb/vba, etc) but novice with web design. The site is basically two pages: The "Front page" with links and product list, and the woocommerce cart/checkout page(s). - I'm very open
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.
- Updating of pivot tables to ensure that numbers change when cells are updated -...Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient