Actually i am working with an Excel File which has so many sheets under one file, and this file is of various fabrics that we used in our production.
And every time new fabric is enter or consume i have to update the sheet. And it is getting very tough on me, as their are so many fabrics and items in the sheet, and it is becomingalmost impossible to find any wrong data that i entered in the sheet.
I want to create an exact duplicate copy of the entire MS Excel sheet, and want to get highlight of the data that i put in main sheet .
I mean i want to know for e.g. what entries i put on 15 may 2011, so if i have to check the mistake i just need to go to that duplicate sheet , and to see what i entered their.
I hope i have clariy my issue.
Please give me an urgent reply.
I will be extreamly thankful to you.
in your sheet there must be one column for date of entry and other columns. date column need not be the first column may be last column also. But you must enter the date when you enter the data.
in such a case you can autofilter the data according to date column being any particular date and you get only those data which you have entered on that particular date will be visible. you can manipulate with that filtered data and once it is over you can remove the autofilter and you get the full data visible
read excel help against "autofilter"
there is no need for a duplicate sheet other wise for the 50 sheet you have to have another fifty sheets as dup0licates.