Simple Excel Macro
Required skills: Accounting, BPO, Data Processing, Excel, Finance
Hi All, this project is simple i need an excel macro (not copy paste work) to convert the "input sheet" to the "ouput sheet" in the attached file.. simple work and you will understand it when you go through the attached file.. I need it asap and i want the macro to fill all the data from 1990 January to 2011 December.. Please bid if you are highly capable of this and new freelancers are well come.
Many more projects to be followed..
If you have done any previous work please provide reference in PM so i can make the best decision.
Thanks
Many more projects to be followed..
If you have done any previous work please provide reference in PM so i can make the best decision.
Thanks
Posted In: |
Related projects:
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/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.
Excel Macro Needed To Create Matched Pairs Sample
atches.
- When finding a match, if Age variable does not exist for the firm or if there are more than one match based on closeness in age then just randomly pick a firm from the matches.
- Not all firms in Group A will have a match and that is fine.
This should be fairly simple to make for a programmer. I have attached the Excel file with Group A and Group B.
I need the actual macro code so that I can tweak it in case I change my mind about size %.
- When finding a match, if Age variable does not exist for the firm or if there are more than one match based on closeness in age then just randomly pick a firm from the matches.
- Not all firms in Group A will have a match and that is fine.
This should be fairly simple to make for a programmer. I have attached the Excel file with Group A and Group B.
I need the actual macro code so that I can tweak it in case I change my mind about size %.
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 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
Excel Macro Work
I have excel macro work to be done.
1. Comparing two columns in 2 different files and insert values in the final file.
2. Comparing 2 columns and place in 3rd file according to above or below price ranges.
This work can be done using macros or automated software.
1. Comparing two columns in 2 different files and insert values in the final file.
2. Comparing 2 columns and place in 3rd file according to above or below price ranges.
This work can be done using macros or automated software.
Xlsx Macro
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
and so on
i need a column next to it adding line no's
1 1
1 2
1 3
1 4
1 5
1 6
1 7
1 8
1 9
1 10
2 1
2 2
2 3
2 4
2 5
2 6
3 1
3 2
3 3
3 4
3 5
3 6
3 7
3 8
and so forth
Searching And Compiling Excel Macro
I require an excel macro to extract a data set (700 entries) from another data set (1500) entries and compile a list of the extracted data in another work sheet.
Vba / Excel Macro Debug
I have a VBA / Excel Macro in about 100 lines, using "Application.OnTime TimeValue("00:00:55")" to auto run the macro every day at 00.55, but it will not kill the previous task so the 2nd day this macro will crate 2 results, i need someone to fix this for me.
Excel Macro Project
I need someone to fix a simple excel macro.
Simple Excel Macro
I need an excel macro that will check all cells in a column against all cells in another column. For example cell A1 will be checked against all cells in the B column (B1, B2, B3 etc.) and if any of the cells in column B matches A1 a text will be displayed in column C1. If not (it goes through all the cells in column B another text will be displayed in C1) and it will move on to cell A2 and so on.
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
Very Simple Excel Macro
"
2) cleans the "'" at the extremity of all the addresses
3) moves the multiple addresses of single lines into single address in single lines, removing the separator ";"
4) removes duplicates, adding the number of occurrencies for each address on the right (column B) of each remained unique address
5) sort the lines by column B
I think that an EXAMPLE worth more than 1000 words so please see the attached example.
Payment via escrow
2) cleans the "'" at the extremity of all the addresses
3) moves the multiple addresses of single lines into single address in single lines, removing the separator ";"
4) removes duplicates, adding the number of occurrencies for each address on the right (column B) of each remained unique address
5) sort the lines by column B
I think that an EXAMPLE worth more than 1000 words so please see the attached example.
Payment via escrow
Excel Macro For A Simple Prob.
5 m253 gsgs
a456 12000 eh6u sss3a m253 gsgg
a456 15000 eh6u hhh25 m253 gsgs
38000
a456 12000 eh6u sss3a g850 gsgg
a456 15000 eh6u sss3a g850 gssas
27000
a456 11000 fz9z hhh25 shyw gsdd
d522 24000 fz9z hhh25 shyw asdd
35000
Finally, the totals must appear in bold font and light yellow cell background.
Thanks in advance
a456 12000 eh6u sss3a m253 gsgg
a456 15000 eh6u hhh25 m253 gsgs
38000
a456 12000 eh6u sss3a g850 gsgg
a456 15000 eh6u sss3a g850 gssas
27000
a456 11000 fz9z hhh25 shyw gsdd
d522 24000 fz9z hhh25 shyw asdd
35000
Finally, the totals must appear in bold font and light yellow cell background.
Thanks in advance
Excel - Macro To Delete Duplicate Lines From Worksheets
Hello,
I need someone to write a macro that will compare two excel worksheets within a workbook and delete (an entire row) duplicate information based on matching data in one column.
I will provide more information if required.
I need someone to write a macro that will compare two excel worksheets within a workbook and delete (an entire row) duplicate information based on matching data in one column.
I will provide more information if required.
Excel Macro Expert
s macro needs to read information from multiple fields of an excel sheet. There are 2 very simple tasks that I need your help with, and if you're an expert, this should be a very quick and easy job. We're looking for paying a minimum bid, and if you do well, there will be other macros that we will need created. In your application, let me know what kind of macros that you've created before in excel and how macros work.
Thanks
Thanks
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
Excel Macro Expert
Hello,
I am looking for excel macro expert...to do just a very small "one hour job"
I am looking for excel macro expert...to do just a very small "one hour job"
Excel Macro To Filter List Of Domains
ation: none;color:#68778E" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'">allthemen.com
allthemen.com
The domains column will contain up to 20,000 domains, and the filer column up to 1,000
Thank you!
allthemen.com
The domains column will contain up to 20,000 domains, and the filer column up to 1,000
Thank you!
Excel Macro/script Needed - Apple
matically name the text file "my choice"-116.txt
In the macro, it may ask what the name should be. So if I Oakland the files should be created as Oakland-116.txt, Oakland-389.txt, etc.
The macro must work on MS excel Mac 2004 on a Apple iMac
Attached is a sample file to work with.
Needs to be completed by Tuesday Morning. Quick project for anyone who knows what they are doing. Budget $ 40
Future jobs if result is very good.
In the macro, it may ask what the name should be. So if I Oakland the files should be created as Oakland-116.txt, Oakland-389.txt, etc.
The macro must work on MS excel Mac 2004 on a Apple iMac
Attached is a sample file to work with.
Needs to be completed by Tuesday Morning. Quick project for anyone who knows what they are doing. Budget $ 40
Future jobs if result is very good.
