VBA Excel Macro
||...create a folder tree and copy files according to an excel list of paths.
- a tree structure...and files and the path to this structure.
- an excel sheet listing all the files of the tree structures...instance: c:myfolderpathfile1.rtf
The excel contain several columns. Two are important in this project:
||PHP, Perl, Java, Visual Basic, Excel
||May 17, 2009
||May 17, 2009Ended
VBA, Macro, Excel
||...spreadsheets with different data - you will be fine.
a) Open the file:
- BSS...Do the following steps:
- add another sheet
- copy values only to new sheet
- add auto filter on line...line 9
- filter for nonblank’s in column A and copy the results to new added sheet
- column P line
||Visual Basic, Excel
||Mar 16, 2009
||Mar 16, 2009Ended
Excel vba to transform excel data - columns to rows
||...attached Excel file
A vba module / macro is required that will transform the data from columns to rows...rows. The source data is in sheet 1 'Input'.
The data needs to be transformed to sheet 2 'Transform'...any number of columns.
Sheet 3 has an example.
see attached Excel file
||Windows Desktop, Engineering, Software Architecture, Software Testing
||Aug 9, 2012
||Aug 9, 2012Ended
Excel VBA macro
||The VBA macro will first detect when there is a new 5 minute interval in a TIME column and will then...then add up data from 3 columns to 3 new columns within each of the 5 minutes interval.
||PHP, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, Visual Basic for Apps
||Jan 19, 2010
||Jan 19, 2010Ended
308241 Simple Excel Macro / VBA
||...need a simple XLS macro. I am estimating that it will be 20-30 lines long. For a VBA / Microsoft programmer...it within 3 hours.
We have a spreadsheet of data (attached). Each row is one record.
There are...however we only have the data for 25 of them. The macro needs to calculate the data in the last two colums
||PHP, Visual Basic, Anything Goes
||Mar 30, 2009
||Mar 30, 2009Ended
||...a lot of data and some columns are calcs (a1:cc12000).
Need someone to create a few VBA macros/forms...macros/forms that will sort this data and output into a few variations into? new worksheet in same file as well...well as different excel file.
Addendum (8/10/08) -
Specifically on sheet data! for any row where
||PHP, Engineering, Software Architecture, Software Testing, MySQL
||Aug 8, 2008
||Aug 8, 2008Ended
Private project or contest #1696786
||PHP, Excel, Software Architecture, Visual Basic for Apps
||Jun 14, 2012
||Jun 14, 2012Ended
Simple VBA macro for excel
||...spreadsheets of data that I need to combine. The column headers in Cols A-H don't change, but other columns come...(different order of headers). So I need a macro to sort columns I-BZ using the column headers in row 1 -...arranged alphbetically (excluding emplty columns).
Working in Excel 2007. Budget is US$10.
||Visual Basic, Excel
||Nov 1, 2013
||Nov 1, 2013Ended
Excel macro VBA assistance
||...critical data that is extracted from the software package. At present I extract selected data in Excel format...manipulate to make that data far more useful to my clients.
The extracted Excel raw data is consistent in...of the data contained in the raw Excel file. I have started to work on the Excel macros (Excel 2003) bu...
||Data Processing, Excel
||Nov 1, 2010
||Nov 1, 2010Ended
Make a macro for Excel and Access, with regex to retrieve data, and paste it into new columns
||The task is to create a VBA macro for Access (2007), and a similar one for Excel (2007), to help me retrieve...certain type of data from certain fields.
Here is my situation:
I have an Excel table with a...2006**<br>17:40-**19:10** Uhr
**1) Create four new columns (for example at the end of the table) and call
||Script Install, Shell Script
||Aug 17, 2012
||Aug 17, 2012Ended
416339 Excel VBA Macro.
Please see attached sample Excel file.
We need an Excel VBA macro script that will align a new SKU...not match the old list.
The list is several columns with about 3300 items arranged in numerically ascending...quantity and B is item SKU number. The rows of columns A and B do not align with the existing file because
||Excel, Anything Goes
||May 24, 2010
||May 24, 2010Ended
Excel VBA Print macro
||Project overview: Create/modify customer Excel VBA code to control print job for a single worksheet....prompts user for number of months (columns) of data to print, then print macro will configure print job to print...followed by the correct number of months (columns) of data. Print dialog form and code from similar project
||PHP, Visual Basic, Engineering, Software Architecture, Software Testing, MySQL
||Jan 9, 2002
||Jan 9, 2002Ended
VBA Macro Creation for Automation of an Excel Report Population
||...export reports in Excel Format, so we are trying to create a work around by exporting data files and then...building an Excel VBA Macro to automate the process of compiling and formatting the data within a report...with varying sizes of data sets.
Prior to implementing our database, we had an excel report that was used
||Visual Basic, Data Processing, Excel, Templates,
||Jun 20, 2013
||Jun 20, 2013Ended
VBA macro for Excel
||The goal of this marco is to copy some value from one sheet to another sheet with some conditions and...from Sheet 'Import' in the cells with Row >=7 and Columns between Q column and Column for which the value...Cell(C,i) from Arrivage Sheet.
The macro will check the code BD116 Cell (A;2) from Sheet
||May 14, 2012
||May 14, 2012Ended
Excel Macro/VBA needed
||...is – create an Excel macro/VBA that will:
1. Automatically create charts from excel data
2. Automatically...Automatically copy the created charts to MS Powerpoint and/or Word.
The Excel Macro/VBA should be relative...and types of data.
This project is based on 2 Excel files - the "project" ma...
||Excel, Powerpoint, Word, Visual Basic for Apps
||Mar 16, 2013
||Mar 16, 2013Ended
VBA macro for Excel
||VBA Macro on Excel
I will describe what the macro will do through the Excel Macro_VBA_project.xls...in the Zip file.
On the column C, we have TIME data. Here is how to ‘read’ those numbers. The first...mean 14h56 and 39 seconds.
The Macro will ‘create’ 12 new columns, from AZ to BK with the folling order
||Visual Basic, Microsoft
||Jan 21, 2010
||Jan 21, 2010Ended
Simple Excel time tracking - VBA macro
||I have created a simple Excel form (attached) for users to enter information weekly re the number of...who will copy/move their sheets into a central workbook. I need Freelancer to develop a macro for the...wokbook that pulls data from each of these copied/moved sheets into a single sheet in Excel that is in database
||Visual Basic, Excel
||Jun 4, 2014
||Jun 4, 2014Ended
249268 Excel - Macro - VBA
||...the spreadsheet to get the data I need. What I would like is a macro or VBA script which can do it for...for me.
All columns in the extract to be deleted except for A,B,F,N,O,X
All...should be moved to the WIP worksheet.
Now the data is in each of the three worksheets it needs to be
||Visual Basic, Anything Goes
||Sep 6, 2008
||Sep 6, 2008Ended
VBA Macro - Word/Excel
||...the format we require - the correct number of columns, etc.
<http://footballstats.metro.co.uk/metro/...We would like to be able to open up a file say (Excel ?) - select the leagues required from a list and...and then click on a generate button that would copy the files to a Word file that is saved - we then use
||Copywriting, Engineering, Technical Writing, Software Architecture, Software Testing, Academic Writing, Article Rewriting
||Mar 4, 2011
||Mar 4, 2011Ended
VBA Macro to Excel(repost)
||We need an Excel-macro that is simple and we would like to be able to modify the macro with more features...was trying to do the macro, did not deliver in time and was sending us a lot of macro to test. We do not...time to do the testing.
We just want a simple macro with a menu.
It's important that you use a
||Script Install, Excel, Powerpoint, Software Architecture, Microsoft Access, Word, Microsoft Exchange, Shell Script
||Mar 11, 2011
||Mar 11, 2011Ended