Copy and Paste problem

[Prasoonj]

Hi All,

I need your help for simplifying my work.

Could you please teach or prepare a macro for my below request.

I use to work on excel the same work . i need to copy a value form cell reference C4 & E7 (Default) in sheet1, sheet2, sheet3.....sheetn and paste in the separate Consolidated workbook.

I'm doing this by manually everyday. copying C4 and pasting in Consolidated workbook, Then copying E7 and pasting in the consolidated workbook from sheet 1, then sheet 2, so on ..

So please assist on this .since I'm a learner must need your advice to learn about excel.

I have attached a sample how I'm pasting the value in consolidated workbook

Thanks in advance...

Prasoon

 

[Luke M]

Before looking at your specific workbook, have you checked out the merge/consolidation codes written here:
http://www.rondebruin.nl/win/section3.htm

Ron's done a wonderful job of compiling many different examples.

 

[aparvez007]

Thanks Luke, very helpful link.


Regards,
pAvi

 

[trustmeasfrnd]

hi,
i am new to excel and vba macro.
i wanted to create a text file copying everything on sheet1 and then saving it to that text file.
even it would be better if i can rename that text file.
is it possible.

regards,
Abhisekh

 

[Luke M]

hi,
i am new to excel and vba macro.
i wanted to create a text file copying everything on sheet1 and then saving it to that text file.
even it would be better if i can rename that text file.
is it possible.

regards,
Abhisekh

Welcome Abhisekh,
You would do better to start a new thread for your question, rather than posting here in a thread that has already been resolved.

Thanks!