# Posts by Raha

• ## Loop find in sheet1 & sheet2

Re: Loop find in sheet1 &amp; 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.

• ## Loop find in sheet1 & sheet2

Re: Loop find in sheet1 &amp; 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.

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.

• ## Loop find in sheet1 & sheet2

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

• ## To one step

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

• ## To one step

Hi Team / Small man / holycow.

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

• ## Excel formatting

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

• ## Excel formatting

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.

• ## Excel formatting

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.

• ## Read pdf data in excel

Hi Team,

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

Thanks in advance for the help.

Regards,
Rahaman.
[email protected]

• ## Vba code to loop the copy cells one by one in a column and search in othersheet

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

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]

• ## Vba code to loop the copy cells one by one in a column and search in othersheet

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

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]

• ## Vba code to loop the copy cells one by one in a column and search in othersheet

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,

• ## Loop through the cells using find option and stop loop at the end to used line

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

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]

• ## Loop through the cells using find option and stop loop at the end to used line

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

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
&amp;amp;quot;[email protected]&amp;amp;quot;[/email]

Hi Team,