formula for 3months expense for 15nos

June 16, 2011 at 00:11:22
Specs: Windows 7
I have totaly 4sheets. Summary sheet, And other three sheets are our empolye monthly expenses report.
What i need? in summary sheet i having our employe names, according to their name the expenses amount should be calculated from those three sheets, so i need a formula to gendrate automaticaly in summary sheet based on their names.

Kindly help me.

See More: formula for 3months expense for 15nos

Report •

June 16, 2011 at 15:48:30
I'm not sure what you are trying to do since the contents of your post doesn't seem to have anything to do with your subject line.

I'll try this:

You can use sheet names in formulas.

If you have a sheet named Bob Smith, you can use:

='Bob Smith'!A1 or =SUM('Bob Smith'!A1:A6)

If that's not what you are looking for you'll need to provide some more details.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question