New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Automatically copy data in next sheet (Formated)

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Automatically copy data in next sheet (Formated)

Postby mohammedkhan » Thu Feb 09, 2017 11:07 am

Hello, i want to print ID card of all members whos data is entering in Sheet1 i have formated sheet2 so i want data which i enter in sheet one each line should come in sheet 2 individually so that i can print cards from formated sheet2. below examples
Sheet1
Name Company name Mobile Number
XYZ asfdsdf 30439403
ZZZ werwesf 242314234
ABC asdfwerqwer 9889863

when i type xyz next sheet should also take xyz and i will take print, again when i type zzz sheet2 should take only zzz not above line xyz
Sheet2
Name Company name Mobile Number
XYZ asfdsdf 30439403
it should come like this, than i can take id print out again when in sheet1 i enter next row it should come only next row but not first one. please help
  • 0

mohammedkhan
Rookie
 
Posts: 1
Joined: Feb 9, 2017
Reputation: 0
Excel Version: 2010

Re: Automatically copy data in next sheet (Formated)

Postby Shashank » Thu Feb 09, 2017 10:36 pm

Sir
please note the file enclosed, you will see two sheets, where in first sheet is the data as directed by you and second sheet is the card. you have to select the drop down menu to select the name of the card or person you need to print, then the card format will update the required details

regards
Shashank
  • 0

You do not have the required permissions to view the files attached to this post.
[b][color=#400040]Shashank[/color][/b]
Experience is what you get when you don’t get what you want.
Shashank
Valued Contributor
 
Posts: 126
Joined: Jul 29, 2013
Location: India
Reputation: 10
Excel Version: 2007


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 40 guests