I need somehelp with this problem! I tried everthing that I knew but I wasn't able to get the result I wanted.
Okay, Here is what I need.
I have a excel file with 10 different work sheets.
WsheetA, WsheetB, WsheetC... thru WsheetJ This is a master file so, I can not change or do anything with this file! So, other option I have is to copy the data and paste it in to the other file. I have been doing this for long time and I have created some Pvtable that is based on this data.
I created a macro to copy and paste data but some time my macro does not work the reason being that some time in master file there is only 8 worksheets
WsheetA, WsheetB, WsheetC... thru WsheetH In this situation my macro wouldn't work becasue it is created for 10 Wsheets and if there is lessthen 10 Wsheets it won't work.
One more thing I want to make it clear is that there are other Work sheets in master file but I only wants to copy those Work Sheets which starts with Wsheets.
Please tell me what do I need to do to get correct result.
Thanks for your help!