I COULD NOT MAKE MY PROBLEM CLEAR TO THE EXPERTS HERE.
BAD LUCK.
JUST BEFORE THIS POST I HAVE ATTACHED MY WORKBOOK.
JUST GO THROUGH IN THE WAY I AM GOING, FOR THE PROBLEM TO BE CLEAR.
PHASE 1.
DAILY, I REPEAT, DAILY I HAVE TO ENTER DATA INTO SEPARATE SHEETS ONLY. SUPPOSE I TAKE A FRESH...
ALSO I AM ENCLOSING THE SUMMARY SHEET WHICH I AM GETTING FOR MY REPORT FROM ALL THE SHEETS.
BUT I WANT MY REPORT FROM ONLY SOME SHEETShttps://files.engineering.com/getfile.aspx?folder=4fdec749-1008-4d75-9a86-a5bf921209ea&file=summary_report.xlsx
TO ALL EXPERTS HERE
I AM ENCLOSING THE VBA CODE WHICH I AM USING FOR GETTING MY REPORTS https://files.engineering.com/getfile.aspx?folder=2401f7b3-77cb-4e8e-b4ae-2444ec880de9&file=VBA_CODE.docx
i think i am unable to clearly specify the problem i am facing.
right now i am using some vba code which is embedded in the commandbutton on the every work sheet.
now i enter some data for some 6 sheets today i.e.,
sheet1 sheet2 sheet3 sheet4 sheet5 sheet6 and so on...
to the experts here i request to go through my code and see what is the result i am getting.
i want to select only some sheets for my report.
click the summary button on my sheet.
https://files.engineering.com/getfile.aspx?folder=b577694c-b12b-44b6-9f85-68e526b07075&file=tkf.xlsm
i think i have not conveyed my problem properly.
daily i have prepare some data as mentioned in the sample sheets.
now the workbook i am working contains at least 3 or 4 days of data consisting of 20 to 25 sheets.
now daily i have get reports from the sheets for the data entered in some...
hi to all experts here
i need to select only some sheets(excel) from the workbook programmatically(vba). the names of the sheets will be varying every day. but i have to select only some of the sheets so that i can get reports from those sheets. please can some one help in this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.