Search results for query: *

Conclusion: HorseGoose gave me what I needed to know - the syntax for how to put a variable into a formula. As a non-programmer, I use VBA for excel to automate certain steps. I am not using excel to replace access or another database. A simplified example of the program that creates a...

re: Skip. As "useless as paper in a file drawer"? That is EXACTLY what it is and all it needs to be and by having separate pages it maintains the integrity of the file drawer.

Thank you to HorseGoose for the idea.

This is my first time on this board and frankly you people are arrogant as all get out. I know my data and I know what I am trying to do and I know it is not necessary or USEFUL to consolidate it. Geoff - the data STARTS separate...COMBINING it is the extra step. I just want to a piece of...

Skip, Sorry, but putting data in a table is not the problem. That is how the data arrives, putting it in a table is far more work and generates far more risks and issues than leaving it on a single, uncorrupted page. There are many applications where it would be useful to activate a worksheet...

My file has many, many worksheets that are named according to a convention (date - e.g. 1010 is oct. 10th). So, I have say 31 pages in October 1001, 1002, etc. I have two related questions: first, my macro needs to be able to activate one of these worksheets based upon a variable that is...