Search results

Hi Kaushik, Thank your for your efforts given and the workbook you have shared is working good. As I was little busy, I could not reply to you on time. Really Thank you and I need to check it out with my friend, as I don't know about VB. And again I will inform it to you. Regards, Aarthi

Hi, I am sorry to tell you it here, the input sheet contains the batch no at which we want to save. I am using the report sheet because if the data stored sheet contains numerous data (i.e., more than 100 batch nos),it can be viewed easily in the report sheet, the report sheet can generate...

Hi, I have seen it but the command button should save the data given in the "Input" Sheet, and the data should be saved as it is in the "Data Saved" Sheet. The "Report" Sheet to be used to generate the data as per the batch no - (Cell) given in the allocated cell. I hope that I have given...

Hi, Can you please post it on rapid share or skydrive? I hope the format you have created will be easily accessible. Kindly post it and I will come back to you Thanks & Regards Aarthi

Hi, Thanks for working for me, but I could not download the file you have uploaded. Now I am leaving and I can not see your message until tomorrow. So, I will see your message and reply to you by tomorrow morning Thanks & Regards Aarthi

The new data of the new batch no should be stored in the same sheet not in the new sheet. And the earlier batch data should not be deleted Regards Aarthi

Hi, I hope the workbook attached in the link will help you to understand better https://rapidshare.com/files/1469054206/Data.xlsx Regards Aarthi

Sir, I first Thank you all for providing me the solutions. My database will be as shown below Purchase - Batch No : PurSep01 Soap Brand Nos Price Life Buoy 1000 10 Hamam 1500 12 Dove 850 20 Lux 1100 15...

Hi Faseeh, I am waiting for your reply. Please post it soon. I can see it tomorrow only. So, I will see the post tomorrow. In the mean time, if you have any suggestions from your side, please post it. Because that report generation is more important at present. With Thanks and Regards, Aarthi

Hi, I really post it just to get an idea from you all. But you completed it. Really Thanks for your help Regards, Aarthi

Hi Faseeh, Kindly find this link https://rapidshare.com/files/4156496437/Model_Sheet.xlsx This worksheet is not completed. But this is the model Aarthi

Dear All, I thank you for your help to my last question and to my this new one. I am having a database which have 60 columns. I am preparing a new display sheet which display all these 60 contents by searching with unique value either this or that (Example - Outward Document No or Product...

Really Thank you so much

Hi every one. While converting Deci meter to square feet, it will display the results in decimals those to be rounded to the nearest of 0.25, 0.50, 0.75 , the whole number. Thanks in Advance

It is working. But my formula contains like this as per your example. A B C 1 04:30 05:20 = text(sum(A1,B1),"h:mm") 2 00:00 00:00 = text(sum(A2,B2),"h:mm")

Actually I sum up the time taken on certain activities based on certain conditions. So, the resultant area does not accept the above options.

Yes, It is working. But I don't know that why it is not working my own project creation. Really Thanks for your help.

I tried it, but not working.

Suppose the value in the cell A1 is 0:00, it should be hidden. If the value is 15:30, it should not be hidden.

Select the Table and then click the FORMAT AS TABLE button in STYLES under HOME tab. Then, choose the type you want.

How to Hide Null (0) Time Value in the cells?