Copy Data from activesheet cell to another workbook

**pra_1985** · 04-18-2013, 04:02 AM

Friends,
I am pretty new to vba programming, so seeking help on this.

What im trying to do is, I got a spreadsheet "Request Form" and have some data in different cells and need these data to get updated in another workbook "Consoildate.xls" saved in different location - "C:\myfolder\Consolidate.xls" in summary format.

And when i do the 2nd entry the details should get updated in the next blank row in the similar format.

(Enclosed the sample spreadsheet for your reference)

Much appreciate your response!

**pra_1985** · 04-18-2013, 06:54 AM

I gave a try with the below code but doesnt seem to be working. First i need to check the row 5 of column B is blank, if yes then start copying the data from Request form to consolidate sheet.

Pls refer the attachment in this thread (sample2) bcz its in the same format as required.

Here in the below code
wbThis = "Request form" spreadsheet
strName = activesheet of Request form

Please Login or Register  to view this content.

Copy Data from activesheet cell to another workbook

LinkBack

Thread Tools

Rate This Thread

Display

Copy Data from activesheet cell to another workbook

Re: Copy Data from activesheet cell to another workbook

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions