I suppose it all depends on how you are saving the file? Are you using the FILE, SAVE AS option from the top left on the screen? Also note that if you are saving a spreadsheet that you have worked on received via email, it is saving it to a temp file, therefore you have to go FILE, SAVE AS and...
Hi , not sure if this will help, but if you have only postal codes and city names , you may try selecting column A,and selecting "DATA" ,"TEXT TO COLUMNS","Delimited" etc.
This splits without formulas.
Can one actualy print the logs? I need something for my helpdesk whereby we receive calls from customers.So you would have one company with x amount of users. As an installation is done I would want to add the customer to the database, the calls comming in are for re-installations,change email...
When finally completed can I put in a order for a copy?Jan is round the corner.Paul how did you start learning VBA/EXCEL I have a stack of books and programming diploma VB6 but excel makes my brain tick, guess diplomas don't come with no guarantees? Just high price tags...thanx
Hi Karin247
Your failures mmust be a range. To do an exact match using vlookup(love it)...=vlookup(type3,(the range of type,partpartnumber),2(being the column you want to return,your matched column would be 1,part would be 2 etc),false)
false denotes a exact match.......very NB!!!!!!!!!.
Just...
Hi we have a ordering tool that we install for customers, the problem is that on numerous occassions after installing the program the outlook express password gets cleared and no one can tell us how to check what it is before we do the installation so as to avoid this embarrassment.......
Hi I am at my wits end being flooded with bounced email.........Problem,,my company has a ordering tool which is installed, database and all on the customers c or local drive. The updates are sent through via Email in exe or zipped exe files, needles to say this causes a lot of problems with...
If you don't want to get to technical, you can use the BCC option , which is a blank carbon copy option. You would just enter all the address' in the BCC field and the email would show as comming from you but not show to who all it was sent as TO does.
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.