Hello,
As in the example bellow, i want to know if there is a way to auto-fill in sheet "Total" column 2, the same as column 1 (which i put in manually). The only thing that needs to be automatically in the formula is the Sheet.
I have to mention that it would be better if there were no macro's because i don't know how to use them.
Thanks
Hi,
You can use the following formula.....
Formula:
Please Login or Register to view this content.
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
Brilliant !! Thanks a lot !Originally Posted by LokeshKumar
Hi,
You can use the following formula.....
Formula:Please Login or Register to view this content.
If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
Maybe:
A3:Formula:Please Login or Register to view this content.
copied across and down. This might not work with numeric values. In which case:
A3:Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks