Simple Excel Macros VBA Programming
Required skills: Excel, Visual Basic, XML
Please see attached Excel file for better understanding of what needs to be done.
I need Excel macro(s) to do the following:
1.Delete multiple rows from the table if the value on column E is not the same with the user input (i.e. "T27/01/12")
2.Edit the total Cash and Cheque payments on the bottom of the table accordingly since some rows might have been deleted thus changing the total for both payments
I've also attached the data in XML format just in case you would rather work with XML format as long as it can be converted to Excel with the same format as the Excel data file.
I'm open to suggestions if there is any other ways to do it besides using Excel macro / vba but like I said above that the final result has to be in Excel format.
Please contact me if you need further explanation.
Thank you.
I need Excel macro(s) to do the following:
1.Delete multiple rows from the table if the value on column E is not the same with the user input (i.e. "T27/01/12")
2.Edit the total Cash and Cheque payments on the bottom of the table accordingly since some rows might have been deleted thus changing the total for both payments
I've also attached the data in XML format just in case you would rather work with XML format as long as it can be converted to Excel with the same format as the Excel data file.
I'm open to suggestions if there is any other ways to do it besides using Excel macro / vba but like I said above that the final result has to be in Excel format.
Please contact me if you need further explanation.
Thank you.
Posted In:ExcelVisual BasicXML |
Related projects:
2 x simple Excel Macros
=right style="padding-left: 20px; width: 320px">
Additional files submitted: (Files are only available for logged in users)
MASTER+STOCKSHEET.xlsm
Additional files submitted: (Files are only available for logged in users)
MASTER+STOCKSHEET.xlsm
Need Excel Macros / VBA work
.freelancer.com/img/dadada.gif" alt=" " width="834" height="1"/>
Additional files submitted: (Files are only available for logged in users)
LIST+OF+ALL+EMPLOYEES+AND+THEIR+LOCATION.xls
Presentation1.ppt
all+report.xls
report+july+01-27.xls
Fast Simple Excel Formula
ID-Short
-The Number column indicates the sequence of item and also a permanent number ID assigned to it See in the excel sheet provided, battery part number431436-001 appears twice but maintains number 1 as the code (blue cells)Any new part number
must take the second number in series. E.g look at 431489-001 battery that has taken number 2 and it goes on and on like that to 3. Therefore column D should have a formula that will
be able to assign numbers as indicated.
-The Number column indicates the sequence of item and also a permanent number ID assigned to it See in the excel sheet provided, battery part number431436-001 appears twice but maintains number 1 as the code (blue cells)Any new part number
must take the second number in series. E.g look at 431489-001 battery that has taken number 2 and it goes on and on like that to 3. Therefore column D should have a formula that will
be able to assign numbers as indicated.
Simple Excel VBA project
ome tweaks to my requirements)
This is a very simple project for people with good excel and VBA background. Probably take 15 to less than an hour to complete.
This is the website, on how to use the decision making macro.
http://www.timeatlas.com/5_minute_tips/general/using_excel_in_decisions
i will award this project to whoever can do complete this the fastest with the best price.
Please bid wisely.
This is a very simple project for people with good excel and VBA background. Probably take 15 to less than an hour to complete.
This is the website, on how to use the decision making macro.
http://www.timeatlas.com/5_minute_tips/general/using_excel_in_decisions
i will award this project to whoever can do complete this the fastest with the best price.
Please bid wisely.
Simple excel database programming by wilsontan
I am looking for someone who is good with simple Excel (VBA or macros) or Access programming to create a user interface for a database
Simple Excel Programming
I need a very simple excel program done by today. Please bid only if you have excel programming/macro experience. This will not take more than couple of hours for an experienced excel programmer, so please bid accordingly.
Details will be provided to interested parties.
Thanks.
Details will be provided to interested parties.
Thanks.
Excel Macros Needed - Excel 2007
some data based upon parameters I provide. I'd like those parameters on like Book2 of the macro, so I can change what happens on occasion (very simple stuff - pretty much changing a number to 0 if a field begins with a set of characters)
Next macro will pull a text file from an online source (.txt file, tab delimited) and insert data into the file and then export it to a new tab delimited file, which I'll then upload somewhere.
Next macro will pull a text file from an online source (.txt file, tab delimited) and insert data into the file and then export it to a new tab delimited file, which I'll then upload somewhere.
Two Excel Macros Needed
some data based upon parameters I provide. I'd like those parameters on like Book2 of the macro, so I can change what happens on occasion (very simple stuff - pretty much changing a number to 0 if a field begins with a set of characters)
Next macro will pull a text file from an online source (.txt file, tab delimited) and insert data into the file and then export it to a new tab delimited file, which I'll then upload somewhere.
Next macro will pull a text file from an online source (.txt file, tab delimited) and insert data into the file and then export it to a new tab delimited file, which I'll then upload somewhere.
VBA excel macros
I need someone that is very skilled in writing VBA excel macros.
Excel Macros
rables
The Macros may be written in VBA but the result will be a single .XLS workbook containing the macros which would be triggered by either a hot key or a macro button. Macro code should be fully editable and not protected, obscured or hidden.
Phase One
Functionality to provide a facility as per the Import Marcro(s) description.
Phase Two
Functionality to provide a facility as per the Reporting Marcro(s) description.
The Macros may be written in VBA but the result will be a single .XLS workbook containing the macros which would be triggered by either a hot key or a macro button. Macro code should be fully editable and not protected, obscured or hidden.
Phase One
Functionality to provide a facility as per the Import Marcro(s) description.
Phase Two
Functionality to provide a facility as per the Reporting Marcro(s) description.
Simple Excel Macro / Vba
cro should start from Row 1
- Make the macro read every row of the Input Sheet
- Pls comment the Code WELL
I enclose a sample set of data and ISRC codes however the final version should be capable of dealing with sheets containing up to 65535 rows of data.
I am online for 4 more hours on MSN to answer any questions.
AUD 0.45
USD 0.70
EUR 0.92
NZD 0.40
CAN 0.60
JPY 0.007
- Make the macro read every row of the Input Sheet
- Pls comment the Code WELL
I enclose a sample set of data and ISRC codes however the final version should be capable of dealing with sheets containing up to 65535 rows of data.
I am online for 4 more hours on MSN to answer any questions.
AUD 0.45
USD 0.70
EUR 0.92
NZD 0.40
CAN 0.60
JPY 0.007
Simple Excel/VB Macro
e file containing the following data fields (a) document # (b) GL account (c) Fund # (d) dept # and debit and credit columns. The source system generating the file sometimes "rounds" by a cent throwing a document out of balance. The macro needs to read the data and, when it finds a document out of balance, balance the debits and credits. Written -- detailed -- specs are available with sample data, logic to apply, and sample results.
Convert Excel Macros To Openoffice
Hey there,
I need you to convert a bunch of Excel macros to OpenOffice.
The attached file is the Excel spreadsheet with test-data in it.
There are 4 buttons (attached to macros) inside the spreadsheet.
The OpenOffice version needs to have exactly the same functionality as the Excel version.
Veit
I need you to convert a bunch of Excel macros to OpenOffice.
The attached file is the Excel spreadsheet with test-data in it.
There are 4 buttons (attached to macros) inside the spreadsheet.
The OpenOffice version needs to have exactly the same functionality as the Excel version.
Veit
Simple Excel-sheet as Android app
/2010/12/Skal-jeg-l%C3%A6re-det.xlsx
(Note there si one hidden sheet)
The app should do the exact same calculations as the Excel-sheet and return the same output. The name of the app should be "Skal jeg lære det?" ('æ' is a Danish letter, Alt + 145 = æ)
I also need instructions on how to install it on my HTC Legend..
Please only submit real bids!
(Note there si one hidden sheet)
The app should do the exact same calculations as the Excel-sheet and return the same output. The name of the app should be "Skal jeg lære det?" ('æ' is a Danish letter, Alt + 145 = æ)
I also need instructions on how to install it on my HTC Legend..
Please only submit real bids!
Vendor Price List Excel Macros Needed I - Revised
Revised version of the Vendor Price List Excel Macros I. Same Vendor, they just changed their price list format.
Front End for Excel With VBA
="display: block;width: 540px">
Need front end for easing the process of data entry into an excel using VBA
There will be a few validations built into the front end. Some of the data will have to be picked from droplists, while some will be manually entered.
Need senior VBA expert who can complete the project with minimum guidance.
Please submit your sample work for review .
There will be a few validations built into the front end. Some of the data will have to be picked from droplists, while some will be manually entered.
Need senior VBA expert who can complete the project with minimum guidance.
Please submit your sample work for review .
Create a simple excel macro
Looking for a person to create a simple excel macro to arrange some data, budget is 20$
I will only pay after checking my work, my previous ratings is enough to proof that i am honest in my payments.
I will only pay after checking my work, my previous ratings is enough to proof that i am honest in my payments.
Simple Excel Macro Or Formula
I need an excel formula or macro that will highlight pre-defined keywords or cells in a workbook. These are already sorted out I just need to make sure I can see where the boarders are.
Thanks
Thanks
