PDA

View Full Version : Copy/paste specific data to specific target cells



ryadb
02-29-2008, 03:29 AM
Hello all,
I am totally new to vba coding but i however need to find a solution to this.
I usually generate around 400 files using the same template (TARGET.xls) which I populate using data from another excel file (SOURCE.xls). It's quite a routine which coonsumes far too much time.
I would like to get some help with this please.

Bob Phillips
02-29-2008, 04:24 AM
You really shouldn't use merged cells, they are a nasty abomination. I have coded around it, but I would fully expect my code to fail at some point because the users don't setup the merge cells consistently.

Bob Phillips
02-29-2008, 04:25 AM
Sorry, I couldn't post the workbook, you can download it from http://cjoint.com/?cDmzJUMrn0