Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate excel in a way similar to mail merge
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate excel in a way similar to mail merge
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 "Alberto Pinto" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
How do I do an e-mail mail merge using an Excel spreadsheet? | Excel Worksheet Functions | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
How do I merge similar data across different excel worksheets? | Excel Discussion (Misc queries) | |||
Macro Similar to Mail Merge help/question | Excel Programming |