Recent content by ComDawg

Thanks For your input. I will just continue using my hot key or maybe make a toolbar. The main reason I was looking to do this was more so that I may type a persons name in a blank document and have it automatically come up with there info in a fax cover. I listed it as new fax hoping to get a...

I am trying to create a macro that will allow me to do the following: From a blank document type "New Fax" press the enter key and have my Fax Cover Template open up. I have the macro recorded and it works fine if I use the keyboard shortcut. Here is the code I have so far: Sub New_Fax() ' '...

THANK YOU!!!!!!!!!!!!!! I changed the vlookup as suggested and it worked perfectly!!!!!!!!. I am still going to try the index/match formula to see if I can get it to work. I will keep you posted. I really appreciate your help on this! John

I can not get the index/match function to work. I can get vlookup to work though. =INDEX(Sheet1!a2:b4664,Match(a55,a2:a2758,1),2)<-- I can not get this to work. The a55 after match is the cell number of the number im trying to match to the sheet1 index...

Skip, This is from my first post. "If it finds a match then copy the text from column b of worksheet1 to column c of worksheet2" I have 2 work sheets heres an example. Worksheet1 Number Name 1234 joe 4321 john 7890 mary Worksheet2 Number Bldg Name Port Des...

Thanks for the search tips! So you think a formula would be better to consolidate to worksheets?

Is there any where I can get some Samples of the Match Function? Is it in the Help?

Skip, Only reason I have for not using them is my own lack of knowledge of them. I thought this little project would not be difficult for me, But 5 hours into it and I'm beat. I would love to here any suggestions on this. John

I am trying to build a script that can match the number in column a of worksheet1 to the same number in column a of worksheet2 where ever it may be in that column. If it finds a match then copy the text from column b of worksheet1 to column c of worksheet2. Here is what I have so far: Sub...

Not sure if this is what your looking for but, If you edit your site properties there is a tab for "Customer". you should have customer "0" listed. select customer "0" and edit your range.

I have a cisco 1720 that is my DHCP server asa well as the internet gateway. Everything works well except using ftp from command prompt. I can FTP from my browser and transfer files fine. If I go to a command prompt and do ftp I can connect but no transfer. I always get timed out. Any help would...

See I post a question a year ago and nobody steps up to assist. So I answer my own question to see if anyone really reads this forum and it gets all kinds of attention. To bad you all couldn't jump on the actual question! Do you just watch to see if you can try and make fun? I see you all have...

What Rel is the Opt11 running? My 25.30 required a patch be loaded.

I have this posted in the merdian 1 forum as well, but have yet to get a reply. So here it goes: I have a Norstar 6.1 with PRI and MCDN key codes installed. I have 4 digit calling between the to. The problem is with forwarding. If the call is answered on the norstar (by Receptionist) and then...

I am having a similar problem with my setup as well. I am very interested in hearing about your 5.0 to M1 setup. As I am trying to connect an M1 to a Norstar 6.1. Any information would be appreciated. Thanks in advance!