...much easier to explain, I imagine, with the spreadsheet actually in front of you. Not sure whether this can be achieved with simple formulas, array formulas or needs a VBA macro built out. Either way, we would like the simplest approach so we can service and tweak going forward. The excel contains some confidential info so I won't attach directly
vba/ macro auto create tab, dropdown and sheet based on data. i have excel file, i would like to create macro/vba to refresh/create tab, dropdown, sheet based on 1 tab called data1. let me know if i can call to make it eaier to explain
I have a net website and .bat sql file and godaddy hosting with plesk. Please extract and install/config the website from .zip and .bak files so it is working .rar of files is 110mb .back database is 5mb Files have already being uploaded, mention CALC in messages of your bid will be ignored. <package id="jQuery" version="2.2.3" targetFramework=&qu...
I need a staff rotation schedule coded and designed to work in excel 2010, ...coded and designed to work in excel 2010, i already have one done but it only works properly in excel 2013 and upwards, please let me know if you can do this? I can send you the file so you know what you have to do... if you dont have excel 2010 dont bother to bid please....
I have a PDF document with 800 pages. Each page belongs to each employee. You should develop an excel based macro to Extract PDF Pages and Rename Based on Text in Each Page (Content on the PDF). Looking for experts who have experience in this.
I need a macro that loops through multiple csv files in a folder (path) that compiles all the data in the csv files to a single worksheet in an excel workbook. I need the general macro allowing me to set the path of the csv files and the range to be copied.
I have a csv file of about 50,000 lines in French and English. But the two languages are mixed and I wish that a whole column is in French. The work is in two parts: 1: Find the cells that are written in English 2: Translate them. I think a script is needed for the job to be done quickly. But I do not need the script, only the result.
Для сайта [url removed, login to view] требуется создать калькулятор стоимости окон, аналогичный тому, что есть вот на этом сайте [url removed, login to view] . Слева - выбор конфигурации окна, справа - опции. При нажатии на кнопку "рассчитать" появляется анимация на 1-2сек, изображающая ожидание расчета и вывод результата. Требуется также предусмотреть возможность
I WANT MACRO CODE THAT CALCULATE IN EXCEL AND PASTE DATA IN WORD IN A SPECIFEID AREA ONLY EXPERTS BID PLZ ONLY ONE HOUR WORK FOR EXPERT. THIS IS JUST A SAMPLE WHIHC I WILL PAY BUT MORE WORK WILL BE GIVEN DEPENDS ON QUALITY FIX BUDGET 5AUD /HR
...structure with example data 1: Id,value 1001;15.15 1002;16.90 Table "cat_a_1" Structure with example data 1: id, data, cat_id 1001;4005 1002;4006 1 = Category Calc 2 = Price last value 3 = Price Plus specific value (shipment costs) 4 = Chosen Buy price method times given value = Sell price (Special Price) 5 = Result of “4” times given
need script to copy cells and process them. Instructions: [url removed, login to view] buton to start process (c3) in MVP GIS DATA QC [url removed, login to view] D1 to END to a new spreadsheet(MVP DATA CHECKER) [url removed, login to view] on below CASES color rows red or green CASES --1 IF Pending Replacement= yes and Validation Complete yes then color entire row in GREEN --2 IF...
Hi, I have the following requirements for an excel macro: There is a folder with many excel files containing data, and I want to merge these files. The data within the files have a similar structure: a fixed number of columns (to be defined manually within the macro) and a variable number of rows. All files have the same header (first row) which
I have one excel file which is using macro. I am going to extract some business logic from excel file and do database design. - Excel Macro - Database Design - Database administrator -Understand Business logic
A simple macro needs to be developed There are two files attached: 1: export_CSV_at_12_Jan_18_04_34_48 2. Media-Clic :Output File Every day I receive a file in CSV format which has numerous columns. So all I want is an output file like the one attached- Media-Clic. The CSV file has many columns but we only require the Yellow ones. How the
I need a Macro on my excel file - i need create links to my categories. In the future i will add categories and i will change the root url. Check the file - the specifications and examples are into (yellow cells).
VBA Macro to covert data from tabular to columnar format