Ken,
I do believe Zathras is the closest to my desired goal.[thumbsup2] I had used Autofilter a year ago on a different project but somehow forgot how to set it up.[surprise]
I did try the MS Query, which I think would also work, but I'm having trouble with setting it up. I'm being told that...
Okay guys I am going to review your answers and determine which one fits the bill for my needs. I need to keep costs down for my client, so naturally the easiest course will be my choice. I'll let you know in a few days what works.:->
To answer Ken Wright's question:
1. "Are they all on a...
I have used excel to create a legal document matrix. The columns are labeled to separate and identify dates, attorneys, abbreviated motion language and complete motion language. The rows will be identified with a tab number to correspond to how/where the document is filed.
Due to the number of...
I tried your formulas, and the last column enters the date and time as a decimal.
I am not at all familiar with macros. Isn't there an easier solution? All I need is when an entry is made in column A, a non-changing date and time stamp occurs in column B. A solution can't be that hard?
Could you please explain this formula alittle bit? Would I be adding another formula to this one based upon how I format the Date/Time? I need for the date and time to be stamped into the cell and not change once the event occurs. (I think I didn't clarify that in my earlier post)
For my workgroup I have created a log in excel. Column A is the "Person/Role", Column B is the "Date & Time" and Column C is for "Comments & Notations."
I would like for everytime a person enters their name in the cell under Column A, that the current date and time...
Yes, I have attempted to rename normal.dot, without success.
PC clean-up? I think I have cleaned what I can from this computer. The user is not very considerate and absolutely has NO CLUE when it comes to operating a computer the proper way. He downloads programs he's not supposed to, emails all...
I have determined that "WF" means "word fill" on the task bar of the Word program. Every feature in its pull down menu generates compile error, so my guess is this entire module is bad. Even the help menu doesn't come up for this one.
This particular computer does have...
I am receiving the following error message when opening Word 2000 (OS WNT 4):
MS Visual Basic: compile error in hidden module-WFMain.
Have not been able to find completely satisfactory answer based upon other responses to similar error messages, just not this particular module:
1. Do not have...
i am new to vb and i am writing a small code to get records from access database based on a selection criteria and then create an excel sheet using that data.
the sequence is as follows:
-Starting the VB application goes to main selection screen
-Select a particular record and create excel...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.