Need a sample WIP Expense file....

[balaji3081]

Hi Guys, Not sure if this is the right forum, Do let me know will re post.


I am looking for a Sample WIP Expense file, showing Expenses by current month actuals , CY YTD Actuals , MTD Actuals VS MTD last year, and CY YTD vs LY YTD.


Rgeards,
Bala

 

[bobhc]

Good day balaji3081

If you search the templates in Excel I am sure you will find one that fits the bill or can be tweaked to get you your result.

 

[balaji3081]

Hi,

Did check it out...but nothing which suits my requirement, Let em know if anybody has a file to share.

Rgerads,
Bala

 

[SirJB7]

Hi, balaji3081!
What about following b(ut)ob(ut)hc's suggestion? Search anywhere, use Google, find the more suitable model for you, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you.
Regards!

 

[Faseeh]

balaji,

Can you give a rough layout so that it could be tried.

 

[balaji3081]

Hi Faseeh,

Thanks for the reply - Attached is a sample file.

In the Sheet 1 tab -

Is what I need to have automated -

- the catch under the PL_category the expenses heads keep increasing ...
- I need it to include all the unique expense heads available from the data tab - 'col. D'.
- Also, Hide rows where there are no numbers.

 

[Faseeh]

Hi Balaji,

please see attached workout. Hope it helps.

 

[balaji3081]

Hey Faseeh, Thanks for the file, is there any way to populate the expense categories depending on the what is there in the data, And also hide the row if the value totals up to zero in the row.

 

[Faseeh]

Baalaji, You are welcome, cant pick up your point, are you looking to automatically fill column A that was previously already filled.