Search results

Thanks,

Dear Experts, I want to convert 02-09-2013 format of date in MM-YY form, so that in pivot table I can categorised in monthly summary data, Basiclay entry is with time stamp and require result in monthly summary, Please suggest if any other method as well if there for the same,

I am having two different pivot tables on two work sheets, Is there any method to combine both these tables / charts for comparison purpose?

I AM HAVING A MASTER FILE ON A SERVER WHICH IS BEING DAILY UPDATED, I AM HAVING COPY OF THE SAME AT MY END WHICH IS CUSTMISE A SPER MY NEED. HOW CAN I SYNCRONISE BOTH FILES SO THAT ANY NEW ENTRY UPDTAED IN MASTER FILE AT SERVER SHALL BE UPDTATED TO MY CUSTMISED FILE.

Another problem with data validation is user can cancel the error message and sheet will allow user to keep it as blank,

Dear Nazmul Problem is it mandatory numeric figure and hence zero is not allowed,

Sttruglling with the problem, not able to execute the VBA programme

HI THIS IS JIGAR MEHTA FROM INDIA GUJARAT, USING EXCEL SINCE LAST 8 YRS WORKING IN A PHARMA ENGINEERING SECTOR,

http://www.fileconvoy.com/dfl.php?id=gc47ba273c25370559992682729f9c1066342a4f73 Column H are mandatory fields

I does not meen that way, I just wanted to indicate that conditional formating is not catering the required logic for the same, I regreat,

Not useful for my purpose

Please elobrate the same,

Thanks

How to create mandatory fileds in an excel sheet?

http://www.fileconvoy.com/dfl.php?id=gc47ba273c25370559992682729f9c1066342a4f73

Dear Hui, Sample file uploaded

Dear All, I have an excell file which contatins daily datas on regular basis. File contains date in the first column. I want to avoid back dated entry and hence want to lock the cells at least with a margin of two day to entry in the same and if require asks for approval password. E.g. if...