Search results

hi Dear Professors; i have a list of data and want to make it a list that when i choose a alphabet like "a" from a dropdown list , in another list i can see all of datas that start with that alphabet . i want it with excel formulas and if this is impossible i want this in vb. example : i have...

hi professors ; is there any way to put a picture or use an icon for sheet names? and how?

Hi Proffessors ; I want to remove the Insert New worksheet of an excel file.that nobody cant insert new sheet to my file and every body that have a password can insert page(s) to this file and when open this file there is not a key in right side botoom of the excel file; thanks all you ...

dear sgmpatnaik hi 1-yes 2-yes 3-yes my range have not any problem . your file works perfectly.but just i want is : after change to pdf , the pdf file save on desktop of every user , not in temp folder. thanks...

hi bobhc beacuse i have 5 tables with different ranges in it. and i want to make pdf just one of them (such as range(A2:F7)

hi dear i know that.(how to find a file path) but in my office , when another person open this file and use this program , will see the error message. my question is : How can i write the address for everyone desktop (in system 64 bit) to save this file on it.... thanks

hello dear sgmpatnaik i test that but that is not work in my system . i changed from "C:Temp" to "C:usersSPDesktop" but when play it , excel show bellow error : run-time error '76': path not found what should i do? thanks a lot my dear friend . . .

hi and thanks sgmpatnaik my english isnt very good. i am working in a office and want to use this here. we have not here Case system and use WYSE. your work is very good but problem is the path of save file that works in every user . such as save in desktop of us . i am thankfull of you if...

thanks dear imgonna $ bobhc , but i want a module for it . i want to make pdf from a range in a sheet(e.g : sheet1/range(a2:h15)) Thanks

Hi Dear Professors, I Have a workbook with several sheets that calculates Personal Salary and I should give a worksheet(sheet1)to Accounting Unit In My Office. How Can Make A button in a sheet that when i press it , a convertor module , makes my need.

hi; I Have a file that there is a column(column B)in a sheet with name :(A) include the name of some visitors that can changes every month . there are some sheets with visitors name . how can write a program or a formula to change sheets name with the names in column B in Sheet (name:A) ? at...

thanks.that is true. now if my sentence comes from a formula example: concatenate("my car is blue"&$A$2) and i want to colorize word blue or bold it , what should we do?

with any possible application such as conditional formatting, Vb or... like: my car is blue. "blue" be written in blue color. "is" be written with underline. "car" be written in bold.

thanks

hello dont you help me?

hello again thanks for your help i like a pharmacode barcode, please can ypu help me? thanks and thanks

hello ; every format that is possible for you, i want write a name and a number (like john101) in a cell and excel gives me a barcode picture for use under my reports for my boss. really really thank you and i pray for you to find and recieve every things that want from GOD. wait for you.

hi dear Hui; i am a beginner in excel and should do this work(barcode in excel) please please please ; can you send me an excel file that works? thanks and thanks and thanks so much .

In the name of GOD Hello , sir . Chandoo I am from Iran & know English a little . but I use your site and guides a lot with translators programs. thank you so so much for your helps. Now. I need help , I am working in a company(sales unit-operational researches),and I make many excel...