Search results

Hi @adityakapoor , Thanks for the input. I had been struggling and waiting for my consultant to get any other possible solution. Your method sure helps to place the transactions in front of each other. Main issue is to spilt the qty as per transactions. I am still not sure how everyone is...

Hello Excel Masters!! I want to calculate profit from buying and selling transactions by using FIFO method and matching the quantity. the formula for profit is as simple as = (sell rate- buy rate) * qty, but the qty needs to extracted from the list of transactions. I have attached a file which...

BTW what is vbCrLf _ ??

Thanks D Coker for the input... I was unable to try it for last two days.... I'll use it and get back to you. Thanks a lot again and sorry for late reply.

Hi Kenneth! Thanks for the reply... I am able to do that part. The current slip which I have shown is just as a sample. Need help in pdf and mail Thanks again for reply.

Dear Excel Experts, Hello! In this thread I have attached employee details file which contains Employee Name, attendance, salary amount and email id. There's a separate sheet of Salary Slip which calculates salary as per the selected Month. I need your help in creating VB macro which would...

Dear All, Please help me with the attached file. I need to print variable data preferably without using micros, as my people are not much used to them. The Data sheet contains the daily plan in details. There are two sections of the production. and every day the number of shift changes (1 or...

Dear Alaap, There are tools for inventory management like Reorder Level , Reorder Quantity etc. The System which you are using looks similar to that, but it seems to consider simple avg. You can use "trend" for forcasting the future demand. Also the quantity produced in pharma generally depends...

As you can see in this file, The list depends on the number of products. If I keep all rows unhidden, the print comes with a very small font size, only for 10% products, the ingredients are more than 30, then is required to print with extra lines. Can you please do it automatically?

Dear Hui, Thanks for the code, there's lot to learn from it. I tried it but still getting problem. In the attached file, if you change the product from PRoduct 2 ( few ingredients) to product 8 ( 50+) , the print out should get adjusted to single A4 page, but its not. Please help.

Yup, the solution works! Thanks However , I still need one more thing.... (1) As mentioned, Page 1 contains the list of ingredients, coz of which the length of the page varies. In any case the page has to be printed on A4, so how is that possible by using this macro ? As I'll move ahead on...

Dear Hui, I'm yet to apply the same in my actual file... , but thanks for saving my life, as usual !!! I'll get back to you once I do that.

Dear Excel Gurus, Thanks for your support every time I need! I'm in need of printing reports as given info in the attached file. - I select the product on sheet 'Main' and depending on that lot of data has to be printed on Pg Nos 1 to 5. - Depending on prod cat, I need to print only those...

Dear Hui/ others , Since I've a question, related to similar problem, I'm continuing here.... I've got fixed ( Fixed no of rows and columns) sheets numbered from 1- 10. depending on the selection of product, I want to print the specific pages like No. 2,3 and 7 for product 1 etc. Can I do it...

Can we do the same without using VBA, and only with Excel?

Merry Christmas & happy new year ( in advance )...

Dear Haseeb, Thanks a lot, it Worked... I couldn't use Sumproduct function earlier, never thought that it can be used like this... Thanks very much.:D

Dear Webmax, You copy the desired output in one column as values. Give formula to adjacent column. If you sort on Column B / C, you'll find the difference in These two columns. Thanks for Helping.

I hope attached file clarifies the doubt. And thanks for taking interest....

Dear Webmax, the initial 2 columns are part of bigger database which needs to sort/ filter etc. the numbering system is required to provide unique numbering to each book. if you sort on Column B / Column C value, the numbering would change. There should not be change in the Book Number.

Thanks Vijay Sharma... But this solution is not valid if I sort data. There should be reference taken from Column A, Which I could not do. Can you still help me out?

Dear All, Attached file contains the data table and desired output. You are requested to help me setting the formula.

Hey! it worked... Thanks a lot.

Dear All, It might b ea basic problem but I'm not getting it solved after using the available solutions on the site. I've three sheets named OffStock, WorkStock and ORData in a single file.. Three different people from different location ( through Google drive) updates these sheets (by copying...

@ Narayank991 : Thanks Dear! The first set of results were correct from point of view and the next columns did work.... @ Faseeh: Thanks to you ! Your solution was also perfect! I combined the solution provided by both of you to resolve the prob! Thanks both of you. I was trying hard to do...