LinkBack URL
About LinkBacks
Scenario:
I have a sheet called certificate,now when i type the name of the person in the sheet1 then automatically the name of the person will display to cell in a sheet2..
any idea?
Thanks!
Good day!
Godbless Us!
Entering data into cell and automatically view to another sheet of cell
Scenario:
I have a sheet called certificate,now when i type the name of the person in the sheet1 then automatically the name of the person will display to cell in a sheet2..
any idea?
Thanks!
Good day!
Godbless Us!
Macro Solution:
Two Simple Macros are needed.
One is sheet specific and will look for you to type a name in a specific location.
Once you type the name the sheet specific macro will pass the name to a second macro
That macro will write the name into a specific location in sheet 2.
The first macro is sheet specific and cannot write to another sheet.
Formula solution.
A simple formula in Sheet 2 will read the name from sheet 1.
Formula:
=Sheet1!A1
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Got it!
Thank you so much mehmetcik.
Last edited by Jonald; 05-03-2015 at 06:04 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks