catalog

i have an sheet with 9832 rows...and in col B i have numbers from a pdf catalog... this is a product catalog and each cell represents a product from the catalaog. i want to double click a cell and open the page from the catalog. anyone can help me with this... Thx!

Hello, Experiencing a problem with VBA. I am trying to copy range F1:M15 from 40 worksheets and pasting it as image on Sheet1. Pictures need to be places one after another in column A. (Preferably fixed in a cell, i.e. first in A1, 2nd in A2 etc.). Sadly I can't get my code to work. Could...

Hi I Have access query result where i see expected result in MS access itself but when I copy and paste same result, I see extra double quote in result. how do I fix this issue ? Please see attached. This is how I see query result in my MS Access query result <tbody> Catalog_Table_View...

Hi I'm trying to pull data from many sheets to a sheet called "Catalog", but I'm not getting the results I want. I'm currently using this...

Ok, please let me know if I am thinking beyond what excel is capable of! Here is my delema. I work in the field alot and most time I do not have access to the internet to search for pictures of items. What I am trying to do is create a catalog of parts used (already have that created) and...

I have a calculated column to categorize spend types in a 8+ million row table. The existing version posted below works, but I need to add one more variable (potentially doubling the number of categories) and when I try it works in the data model window but Excel goes bye-bye when I go into...

The attached spreadsheet is an inventory list. Each tab is a different category of parts and supplies and the first tab, called "All Parts Catalog Only" is the main page. I am having a problem with people adding new parts and pictures to the individual tabs but not adding them to the "All...

I have a very complex project that I am working on that involves looking up historical pricing. Here are my challenges: Identical products are found in multiple catalogs and sometimes at a different price. Since pricing within a particular catalog may change occasionally, there are pricing...

How do I insert/link individual fields from an Excel 2010 spreadsheet into a Publisher 2010 file? I have a big document and want to be able to make changes within a spreadsheet and have them show up in the publisher document.

Hi Guys, Im trying to make a simple macro for cataloging some equipment and where its located. I've created a user form where there is a free text field for Equipment. Instead of just inserting this entry into the first available cell, i would like for it to place it in the first available...

Average cost of item based on variable in cell <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have been working for several hours trying to come up with a formula to solve the following (I will keep it simple for this example). I am using Excel 2003...