Profit and loss sheet

dayaptl,

how far have go gotten with your attempts at creating the macro? Where is your code?

We're happy to answer specific questions about coding or Excel issue, but this reads as if you want a free solution to your business requirement without giving too much of a spec.

This forum does not provide a free coding service. You'll have to put in some effort yourself, or post in the commercial services forum for a paid solution.

I've never seen a Profit & Loss sheet looking like that,nor needed code to produce one

A better explanation would help,I can't see why you would need code

this is not commercial application .

Well, if it's just for fun, then there's no rush, is there?

Each month I arrange all rows from sheet 1 manually as per sheet 2 and calculate transactions.

Since your columns in Sheet2 are not labelled, I don't quite see the connection. Would you care to elaborate as to what the logic is?

e.g. H6

(' Here stock quantity does not match, so leave blank)

Care to explain what that means? Don't suppose everybody is familiar with your data and the underlying logic. Explain your requirements based on the values to be evaluated. Define the rules to be applied. Don't assume that people will understand your issue by just looking at a lump of data.