||...knowledge of excel macros and VBA. I have some data in a format that requires manipulation. With the right
||Data Processing, Data Entry, Excel
||Mar 5, 2013
||Mar 5, 2013Ended
Microsoft Excel Macros and Lookups
||Create lookups and macros in Excel for a dynamic spreadsheet.? The details are attached as well as the...spreadsheets.? This may also require some data manipulation.
Spreadsheets and further
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, Anything Goes
||Oct 21, 2008
||Oct 21, 2008Ended
140385 Excel Data Manipulation
||...the development of an excel spreadsheet running some VB macros which import data from an external sheet...sheet, manipulate this data a little bit then output the results to text files. Included in the zip file...the process, master spreadsheet, sample sheet with data which needs to be imported into the master sheet
||Visual Basic, Data Entry, Anything Goes
||May 28, 2007
||May 28, 2007Ended
Private project or contest #1696786
||PHP, Excel, Software Architecture, Visual Basic for Apps
||Jun 14, 2012
||Jun 14, 2012Ended
Excel Spreadsheet manipulation
||we looking to incorporate macros to download data from websites, basic formulas to calculate percentages...a look up function to find and relocate relevant data to a dashboard set up.
||Jun 2, 2014
||Jun 2, 2014Ended
I do have an excel spreadsheet which has 132,000 odd lines of data in it. I would like someone...only who are experts and has the ability to run macros etc. my budget would be around £85 max. due to
||Data Entry, Excel
||Oct 31, 2012
||Oct 31, 2012Ended
||NEEDED: Macros for Microsoft Excel that inserts the data from a specific cell into fields on various...Main Street; Anywhere, Californian 12345") into Excel, press a Macro, and have our web browser open up...search websites dropped back into specific cells in Excel for interpretation.
||PHP, Project Management, Data Entry, Engineering, Software Architecture, Software Testing, MySQL
||Mar 7, 2009
||Mar 7, 2009Ended
||Hello Excel Experts: I have a .prn file that i am opening in an old dos version of lotus123 and running...series of macros to delete/organize informations in the file. After resaving, i bring it into Excel to further...need is someone to help me with developing macros in excel to delete/organize the .prn file. In the attatchment
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL
||Dec 6, 2002
||Dec 6, 2002Ended
Need excel macros developed to take? sql output? data and plot standard as well as pivot table graphs...graphs within excel.
SQL is already developed to extract data from DB into Excel. Need the macro to...to do post processing of the data.
Time sensitive - need quick (1 - 2 day ) turnaround
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL, Visual Basic for Apps
||Dec 4, 2009
||Dec 4, 2009Ended
||...of data into 5 groups, take the average, median and count of each 5 groups and them put that data on...called mlsmaster (on Chino spreadsheet) that got the data to this point
2.? All of the #DIV/0! Need to be...3 rows need to be added in 5 places grouping the data into the following 5 groups (based on square footage
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Nov 29, 2008
||Nov 29, 2008Ended
||...who knows how to use Excel pretty well. Basically, I have a spreadsheet full of data. I would like to be...be able to set up macros that allow me to extract a set of data based on some criteria (such as by country...coder's Seller Legal Agreement).
||Sep 28, 2009
||Sep 28, 2009Ended
Excel macros for data analysis
||...- moves the data from each file to a sheet in the document - creates another set of data that's a subset...subset of the first set of data (this is because there may be 10,000 data points in the first, but we really
||PHP, Engineering, Software Architecture, Software Testing, MySQL
||Jan 23, 2010
||Jan 23, 2010Ended
Data Manipulation Pinal(repost)
||...move data into specific fields.
If you are good at manipulating data in excel and doing macros then
||PHP, Engineering, SQL, Software Architecture, Software Testing, MySQL, Database Administration
||Jan 5, 2008
||Jan 5, 2008Ended
Excel Macros to filter data
||I have an Excel file that needs to be filtered. There are several categories of information that needs...needs to be filtered.
The categories and the data elements will not change only the files will change...new file and run a macro to filter on each set of data elements I choose. For example I want to press CTRL
||Engineering, Software Architecture, Virtual Assistant, Business Plans, Software Testing, Business Analysis, Anything Goes
||Aug 5, 2011
||Aug 5, 2011Ended
Excel Build Support: Charts & Macros
||...currently building an Excel spreadsheet and simply need experienced guidance on macros and especially charts...charts (and the data manipulation needed to populate the charts) such that I can finish it myself. This...chart
• That represents nine data types
• Where some of the data are represented as markers on the
||Sep 20, 2009
||Sep 20, 2009Ended
Excel Macros for data and charts
||I have an excel spreadsheet model of river and reservoir operations that is getting rather large. I'm...I'm good with excel and ok with visual basic and have written some macros for inputting data and doing calculations...calculations. However, I believe the macros could be improved and the spreadsheet calculation could be
||PHP, Visual Basic, Windows Desktop, Engineering, Testing / QA, Software Architecture, Software Testing, Website Testing, Microsoft, MySQL, Usability Testing
||Jun 8, 2002
||Jun 8, 2002Ended
||Attached you will find an MS-Excel 2003 Spreadsheet with? 5 worksheets
1.? Photographer Assigned...Duplicate the spreadsheet
2.? Move and Copy Data from the header row and equipment listing for each...each worksheet.
3.? To see how I want the data manipulated, please see source.xls which is a short
||PHP, Windows Desktop, Data Entry, Engineering, SQL, Software Architecture, Software Testing, Microsoft, MySQL, Database Administration
||Feb 12, 2009
||Feb 12, 2009Ended
Two Excel Macros Needed
||I need 2 excel macros created.
Each will pull data from an online data source (mysql database) and...columns, rearrange some other columns, and delete some data based upon parameters I provide. I'd like those...online source (.txt file, tab delimited) and insert data into the file and then export it to a new tab delimited
||Data Processing, Data Entry, Excel
||Feb 5, 2012
||Feb 5, 2012Ended
||...have 100+ Excel files. I need to extract column and row data from these files, write the data to another...original Excel files in a directory.
2) run this program I'm asking for.
3) have new Excel files with...
The reason for the "spoofed" example data is that this data is sensitive to my company. The original
||Apr 20, 2013
||Apr 20, 2013Ended
||...want you to do the following:
Create a list of data that measures the total number of treaties signed/ratified...1964 for worksheet Chapter I-5a in the attached data. They would not receive a score on this worksheet...this for all possible pairs of countries for this data for all possible years.
This should create
||Engineering, Software Architecture, Software Testing, Anything Goes
||May 9, 2011
||May 9, 2011Ended