| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Printing Single Worksheet Multiple Times with Different Data
What I am trying to do is use a single worksheet pulling data from a
different worksheet to print multiple copies of the original worksheet. Similar to a mail Merge, but basically to copy a daily number and date from the second sheet and use it as a variable on the first worksheet. If this sounds complicated, I apoligize, but considered as a mail merge would be the closest I could think of! If I need to, I suppose I could copy the Original Worksheet 30 times, and put a cell reference into each, just seems like a lot of work---Kinda lazy ya know! Thanksl! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing Single Worksheet Multiple Times with Different Data
It is doable through VBA but from where will you pull the data from sheet2 and
where will it be placed on each copy of sheet1 printed out? Gord Dibben MS Excel MVP On Sun, 14 Oct 2007 14:51:01 -0700, Jr. wrote: What I am trying to do is use a single worksheet pulling data from a different worksheet to print multiple copies of the original worksheet. Similar to a mail Merge, but basically to copy a daily number and date from the second sheet and use it as a variable on the first worksheet. If this sounds complicated, I apoligize, but considered as a mail merge would be the closest I could think of! If I need to, I suppose I could copy the Original Worksheet 30 times, and put a cell reference into each, just seems like a lot of work---Kinda lazy ya know! Thanksl! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing Single Worksheet Multiple Times with Different Data
Several cell references....
Specifically (just a few I can adjust as needed), B10:B40 TO SHEET2 C4 C10:C40 TO SHEET2 E9 If you can get me this far, I think I can figure out the rest....been about 10 years since I did ANY programming.... "Gord Dibben" wrote: It is doable through VBA but from where will you pull the data from sheet2 and where will it be placed on each copy of sheet1 printed out? Gord Dibben MS Excel MVP On Sun, 14 Oct 2007 14:51:01 -0700, Jr. wrote: What I am trying to do is use a single worksheet pulling data from a different worksheet to print multiple copies of the original worksheet. Similar to a mail Merge, but basically to copy a daily number and date from the second sheet and use it as a variable on the first worksheet. If this sounds complicated, I apoligize, but considered as a mail merge would be the closest I could think of! If I need to, I suppose I could copy the Original Worksheet 30 times, and put a cell reference into each, just seems like a lot of work---Kinda lazy ya know! Thanksl! |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing Single Worksheet Multiple Times with Different Data
Sorry, I don't understand.
You said you would pull data from a "different worksheet" and place it on the single sheet, changing the data with each copy printed. What is the name of the "different worksheet" and do you want B10 & C10 from it placed into sheet1 first copy printed then B11 & C11 placed into second copy printed and B12 & C12 into third etc.? What is the name of the sheet to print 30 times? BTW...........B10:B40 is 31 cells, not 30 I will not be able to get back to you today but hang in and watch for one of the "real" VBA experts to jump in with code. Gord On Sun, 14 Oct 2007 16:38:01 -0700, Jr. wrote: Several cell references.... Specifically (just a few I can adjust as needed), B10:B40 TO SHEET2 C4 C10:C40 TO SHEET2 E9 If you can get me this far, I think I can figure out the rest....been about 10 years since I did ANY programming.... "Gord Dibben" wrote: It is doable through VBA but from where will you pull the data from sheet2 and where will it be placed on each copy of sheet1 printed out? Gord Dibben MS Excel MVP On Sun, 14 Oct 2007 14:51:01 -0700, Jr. wrote: What I am trying to do is use a single worksheet pulling data from a different worksheet to print multiple copies of the original worksheet. Similar to a mail Merge, but basically to copy a daily number and date from the second sheet and use it as a variable on the first worksheet. If this sounds complicated, I apoligize, but considered as a mail merge would be the closest I could think of! If I need to, I suppose I could copy the Original Worksheet 30 times, and put a cell reference into each, just seems like a lot of work---Kinda lazy ya know! Thanksl! |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing Single Worksheet Multiple Times with Different Data
The name of the worksheet is "Month" (pulled from) and the name of the other
is "planner" (pulled to) and printed sheet is "planner" And it will go Month B10, to Planner C4 Month C10, to Planner E9 Month D10, to Planner C9 Month E10, to Planner H9 Month (f10+g10+h10), to Planner F10 Month I10, to Planner G10 and finally going from the 10 row, to the 40 row. each changing on each print. A lot to ask, but If I had the starting point, I could probably make it work. And once again, THANKS A LOT! :) (and yes I know, I can't count!!!!!) "Gord Dibben" wrote: Sorry, I don't understand. You said you would pull data from a "different worksheet" and place it on the single sheet, changing the data with each copy printed. What is the name of the "different worksheet" and do you want B10 & C10 from it placed into sheet1 first copy printed then B11 & C11 placed into second copy printed and B12 & C12 into third etc.? What is the name of the sheet to print 30 times? BTW...........B10:B40 is 31 cells, not 30 I will not be able to get back to you today but hang in and watch for one of the "real" VBA experts to jump in with code. Gord On Sun, 14 Oct 2007 16:38:01 -0700, Jr. wrote: Several cell references.... Specifically (just a few I can adjust as needed), B10:B40 TO SHEET2 C4 C10:C40 TO SHEET2 E9 If you can get me this far, I think I can figure out the rest....been about 10 years since I did ANY programming.... "Gord Dibben" wrote: It is doable through VBA but from where will you pull the data from sheet2 and where will it be placed on each copy of sheet1 printed out? Gord Dibben MS Excel MVP On Sun, 14 Oct 2007 14:51:01 -0700, Jr. wrote: What I am trying to do is use a single worksheet pulling data from a different worksheet to print multiple copies of the original worksheet. Similar to a mail Merge, but basically to copy a daily number and date from the second sheet and use it as a variable on the first worksheet. If this sounds complicated, I apoligize, but considered as a mail merge would be the closest I could think of! If I need to, I suppose I could copy the Original Worksheet 30 times, and put a cell reference into each, just seems like a lot of work---Kinda lazy ya know! Thanksl! |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing Single Worksheet Multiple Times with Different Data
I said it was doable but looking at your requirements I'm not so sure<g
The part I left out was that my VBA skills are not up to something this complex. I'm more of a ToolsOptions person. Try posting over in the programming group where you could get a better chance of help. Gord On Sun, 14 Oct 2007 17:39:00 -0700, Jr. wrote: The name of the worksheet is "Month" (pulled from) and the name of the other is "planner" (pulled to) and printed sheet is "planner" And it will go Month B10, to Planner C4 Month C10, to Planner E9 Month D10, to Planner C9 Month E10, to Planner H9 Month (f10+g10+h10), to Planner F10 Month I10, to Planner G10 and finally going from the 10 row, to the 40 row. each changing on each print. A lot to ask, but If I had the starting point, I could probably make it work. And once again, THANKS A LOT! :) (and yes I know, I can't count!!!!!) "Gord Dibben" wrote: Sorry, I don't understand. You said you would pull data from a "different worksheet" and place it on the single sheet, changing the data with each copy printed. What is the name of the "different worksheet" and do you want B10 & C10 from it placed into sheet1 first copy printed then B11 & C11 placed into second copy printed and B12 & C12 into third etc.? What is the name of the sheet to print 30 times? BTW...........B10:B40 is 31 cells, not 30 I will not be able to get back to you today but hang in and watch for one of the "real" VBA experts to jump in with code. Gord On Sun, 14 Oct 2007 16:38:01 -0700, Jr. wrote: Several cell references.... Specifically (just a few I can adjust as needed), B10:B40 TO SHEET2 C4 C10:C40 TO SHEET2 E9 If you can get me this far, I think I can figure out the rest....been about 10 years since I did ANY programming.... "Gord Dibben" wrote: It is doable through VBA but from where will you pull the data from sheet2 and where will it be placed on each copy of sheet1 printed out? Gord Dibben MS Excel MVP On Sun, 14 Oct 2007 14:51:01 -0700, Jr. wrote: What I am trying to do is use a single worksheet pulling data from a different worksheet to print multiple copies of the original worksheet. Similar to a mail Merge, but basically to copy a daily number and date from the second sheet and use it as a variable on the first worksheet. If this sounds complicated, I apoligize, but considered as a mail merge would be the closest I could think of! If I need to, I suppose I could copy the Original Worksheet 30 times, and put a cell reference into each, just seems like a lot of work---Kinda lazy ya know! Thanksl! |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Printing Single Worksheet Multiple Times with Different Data
Thank you anyway....suggestions for good place to read up on vb for excel?
"Gord Dibben" wrote: I said it was doable but looking at your requirements I'm not so sure<g The part I left out was that my VBA skills are not up to something this complex. I'm more of a ToolsOptions person. Try posting over in the programming group where you could get a better chance of help. Gord On Sun, 14 Oct 2007 17:39:00 -0700, Jr. wrote: The name of the worksheet is "Month" (pulled from) and the name of the other is "planner" (pulled to) and printed sheet is "planner" And it will go Month B10, to Planner C4 Month C10, to Planner E9 Month D10, to Planner C9 Month E10, to Planner H9 Month (f10+g10+h10), to Planner F10 Month I10, to Planner G10 and finally going from the 10 row, to the 40 row. each changing on each print. A lot to ask, but If I had the starting point, I could probably make it work. And once again, THANKS A LOT! :) (and yes I know, I can't count!!!!!) "Gord Dibben" wrote: Sorry, I don't understand. You said you would pull data from a "different worksheet" and place it on the single sheet, changing the data with each copy printed. What is the name of the "different worksheet" and do you want B10 & C10 from it placed into sheet1 first copy printed then B11 & C11 placed into second copy printed and B12 & C12 into third etc.? What is the name of the sheet to print 30 times? BTW...........B10:B40 is 31 cells, not 30 I will not be able to get back to you today but hang in and watch for one of the "real" VBA experts to jump in with code. Gord On Sun, 14 Oct 2007 16:38:01 -0700, Jr. wrote: Several cell references.... Specifically (just a few I can adjust as needed), B10:B40 TO SHEET2 C4 C10:C40 TO SHEET2 E9 If you can get me this far, I think I can figure out the rest....been about 10 years since I did ANY programming.... "Gord Dibben" wrote: It is doable through VBA but from where will you pull the data from sheet2 and where will it be placed on each copy of sheet1 printed out? Gord Dibben MS Excel MVP On Sun, 14 Oct 2007 14:51:01 -0700, Jr. wrote: What I am trying to do is use a single worksheet pulling data from a different worksheet to print multiple copies of the original worksheet. Similar to a mail Merge, but basically to copy a daily number and date from the second sheet and use it as a variable on the first worksheet. If this sounds complicated, I apoligize, but considered as a mail merge would be the closest I could think of! If I need to, I suppose I could copy the Original Worksheet 30 times, and put a cell reference into each, just seems like a lot of work---Kinda lazy ya know! Thanksl! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
| Inserting a single row to separate data multiple times | Excel Discussion (Misc queries) | |||
| Using SUBSTITUTE multiple times on single cell of data | Excel Discussion (Misc queries) | |||
| Printing multiple worksheet areas in a single page | Excel Worksheet Functions | |||
| Multiple dates, times, or formulas in a single cell | Excel Discussion (Misc queries) | |||
Linear Mode
