Hi Friends, I appreciate your efforts in the forum.
I have attached a workbook, I need a macro for the attached file based
on sheet(Sample1) and it should be like sheet (Sample2).
I have mentioned all details in comments.
COMPOUND |
SALT | these three fields have to split from sheet ("sample1) well
field
BATCH |
RESULT INDEX - it has to be generate through procedure
EXP NUM - _n1 has to remove from this and date format like (mm/dd/yyyy)
Avg. % inhib |
SD | these have to get from sheet (sample1)
N |
and other remaining fields has to generate through procedure.
the macro need to meet all conditons provided in comments and shoud
create a new sheet with all the data (like sample2 sheet).
I have an idea on (the date part Avg-% inhib) but for splitting the
wells field is very tricky for me.
requirement : when click on command button the new sheet has to insert
with data as sheet (sample2).
I am very sorry if you are not understand my english, I quite poor at English.
Please kinldy help me this regard.
Thanks&Regards
Ramesh, Katta
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribeHi Friends,
I appreciate your efforts in the forum.
I have attached a workbook, I need a macro for the attached file based on
sheet(Sample1) and it should be like sheet (Sample2).
I have mentioned all details in comments.
COMPOUND |
SALT | these three fields have to split from sheet ("sample1) well field
BATCH |
RESULT INDEX - it has to be generate through procedure
EXP NUM - _n1 has to remove from this and date format like (mm/dd/yyyy)
Avg. % inhib |
SD | these have to get from sheet (sample1)
N |
and other remaining fields has to generate through procedure.
the macro need to meet all conditons provided in comments and shoud create a
new sheet with all the data (like sample2 sheet).
I have an idea on (the date part Avg-% inhib) but for splitting the wells field
is very tricky for me.
Please kinldy help me this regard.
Thanks&Regards
Ramesh, Katta
package1.xls
Description: MS-Excel spreadsheet
