excel rookie needs help

[arrlo]

although i've used EXCEL at work,i've never created anything before from scratch...now i have a new job where i would like to implement a similar EXCEL program that i used at my previous employment... it goes like this, on the 1st sheet i would have set cells with info. like NAME, DATE OF BIRTH, etc., then all that info would appear in the 2nd sheet...the 2nd sheet would not have any cells but an application...what is used now at my new job is MAIL MERGE but isnt as efficient as the way i did it at my other job...i've been trying to figure this out for hours but am clueless...how do i do all of this???..thanks

 

[plettieri]

Hi and welcome to the board,

It might be helpful if you could tell us what is that you are trying to do...

plettieri

 

[arrlo]

okay here goes...in cells 'A1, A2, A3....' i want to have set cells with various info such as NAME, DATE OF BIRTH, PLACE OF BIRTH, etc,...in cells B1, B2, B3, i want to type the corresponding info....so for ex. MICKEY MOUSE, 01/01/1901, NY.... then i want that info to appear on an application that would be saved in the tab at the bottom named 'SHEET 2'.... it would have to be for approx. 30 individuals and also about 20 SHEET tabs...also, how would i be able to get the various forms i have permanently saved in the SHEET tabs, do i scan them?...i also have to save all this data in a folder for each day...i appreciate any and all help...

 

[plettieri]

Hi Arrlo

bump

This sounds like a VBA solution or suggestion is needed here....Arrlo, I got your PM request, and by bumping it here I hope some of the VBA gurus might pick this up as a challange.

Good luck!!!


plettieri