Hello, I have a spreadsheet that the cells contain links to other tabs in the spread sheet.
I also an html file that directly relates to the spreadsheet... I need to take the html file and copy into the spread sheet while maintaining the links... can anyone help me with that, ASAP please....
Kipp
You want to paste into a cell or range of cells that contains a link or links?
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
Yes, the data would change, but the links under the data would stay the same.
Perhaps selecting the data to copy and then paste special-values only, is the way to go for your problem.
ok, thanks for the reminder. Do you have any idea how to do the post I just put up?
thanks
Not without some sort of mock workbook containing links and also the html document.
I convert many tables from html as part of my job and cannot straight copy/paste html tables over linked cells without the paste removing the link. What I do here is have a staging sheet where the html tables are loaded into to be cleaned and readied for the data store sheets. Creating something like what I just described enables straight data transfers from html without affecting formulas or links. However, there is a fair bit of coding involved.
ok. thanks... that helps me rule out what I was looking for.
Thanks for the help!
You can do it but, and someone will correct me if I am wrong, you'll have to do some coding or provide and example like I had asked for in post # 5 so that it can be worked on.
Here is an example of what I was talking about....
I have two tabs...
TAB "DASHBOARD" in the spreadsheet looks like:
The Organization is a link, so if you click on ACC then it takes you to the "DETAIL tab which contains ALL the data for both organizations but filters on ACC, same for AETC...
Organization Total Number of Investments ACC 143 AETC 105
Now if you click on the numbers, say 143 in the DASHBOARD tab, it takes you to the DETAIL tab as well, there should be 143 lines of ACC items listed (filtered)...
Like I said before though, if I copy it in from the html file, I lose all those links and filters.....
Many Thanks ahead of time....
Kipp
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks