I am seeking a formula which can be “dragged” which will copy certain cells upon a row onto specific cells on another tab, when i drag at present it skips rows from tab 1?
Eg;
Tab1 B12 to Tab2 C8 & Tab1 E12 to Tab2 C12 & several others
Tab1 B13 to Tab2 K8& Tab1 E12 to Tab2 K2 & several others
Tab1 B14to Tab2 S8& Tab1 E12 to Tab2 S2 & several others
Example spreadsheet attached
Simple for all you Excel genius’s, I am only just getting to grips with excel & cant wait to know as much as all of you!
Thanx in advance for any help you can give!
MOD: thread moved to appropriate Forum - please use most appropriate forum going forward...
Last edited by TryingTina; 01-18-2010 at 05:30 PM.
What are you trying to do?
print one (or many) form(s) at a time?
Am I missing something?
I have a list of 124names on tab 1, I would like the information from the relevant cells on tab 1 onto tab 2, see attachment; attachment has 3 examples but I will require to print 124 a4sheets from tab 2 = each relevant to the person name in tab 1
(hope this make sense)
Hi Tina,
Would you be happy for this to be done using a macro which loops through every row of information to populate the Letter template & sends the created sheet to the printer x 124 times?
Do you need a copy of each created sheet to be kept in the Excel file?
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
i assume i would manage the macro, but if i were to add additional personnel informion into tab 1,(+124) keeping it alphabetical by surname (as is at the present time) i would require the cells on tab 2 to still co-ordinate with the personnel number on tab 1 (eg personnel #1 on row12(B12) = sheet to print out=page 1, this would be person with surnmae 1st alphabetically.
yes, i require to keep the originals
thank you!
i'd have thought using word and mailmerge with the excel workbook as the data source would be the way to do this!
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I remember i done that ant college, but it was a LONG time ago
any assistance to make the letter from the information of the dayabase i have, is immensly appreciated,
Hi Tina,
I think Martin has hit the nail on the head!
I haven't used "Mail Merge" myself, but it seems reasonably self-explanatory in the Help files (at least for Word 2007). I suggest you look the phrase up in the MS Word files (&/or Google) & have a go from there...
Good luck,
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
Thank you soooo very much for all of your help!!
all working well!
Fantastic!
Thanks for the feedback & marking the post as solved
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks