Posts by Raha

Re: Loop find in sheet1 & sheet2

Hi Sir,

Thanks for attending my post and helping me.

"Yes" its working 100% correct how the way i wanted.

Once again thank you very much for helping me.

Regards,
Rahaman.

Re: Loop find in sheet1 & sheet2

Quote from holycow;675967

Hi Rahaman
On Sheet1 you say the value of A is 10, ie the value in C1.
What about the other A values in D13 and F22 ?

Hi Sir,

Sorry for the delay in replying.

Thanks for attending my post.

I mean that in sheet1 value (means Alphabets) should copy and find the same in sheet2 if available then the value of sheet1 cell (A) (amount related to A) should update in sheet2. (A may come number of times but macro should able to perform as this is a new cell)

Eg : if we have "A" 20times in sheet1 the macro should copy each time and need to find in sheet2, if available the value of sheet1 of cell a should be updated in sheet2 with the current value of sheet2 cell.

sheet1 A 10 (Value), Sheet2 A 10(Value) result is 10+10=20
Sheet1 A 20 (Again) if availbale in different cell, Sheet2 A 10(value) =40 result is 20+20=40
like this each cell should copy from the sheet1 and find the same in sheet2, if available then the value of sheet1 should be updated in sheet2 (it may come end number of time) but macro should be able to update each time.

Hope this will help you to understand my request.

Thanks in advance for the help.

Note : I don't have the internet facility to check every day, in weekends i am checking and replying.
Kindly understand me if i reply little late.

Regards,
Rahaman.

Hi Team,

Could you please help me to loop the find in sheet1 & sheet2 and update sheet1 value by finding again in sheet2

1.In the sheet1 macro shoud loop the find "A" & copy the amount related to it and again macro should find the "A" in sheet2 and update the sheet one value in sheet2 if "A" available
2.in the sheet1 macro should loop the copy each cell wherever the data is available (Alphabates) and should search the same in sheet2 and update the value of sheet1 in sheet2 value

I hereby request your good selves to kindly help me on the above scenerio.

Thanks in advance for the help.

Regards,
Rahaman

Re: To one step

Hi Sir,

Thank you very much for attending my post & helping me.

Yes, this is exactly how the way i was wanted.

Once again thank you very much.

Regards,
Rahaman

Hi Team / Small man / holycow.

Could you please advise me how to move steps using macro
One step right
One step left
One step down
One step up

Is possible to set a variables to move steps Left,Right,up & Down.

Thanks in advance for the help.

Regards,
Rahaman

Re: Excel formatting

Hi Sir,

Thanks for educating me,

Sure i will put my directory address as you advised in the message.

Thank you so much for helping me "God bless you".

Regards,
Rahaman

Re: Excel formatting

Hi Sir,

Thanks for attending my post and helping me.

"Yes" its working 100% correctly how exactly i wanted.

Once again thank you very much for attending and helping me.

Thanks a lot.

Regards,
Rahaman.

Hi Team / Small Man,

Could you please help me to open text file in excel and format the file excel sheet as attached in excel.

I have attached herewith the both text and excel files.

I hereby request your goodselves to help me.

Thanks in advance for the help.

Regards,
Rahaman.

Hi Team,

Is it possible to read the pdf data in excel using excel macro.

If yes please help to read pdf file data in excel.

Thanks in advance for the help.

Regards,
Rahaman.
[email protected]

Re: Vba code to loop the copy cells one by one in a column and search in othersheet

Quote from Smallman;669086

Hi Rahaman

Isn't it a vlookup which you are looking for? See attached for workings.

Take care

Smallman

Display More

Hi Sir,

Thanks for attending my post and helping me.

I Was expected not in this way, i just wanted to loop the column and find the check numbers in next page, if the search finds the criteria then copy the next column amount where we want and also the search should find if more than one match found in next sheet.

one more request : if possible please let me know can we open pdf file in excel like how we open text files in excel.

I hereby request your goodselves to kindly help me.

Regards,
Rahaman.
[email protected]

Re: Vba code to loop the copy cells one by one in a column and search in othersheet

Quote from Smallman;668479

Hi Raha

Where is the file? You put your email address above. I don't understand your problem as it is currently described. A file will help your cause no end.

Take care

Smallman

Display More

Hi Sir,

Kindly apology for delay in attaching excel workbook and replying.

Thank you very for attending my post.

[TABLE="width: 460"]

[tr]

[TD="class: xl63, width: 460"]I wanted to loop these check number columns which we have in Column "A" to copy one by one and search in "To be find" (Second sheet) entire sheet and if found then the amount in "B" column in main sheet should copy and paste wherever we need in the same sheet.
[/TD]

[/tr]

[/TABLE]
Thanks in advance for the help.

Regards,
Rahaman
[email protected]

Hi Team,

Could you please help me to loop the copy cells one by one in a column and search the same in the next sheet.
EX: we have many checks in the column A with different numbers and we use to copy these check numbers one by one and search the same in the next sheet, if available than the copied check and related amount should be paste in other required column.

I hereby request you goodselves to kindly help me with the code.

Regards,
Rahaman,
[EMAIL="email address removed[/EMAIL]

Re: Loop through the cells using find option and stop loop at the end to used line

Quote from patel;668010

to find all occurrences

Code

Sub SearchHilight()
Lookfor = "Rahaman"
With ActiveSheet.UsedRange
  Set c = .Find(Lookfor, LookIn:=xlValues)
  If Not c Is Nothing Then
     firstAddress = c.Row
     Do
       Set c = .FindNext(c)
        crow = c.Row
        c.Interior.ColorIndex = 6
     Loop While Not c Is Nothing And c.Row <> firstAddress
  End If
End With
End Sub

Display More

Hi Sir,

Thanks a lot for attending my post and helping me to get loop through the cells.
The given code is working nice & i wish to say that i am very thankful to you.

Once again thank you very much for the help.

Regards,
Rahaman.
[email protected]

Re: Loop through the cells using find option and stop loop at the end to used line

Quote from Smallman;667995

Rahaman

Welcome to Ozgrid

Here is some basic code and a sample workbook to show workings. If you have multiple instances which you want to highlight then indicate this or attach a file to get a closer result.

Take care

Smallman

Code

Option Explicit
Sub FindIt()
    Range("A1:A1000").Find("Rahaman").Interior.Color = vbYellow
End Sub

Display More

Hi Patel,

Thank you very much for attending my post & as you advised i have attached the excel sheet to use as an example.

EX: [TABLE="width: 334"]

[tr]

[TD="class: xl63, width: 334"]In the above available data I want to loop through the cells with find option and where the vba should find the word "Rahaman" and copy the amount in "B" colum and paste it in Range("L1000").end(xlup).offset(1,0).pastespecial like this the vba should find the name in the entire sheet (means in all the used range and copy the "B" amounts respectively and paste it in the different column.

will wait for you reply with eagerly to know the codes.

"I hereby request you goodselves to kindly help
me"[/TD]

[/tr]

[/TABLE]

Regards,
Rahaman
"[email protected]"[/email]

Hi Team,

Could you please help me to loop the ranges with find option.

Ex: dsdafsda ffdsf Rahaman dfsfdsf

I want to find the word "Rahaman" in the above sentence, like wise want to loop the search "Rahaman" in entire activesheet or set of Range "A1:A1000)

I hereby request your goodselves to kindly help me.

Regards,
Rahaman.