catalog

  1. A

    excel cell - pdf 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!
  2. A

    Copying Range as image from multiple sheets

    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...
  3. M

    Double Quote in Access Query result Causes two double Quote When You copy and Paste.

    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...
  4. A

    Dynamic Index Match Match with Indirect

    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...
  5. J

    Inserting and Searching a PDF in excel

    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...
  6. M

    DAX calculated column hanging - optimize or build in Power Query?

    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...
  7. J

    Macro to Add Individual Tabs to One Main Tab

    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...
  8. G

    Can SUMIF & SUMPRODUCT work together in a formula?

    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...
  9. S

    How to link Excel fields to a Publisher file?

    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.
  10. G

    How to insert a text field into appropriate worksheet based on alphabetical value?

    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...
  11. N

    Sum of Column C based on Column A / Cost comparisson

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top