Hello - I wanted to use a formula which needs to take up values from a cell. Within the formula, the cell reference/linking is not working. I have given a link with a clear pic of the issue. Can someone please point out the issue or help me with a solution? Image link -> http://imgur.com/a/IxvxX
Welcome to the forum!
We cannot work with images. Please attach a sample workbook. 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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Will the target sheet be open or closed. If it is open, you can use INDIRECT. If it is closed there are other possibilities.
Put both sheets in the same place (e.g. desktop). Keep "source" closed. Open "pull", enabling macros as you do so. Change the path in c2 to reflect the situation in your PC. it should work.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
The target/source sheet will be closed. Thanks, I am trying to use your attachments. Will keep you posted.
Yes, silly me... source sheet.
I have added an excel sheet example clearly highlighting the issue. Pls take a look.
Were you able to use the "Pull" attachments to return values from "Source"?
I have now added the VBA code in Module 1 of your own sheet. The UDF "Pull" will now be available in your own sheet. Were you applying just the formula to your own sheet, wothout copying the code over? If so, you were going too far, too soon!!
Yeah, I tried it. But the purpose of it is different and so not helping my case. So to make it clear, I have attached the excel itself this time. Pls do take a look at the attachment.Originally Posted by Glenn Kennedy
One of my posts has vanished!!! Try this on your PC. Enable macros...
So. I put "source" in a folder called Temp, which was on my desktop.
I used the amended PULL formula:
=pull("'C:\Users\Windows 8\Desktop\"&A2&"\[source.xlsx]Sheet1'!a1")
where A2 contains the folder name temp.
Do the same. Amend \Users\Windows 8\ to suit your situation. It DOES work... It returns the value in A1 of the closed Source sheet using the folder name taken from another cell.
Thanks a lot for this
You never asked for E2 to become E3, etc... that's why it doesn't increment. look back in a couple of minutes...
Maybe this:
=pull("'C:\Users\Windows 8\Desktop\"&A2&"\[source.xlsx]Sheet1'!a"&ROWS($A$1:A1))
Put this in A2 and drag down...
=Pull("'C:\Users\aravind.WIN10HP360\Desktop\beads\extract\" & G2 & "\[live_inventory.xlsx]live_inventory'!E"& ROWS($A$2:A2)+1)
Sir, you are awesome!!! It works great
Thank you very much! Worked as well
Glad to have helped.
What he said!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks