Search results

visit you private message.

I told what I changed in the original code. I opened my worksheet which contain my work, and I went to "Developer/ View code. than I pasted the code like this : Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$G$8" Then Exit Sub Application.ScreenUpdating = False...

I changed the cells here (blue color) but the auto filter didn't work. I need help hhh Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$A$3" Then Exit Sub Application.ScreenUpdating = False Application.EnableEvents = False On Error Resume Next With...

How did you created it ? I tried to change the cells in the "View Code" but it didn't work for me I guess I didn't know how to do it ! hhh

it worked well, thanks. I didn't add a hyperlinks because my hyperlinks open files on my pc. I added a hyperlinks in this new example .

Your "search cell" worked for me but when I add the hyperlink to the file's name, the hyperlink doesn't appear on the result. I uploaded another example with the hyperlink

Sorry I thought I uploaded an example already ! I mean whan I write a in search cell then all names with a as : a aa bac a a show in the result. Thank you for helping me .

thanks for the reply, but it didn't work for me ! I want to add 2 things. 1- If If there were many files have a similar name, I want them to be show all. 2- My file's name have a "hyperlink", I want to be able use the "hyperlink" in the result

Hello all. I have a list of files' names, and I want to create a cell to show me if there is the files's names which I'm looking for or not. and the result will shows on another cells ! Is it possible ?

Hello, As you see in the worksheet I have a table contain from 2 half's : 1st half and 2nd half which is the duplicate of the 1st half. I need a userform to create Debit or Credit table and when I choose the " Section" in the userform it appear on the table too. The total is the total of total...

Thanks Ill try it

Hello I have 2 tables and I want to auto copy from table 1 to table 2 which, but when the table 1 was empy I dont want any thing apear in table 2 too, nothing such (0).

Any one can give a help ?

Hello. I have a workbook I put an example here, it contain many table and which table has a date. I want to work on a copy and my friends work to on other copies ( which one and his copy) and in the end we consolidate our work in one workbook but by date arrangement, Could we do that ? (using...

Yes that's what I wanted , thank you.

Can any one help me ?

Ill wait you

Thanks for the answer, I guess now I made it clear what I want in the workseet, I want to fill the left fields and the data saved in the right table.

Hello. I need a macro or userform to save on a table any data I write after click on "Validate" like in this worksheet. Thank you for advance.

Userform or just a simple macro I don't mind.

Hello I need a userform to fill and print a cheque like in this worksheet. I want to tape a the table and in the same time the fields fills, convert the amounts in frensh letter please and ended by DAN. But Im not sure if the fields are in the right positions, so if you can make them movable...

Thank you :)

thanks for the answer, but I guess you didn't understand me, I want very name appear just once and doesn't matter how much it writes, example : I have a a a b b c c a e and I want to get this a, b, c, e

Hello, I need a formula and nor Macro to skip the double characters and show the characters only once as in this table ,and thanks

Thank you very much :). the truth is this not my worksheet (its for my enterprise) but it look similar, Ill try to apply those macro on my worksheet, may we write in somewhere private ? Anyway thank you for the help :).