Automate excel in a way similar to mail merge

[Alberto Pinto]

How can I populate differente worksheets from a list of data? (ie, in a
similar way to mail merge but only with Excel)

Thanks in advance

 

[Guest]

No built in capability. You can write a macro to loop through your data,
update cells on another sheet, possibly print that sheet, repeat:

Dim rng as Range
With Worksheets("Sheet2")
Set rng = .Range(.Cells(1,1),.Cells(1,1).End(xldown))
End with
for each cell in rng
worksheets("Form1").Range("B9").Value = cell.Value
worksheets("Form1").Printout
Next


This further assumes that the form1 page is configured to print out as you
want it.


Regards,
Tom Ogilvy