Search results for query: *

hello, I am having an issue adding a client to a SBS2003 system... ---system has 45 users, this particular user is "out back" in a warehouse...he has a line pulled about 25 feet to a cisco e1000 router that another user has...that other user is plugged in fine. I posted in dns for the simple...

What is the easiest way to move a users email, contacts, etc to a new user?

if I have 20 excel sheets with 'MR' in the title....is there a way to mass change every title to 'MRS'

I've tried to read through as many threads as possible to find my situation but my eyes have now become blurry and I'm starting a new thread. I'm a user no tech expertise here! The guy who set up my VPN is long gone: I have a VPN set up from Home to Work. I am able to print at home from my...

As I mentioned before, it is very easy to print by simply pressing the print icon but say I have someone who may not be as experienced. I can direct them to print the document with a nice big link. My curiosity is what's driving this. Sometimes you get that feeling like "there has to be a way"...

If you click, it will print the document. Thanks for the posts so far.

Hi All, I was wondering if there is a way to direct a hyperlink to print a document. I know you can always go up and click on the print icon but my curiosity is getting the better of me and I was wondering if there is a solution. Thanks, Steph

Thanks to everyone.... Dan's solution works just fine. I only wanted the worksheet name because I needed it for another formula reference (dynamic). Since I'm not so advanced on the VB I wanted a forumula without all the other junk (path etc). I appreciate the option!! You guys rock! By the...

Hello All, I'm trying to display my worksheet name in cell A1. I checked the FAQs the but the one listed on this subject isnt working for me. Any help? I would like to use a formula vs VBA. Thanks, Steph

If your data is in Columns A & B then the formula should look something like this in Column C: =VLOOKUP(A1:A500,Name,1) But first you should name your range in Column B. Highlight the selection in Column B then click on Insert-Name-Define. Type a Name you will remember, then OK. Use the...

Those both sound good. I am trying to plug this into a larger code: Option Explicit Sub test() Dim FindSheetName As String Dim HowManyFound As Integer FindSheetName = InputBox("Enter Customer Name", "Worksheet Selection") If UniqueSheetName(FindSheetName, HowManyFound)...

Can anyone tell me how to activate the first worksheet that meets Inputbox criteria. For example, in a workbook of 50 sheets, I have a five worksheets that beging with the letters "ST" Even though I may have 5 worksheets that being with "ST", I want VB to activate the first...

GOT IT!! Here is the full Code: Sub test() Dim FindSheetName As String Dim HowManyFound As Integer FindSheetName = InputBox("Enter Customer Name", "Worksheet Selection") If UniqueSheetName(FindSheetName, HowManyFound) Then MsgBox "SheetName is " +...

Thank you both!! The code works well to idenify the name of the worksheet. I was able to add in the [InputBox]. Any ideas on how to then activate the desired worksheet? :) Steph

Back in Nov there was a code posted for finding and activating a worksheet in Excel. thread707-697281 My question is, can variables be used to find the closest match for a worksheet name. In other words, I don't want users to have to type in the exact name of the worksheet but, instead the...

Hi All, I have a workbook with approx 40 worksheet all structured in the same manner. I want to find a keyword in the worksheets and copy/paste that row into a new master worksheet. Any suggestions will be helpful. Thanks, Stephanie

Hello All, My Excel workbook has approximately 40 worksheet all structured in the same manner. I am looking for a way to select all worksheet to find a certain keyword in a column/row. If found I would like to copy each of those rows and paste into one new master worksheet. Any suggestion is...

Thank you Michael. I'll give that a try.

Does anyone have a program that will produce a transaction detail for an A/R customer's account. Right now I can only view on the inquiry screen. I'd like to be able to print out the same information.