Automate an Excel Spreadsheet with Macros
||Create a macro that will automatically populate an excel tab rows with running serial numbers.
Info...the ranges entered by our operator.
See attached excel sheet for example of data input format and output
||Visual Basic, Data Processing, Excel
||Apr 28, 2014
||Apr 28, 2014Ended
I do have an excel spreadsheet which has 132,000 odd lines of data in it. I would like someone...someone to develop a macro where up to a certain number of lines (month wise) the total for that lot to...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
Excel Spreadsheet Macros
||...I'd like for a coder to create 4 simple macros (including macro buttons) that assist in the proposal creation...Agreement).
Microsoft Excel 2003
||PHP, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Jun 4, 2007
||Jun 4, 2007Ended
||I need a macro that will sort, split up a range of data into 5 groups, take the average, median and count...and them put that data on a summary page.? This macro will need to be used on varying numbers of rows...
1.? There is an existing macro called mlsmaster (on Chino spreadsheet) that got the data to this point
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Nov 29, 2008
||Nov 29, 2008Ended
||...someone who knows how to use Excel pretty well. Basically, I have a spreadsheet full of data. I would like...like to be able to set up macros that allow me to extract a set of data based on some criteria (such as...need one macro that i could amend depending to what i need to extract from the spreadsheet.
||Sep 28, 2009
||Sep 28, 2009Ended
Building Excel Macros
||Develop a spreadsheet macro for various email database lists. Setup, testing, troubleshooting Macro.
||Data Processing, Data Entry, Excel
||Dec 19, 2013
||Dec 19, 2013Ended
Add Macros to Excel Spreadsheet / Dashboard
Add macros and formulas to Excel Spreadsheet so that the dashboard updates automatically when...average ie. Current month + 11 months / 12
2. Add macro to charts up so they update automatically
||Mar 8, 2012
||Mar 8, 2012Ended
||I need a Macro in excel that classifies the data in different columns.
The spreadsheet is not big,... if you know how to write macros in excel that will be a really easy task for you.
||Oct 31, 2013
||Oct 31, 2013Ended
Excel macros expert
||...someone who knows how to use Excel pretty well. Basically, I have a spreadsheet full of data.? I would like...like to be able to set up macros that allow me to extract a set of data based on some criteria (such as...need one macro that i could amend depending to what i need to extract from the spreadsheet.
||PHP, Engineering, Software Architecture, Software Testing, MySQL, Anything Goes
||Sep 28, 2009
||Sep 28, 2009Ended
fix excel sheet + macros
||I have a very basic excel spreadsheet that helps me count my inventory in several locations. The various...columns that we edit. Someone helped me build some macro buttons that add and subtract to the various sheet...counts. I just need to add 4-5 sheets to the spreadsheet (add additional locations with the same functionality
||Data Processing, Data Entry, Excel
||May 28, 2012
||May 28, 2012Ended
Finetuning of existing VBA macro and addition of macros to Excel spreadsheet.
||Debugging of an existing macro that copies values to a summary table in another sheet, and filters and...and sorts the table. Creation of two macros that similarly copy values to other sheets. Convert three...three IF formulas to Message Boxes. Create a macro to change a hyperlink based on values in a drop down list
||PHP, Visual Basic, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX
||Apr 15, 2005
||Apr 15, 2005Ended
Excel VBA MACROS
||Microsoft Excel Spreadsheet VBA Macro Autamation
Using a current excel macro to automate and control...control spreadsheet tasks. Design and develop user interfaces to customise spreadsheet models.
I have...be updated, via a form(user interface) using a macro, i can email you the first part and give you the
||Visual Basic, Windows Desktop, Data Processing
||Nov 27, 2006
||Nov 27, 2006Ended
MS Excel Macros
I am looking for a MS excel 2003 macro expert. I have approximately 6 excel files that contain various...information that needs to be put into one very large spreadsheet. All files have a common “product id” that needs...matched. All the information on each product from all excel files need to be matched and put in one line. Perhaps
||Jun 6, 2008
||Jun 6, 2008Ended
Update to Super-Macro Excel Spreadsheet
||I have an Excel Spreadsheet that contains all kinds of macros & coding, that allows new sheets to be...corrected
Builders/Divisions need to be renamed
Macros need to be corrected
There are naming issues...with some of the coding and the functionality of Excel 2007 (the coding actually now points to a cell)
||PHP, Visual Basic, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Mar 7, 2008
||Mar 7, 2008Ended
Excel Macros (2)
||I working with some excel spreadshhets and needs two macros written (and put on a button or in a menu)...menu)
1st Macro will take Vendor spreadsheet of leads and
- globally change values in 2 columns...culumns to max 50 characters
2nd Macro will take different spreadsheet
- rename 4 column headers
||PHP, Engineering, Software Architecture, Software Testing, Website Testing, MySQL, Website Management, Web Hosting
||Feb 19, 2007
||Feb 19, 2007Ended
Excel Formulas converted to Macros
||Currently I have a Spreadsheet, that looks at the data from different tabs, and pulls it to a single...that I need a Macro written, to remove the old values, before refreshing the data.
Macro may not be the...counts down all the way to row 2000
The second spreadsheet ("C G Productivity Tool 26 after run again.xlsx")
||Visual Basic, Excel
||Mar 11, 2013
||Mar 11, 2013Ended
Create some Excel Macros to automate spreadsheet functions
||...involves building excel macros which will automate certain functions in a few excel worksheets that are...the functions macros we would want written would perform include the ability for the macro to clear the...perform the following functions which we would want macros to automate:
We initially cut and paste tab-delimited
||PHP, Software Architecture
||Nov 13, 2013
||Nov 13, 2013Ended
Excel VBA project - macros
||A) Opening the Worksheet Macro
Need a macro to run when the master is open: re-save, editable location...For every day of the month, we have an ImpExp spreadsheet, which we have been working on in the above tasks...data would then be displayed on our webpage and spreadsheet.
(see "other information" for full description)
||PHP, C Programming, XML, Project Management, Engineering, Excel, Powerpoint, C# Programming, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, XSLT
||Apr 18, 2008
||Apr 18, 2008Ended
Convert Excel Macro to work on LibreOffice Calc Spreadsheet
||I have an excel spreadsheet with a built in macros that I use daily. I am looking to have someone take...take this macros and convert it so that it works on the LibreOffice calc. The password to locked sheet
||Linux, Data Processing, Data Entry, Excel
||Jun 16, 2014
||Jun 16, 2014Ended
Excel expert required for macros
||...hours time should only apply.
Attached is a spreadsheet with raw data. The columns contain the units...to remove all duplicates.
For this I need a macro written. If necessary, please include a brief description
||Dec 19, 2008
||Dec 19, 2008Ended