Dear Sir,
Please find attached file, Need VB codes of following;
1. Add Line, when user click it, its information will be pasted in following table at S.NO. 1 and user can add up to 10 lines like this, rest of formulas I have already applied.
2. Delete Line, if user want to delete any line, he just need to press delete line button and line values will be blank.
3. Save Excel File, this button should save the file in xls format without vb coding.
4. Export pdf, this button should save the file in pdf with file name as style name cell and should save in the folder where original file exist.
5. import file, from this button, user can import the pre save excel file to the same file if he want to amend the calculation basis.
6. New, once user press this, the table should go blank as well as style name.
Summary (ROW 35)
Column Quality (B36): it is consolidate value of cell range E24:F33
Column Tex (C36): it is consolidate value of cell range H24:H33
Column Color (E36): it is consolidate value of cell range I24:I33
Column Total Meter (F36): this is tricky where lots of calculation required, it will concatenate the value from "Qulity, Tex, Color" and its sum from table above
I know its lots of work, I just need best help which anyone can offer please, I will be so thankful.
Regards
Ateeb Ali
Please find attached file, Need VB codes of following;
1. Add Line, when user click it, its information will be pasted in following table at S.NO. 1 and user can add up to 10 lines like this, rest of formulas I have already applied.
2. Delete Line, if user want to delete any line, he just need to press delete line button and line values will be blank.
3. Save Excel File, this button should save the file in xls format without vb coding.
4. Export pdf, this button should save the file in pdf with file name as style name cell and should save in the folder where original file exist.
5. import file, from this button, user can import the pre save excel file to the same file if he want to amend the calculation basis.
6. New, once user press this, the table should go blank as well as style name.
Summary (ROW 35)
Column Quality (B36): it is consolidate value of cell range E24:F33
Column Tex (C36): it is consolidate value of cell range H24:H33
Column Color (E36): it is consolidate value of cell range I24:I33
Column Total Meter (F36): this is tricky where lots of calculation required, it will concatenate the value from "Qulity, Tex, Color" and its sum from table above
I know its lots of work, I just need best help which anyone can offer please, I will be so thankful.
Regards
Ateeb Ali