Posts by mbluethunder700

Re: Password Protect Sheets From Viewing

Dear ALL

Really, i don't know why this attitude regarding to my thread ??!! . I think that i was more polite to say "Sorry" on this thread and on public for my behavior . But i don't think that it is not good to take this thread as an example to every one try asking help .

Honestly , It is a first time to me to write or talk in a forum like this , I am really surprised when i saw the people who are working hardly on this forum and i am really respect there effort to keep the rules applied on this forum.

First time when i saw this forum and saw the extremely lot of number of threads in it . I admired with it and i was sure that i will find the one how could help me . And the help which i needed not doing a thing to me but find a someone but me on the right road .

And Honestly , Roy is the one who help me a lot and but me on the right way . and i am really really appreciate his effort to do that and i was very interactive when he replies to me . Thanks a lot Roy , Thanks Really.

Finally after this experience with this forum I see that any one who need or want to do any thread on it. He should know that there are amazing staff working on it and they will not let any one to break the rules of this forum.

Thanks a lot for this forum and its staff and a hope to be interactive with his members . And Sorry for my English

Thanks Again
Best Regards

Re: Match 2 Columns to 2 Seperate Worksheet Columns

and pic 33 & 44

Re: Match 2 Columns to 2 Seperate Worksheet Columns

This is the pic 11 & 22

Re: Match 2 Columns to 2 Seperate Worksheet Columns

Dear All
I don't know if you will see this problem in your PCs or not . Where i faced a serious problem in my MS Excel which it is the shape of the formula
As you know i solved the last problem which i had before about the spaces . But today when i opened my files . I discovered that all the formula changed to

=IF(ISERROR(VLOOKUP(D2;Sheet1!A:B;2;0));"";VLOOKUP(D2;Sheet1!A:B;2;0))

and as you see that the (,) changed to (;) and i don't know how did this happened ? and this in all my files

and in any new file i didn't able to put the formula which it is give me error

I tried to attached the picture of what happened with me but as you know that the max attached is 45k

So i attached the file which have the problem but i doubt that you will see the problem where i opened it on my PC and it worked fine

I uninstall my MS office from my laptop any reinstall again . But the problem still exist

So could you help me to understand the problem

BR

Re: Cannot Remove Trailing Spaces

xlite , Your final solution is genius

ByTheCringe2 , thanks alot for guide me to the correct way

I am really appreciate your Helping me : D

Best Regards

Re: Cannot Remove Trailing Spaces

Dear All

I am really appreciated your effort to help me . it is now working great

But until now how you ( ByTheCringe2 ) could discover this problem ? in my test file

Anyway Thanks again

Best Regards

Re: Cannot Remove Trailing Spaces

Any one can help urgently

Re: Cannot Remove Trailing Spaces

Sorry

The attached file

Dear All

I have an excel file with two sheets . One containing the updated prices with its code ( Sheet1) and the other containing the old prices with the same codes (sheet2). Now after several trials to copy the new prices from sheet 1 to sheet 2 with check if the code is same . ( I couldn't )

So how to get rid of the 20 spaces from Sheet1 column A.

Best Regards

Re: Match 2 Columns to 2 Seperate Worksheet Columns

I was like you now , I spent the last three days to find the solution . But i asked how could you are find the different between the two cells ( in sheet 1 and sheet 2 )

I think that it must be a solution to solve this problem

anyway i appreciate your effort to share me this problem and i think that i will put the prices manually

Thanks a lot
Best Regards

Re: Match 2 Columns to 2 Seperate Worksheet Columns

This option not working with me where there is no any ( " " ) in sheet 1 so how could the replace command will find it

Re: Match 2 Columns to 2 Seperate Worksheet Columns

How can i now the no. of characters in the sheet where i have another 5 files like this text file contains this problem . So how can i now it

Re: Match 2 Columns to 2 Seperate Worksheet Columns

Dear Sir

How could i change or match the format for the two sheets

BR

Re: Match 2 Columns to 2 Seperate Worksheet Columns

Sorry

the attached file

Re: Match 2 Columns to 2 Seperate Worksheet Columns

Dear Sir

According to the history of this thread . I used the formula
=IF(ISERROR(VLOOKUP(D2,Sheet1!B$2:D$20000,3,0)),"",VLOOKUP(D2,Sheet1!B$2:D$20000,3,0)) Which it is illustrated by (ByTheCringe2) and i adapted it to match with all kind of my files

But in the attached file . I faced that it is not working So Could any one help to match the code in column D in sheet2 with sheet1 and put the price of sheet1 in the yellow col. in sheet2

BR

Re: Password Protect Sheets From Viewing

sorry

Re: Password Protect Sheets From Viewing

Dear Roy

I am so sorry for asking help in this object . I am i nwork to and i check my post every 15 mins

i will try to find a way to solve it and if you have a new please tell me

BR

Re: Password Protect Sheets From Viewing

--------------------------------------------

Re: Sharing One Workbook With Multiusers

Dear Rich

I think that a thousand of Excel program users especially who has a employees and they work on the same file try to make this option .

If i couldn't let the excel file with sharing option so i think there is anther option to let the file used by multiusers

may be share the file between the users but let one user only can edit in his sheet and after he finish the other user can open it ( Like that )

BR

Re: Password Protect Sheets From Viewing

Dear Roy

From the history of this thread . You could see that the only one how continue with me is you . So i need to now if you will continue or not . Because i waiting for reply each time i post new thing so ...

Best Regards