Unable to run below excel file

Request you to please open LEVELLED PLAN sheet.
Then click to Plan Equipment tab you will get error.please solved this issue.

Sir Please help

i dont knwo

The first reason your code errors is because it expects a value to come from a cell with a vlookup formula in your sheet.

Specifically:

Please Login or Register  to view this content.

X in this case is 9 - so if you look at cell(9, 20) (=T9), you'll see an #N/A result.
This #N/A result is because you're doing a vlookup with the value in cell I9 (Std BFM-18W) in your hidden cell range of C6:D8.
However, C6/C7 or C8 does not contain Std BFM-18W, so the result is an error instead of a number.

As you could see from the data validation dropdown in I9, the only values allowed in I9 are actually 'Boiler BFB-12W', 'Boiler BFB-18W', 'Boiler BFS-11W'.
If you pick one of those, your code still errors however, as one of the values in your 'CopyAndPaste' routine comes from cell B6 in your sheet "PLAN vs Actual". And that cell is empty.

Please Login or Register  to view this content.

If we fill m with a valid number, it will go through.

Over all, your code is a big mess. A lot of undefined variables and you seem to have no clue what you're doing.
I expect that you won't be able to get this to work unless someone here feels really generous and will rewrite your whole code, talking with you on what's needed. As you don't even seem to understand what you need, I'm out