Macro to copy cell from one excel file to another

[chan999941]

I like to copy two different cells from a one excel file to another blank Excel file located in the same folder. When this copy it should write/paste the data into the next available blank cell. I need to use this macto for more than 200 files.


Your earliest reply will be greatly appreciated

regards

chan

 

[Glory]

Next available blank cell... like, fill A1:A65536, then start back up at B1 again?

 

[chan999941]

Hi

Thanks for your prompt reply. The source excel lile have two inmportant informations i.e: Student ID and Last session. i need to copy Student ID ( Cells N5:P5) into one column ( Column A) in the destination excel file and the info on Last session (O7) to column B in the destination excel file.
This is some student information. I have more than 500 files life this. So practically in the destination file these infomation should be copied in Column A1:A500 and B1: B500.

These two excel files are in one single folder.

Hope this will help you.

 

[chan999941]

Macro to Syn excel, word with outlook

Hi

Previously you have helped me to sort some excel related issues. Could you please hlpe me to sort the below given problem.

I have a excel data sheet with data on Column B ( email address), Coulmn C ( date). I wanted to send outlook email ( the draft email can be a word document to those addresses on the date given in the excel data sheet.
both the Word and excel data sheets are saved in "C/ email msg" folder.

Thanks in advance

 

[Glory]

Re: Macro to Syn excel, word with outlook

I'm sorry, I don't know anything about working with Outlook through Excel. There are a lot of really knowledgeable people on the site, though. If you stick around, you'll find that there are busy times when questions like this will receive extremely prompt and detailed replies. Weekday mornings, often as not.

I hope that you'll keep posting your questions on the forum. When I was working with Excel every day, I found this place to be a lifesaving resource.