I have a requirement to copy cell values from "Sheet1", cells A1 and A2 to "Sheet2" cells B1 and B2 respectively. I would like to set a hyperlink in Sheet1 and on clicking the link, Sheet2 should be open and values of A1 and A2 from Sheet1 should be copied to B1 and B2 in Sheet2.
Is there a way to do this using Excel formulae without using macros?
Last edited by zykkzxxy789077; 07-27-2016 at 10:53 AM.
When you say sheet, do you mean workbook or workSHEET?
Also if you use formulas the link will be LIVE, as opposed to a macro where it literally copies and pastes the values.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
You don't need a hyperlink to do this. A hyperlink takes you to a location, it doesn't do any kind of calculation.
Enter this formula in Sheet2 B2 and copy down as needed:
=Sheet1!A1
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I meant worksheet, sorry. I would want value of a cell copied from a worksheet to a cell on another worksheet
Yeah so the formula Tony posted above will be VERY simple and should work for you.
If it was a different workbook the formula would be different but it would do the same thing.
A hyperlink is like a shortcut in your internet browser that takes you to EXCELFORUM.com when you click on the link. So people use hyperlinks in Excel to click the button and take them to somewhere else in the workbook.
Thank you for your replies, I get that but maybe I should have put my question in much detail.
Here is a sample of what I would need to do,
Sheet1 has the below:
http://i35.servimg.com/u/f35/15/16/19/62/sheet110.jpg
Sheet2 has the below:
http://i35.servimg.com/u/f35/15/16/19/62/sheet210.jpg
When I click on the individual links on sheet1, sheet2 should be open and the values of Airport and Code should be automatically populated as per the Airport and Code in the sheet1 in the same row as the link is clicked from.
Sheet 2 then already has a formula to display the list of flights according to the code and airport.
Okay lets start over.
Attach a sample workbook (NOT images). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Ok, I have added the mockup excel
Where do the list of flights come from that was used to populate the Flights List worksheet?
In the mockup, I had hardcoded it. But ideally it should come from "Index" sheet's Airport, Code in the same row as the link is clicked from
How does the list change?
There is no raw data that I see...
So the list that you see in "Flight List" sheet is derived from the Airport and Code fields from the same sheet. I already have a logic for that, I have hardcoded the data in excel for now.
I am interested in the part when I click the "Link" in "Index" sheet - It should copy the corresponding row's Airport and code into "Flight List" sheet's Airport and Code.
Why not just create 5 tabs and have the link go to whichever is needed?
I was considering the same, but the input is dynamic and gotten from SQL query results, there are scenario where I could get upto 100s of rows. And hence this approach.
Then use ONE sheet and a slicer to drive ONE pivot table. Then instead of LINKS use the slicer to drive the pivot.
I do that most frequently, since pivoting is MUCH easier than managing the slick logic with excel or vba to populate the lists.
In my actual worksheet that I work on, I do have a slicer in the "Flight List" sheet that filters the result as per the Airport and Code.
But I would like to have the link from Index sheet, when clicked it should automatically populate the corresponding Airport and Code value into the "Flight List" sheets slicer fields. The slicer will automatically filter then.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks