Search:

Macro's were the suggestion. See the above posts.

The excel bible. You can find it at amazon.com

Well I used "Paid" as an example. I have 12 worksheets and have to reference a column in each. I know I can just sum 12 countif's but I figured there may be a shortcut but oh well. Thanks

I'm sure I could probably find the answer to the question on my own but really don't have the time to search. Thinking maybe someone on here already knows. Is it possible to reference an entire...

This is true, but awfully troublesome and time consuming. Those small businesses mostly don't have the time or money for a project of this level. I assume if they did, Excel wouldn't have been their...

I myself am working on a workbook that has 36 tabs. There is no way, that I am aware of, to cascade the tabs so that all are visible. If I opened my work book and needed to add to a sheet named...

Actually I think the best way for you to go is to create a user form with buttons for all of your tabs. Name the buttons the same name as your tabs. For each click for each btn the code would be:...

Are you using Excel? If so the best way to go is to create a custom function using the visual basic editor. You will need skills in VB language to do this. I can try and help you as much as possible...

I'm linking one workbook to another using a COUNTIF function. For some reason its only successful when the source book is open. The destination book links and updates. But when I close the source...