1. M

    Get only data on PivotTable

    If I double click Grand total on PivotTable I get all columns of data including those not on the PivotTable. Is there way to get the data only for dimensions that appear in the PivotTable only ? Thanks
  2. M

    Defining shape dimensions

    Hi Dears, I am trying to draw a 3d box (shape type 14) with VBA, but I cannot find the required parameter to define its depth. The width and height parameters are very clear, but I am unable to change the default depth of this shape. The command used to draw the box is; DIM MyShaep as Shapes...
  3. M

    Importing data week by week

    Please can someone let me know the best way to approach this challenge - I need to create a Master sheet capturing data week by week during the year from another sheet each week. The issue is lining the data when the client's locations will not always be the same (income is against the...
  4. E

    Insert Image Path and Dimensions Returned

    I am trying to be able to insert the path to an image, and have the dimensions and other attributes of the image returned in a cell. I am able to get the dimensions of all the images located in the specified folder when running the macro below: Sub Dimensions() Dim sFile As Variant Dim oShell...
  5. U

    Excel Loop?

    Hey guys, first post here. I need a little help. Basically I have two sheets, Sheet 1 contains the dimensions of parts I have at my warehouse, and the Box Types sheet contains the dimensions of boxes we have available. I think you can see where I am going with this. I'm trying to reference Box...
  6. J

    Select every field in row different from value and copy

    Hello guys, I'd like to make a macro that selects all values in column J that are different from 0, and all values in column K different from 0.01.1900, and copies them on let's say A1 on sheet2. The dimensions of the J and K values will match and will be in one block. Any help?
  7. H

    Feet and Inches - Cut List Optimizer

    Not sure if this is doable or not...but figured this would be the place to find out. I make boxes out of plywood for storing various materials, kids sports stuff, tools, etc. I'd like to have a spreadsheet that I could enter in the thickness of the material and finished dimensions of the box...
  8. H

    File-specific Printing

    Hi guys, I have two files that need to print at different dimensions. The dimensions are set by the label printers. I am wondering if anyone knows how to get a file to always print to a specific printer. I looked into it and it looks as though it may be dependent on a macro. Thanks!
  9. C

    Separate dimensions is a string

    Hi All Can someone help me out please I am am trying to create a formula to separate dimensions in a cell and display them in separate cells example in Cell A2 it has <tbody> PRODUCT DIMENSIONS ARE 305X1070X1625MM I want to display in cell B2 C2 and D2 <tbody> B2 305 C2 1070 D2...
  10. B

    image dimensions

    Hi, I found code for image dimensions in adobe (https://forums.adobe.com/thread/2309642). Can something like that be done in excel? To show image width and height as alert for x number of columns (for multiple columns)? I work a lot with excel, but i am beginner in vba (researching it). Till...
  11. B

    Making Best Use of Wood

    I wood say ;) that one of the most practical uses of an advanced spreadsheet for the Average User, would be to create a sheet that determines the best use of several pieces of wood, such as plywood, based on a parts list. Im not saying its possible for the intended purpose, but if they could do...
  12. B

    can we draw shape?

    my intention to draw shape by using cell reference i like to give shape dimensions,angles which i want to draw triangle rectangle...etc in excel
  13. M

    Quick array question

    Can anyone give e the syntax of how I'd create a variant array without setting the dimensions beforehand or using a range on a sheet At the moment I basically Dim unclosed_liabilities_array As Variant then set the array by finding the last row and selecting an empty space on the sheet...
  14. C

    Sumproduct, different dimensions

    The E4 SUMPRODUCT total shows 46 upon being entered. Can someone tell me mathematically how Excel got there since the arrays are different dimensions? Notice I changed the , to a * sign. Thanks.
  15. M

    Finding which 4 boxes can hold product X's dimensions

    Hey, Friends; So lets say I have 4 box sizes with their dimension in a list. I also have an array of objects to fit in the boxes with their own dimensions. I only want to fit one item in one box so i want the box that fits the item the best. Under my "box that fits" column, I'd like a formula...
  16. J

    Several variables but few resources of addresing

    Hi guys! In PBI, we have very few ressources for work with addressing/variable/dimension. Basically, we have 2: Table and Colommun. Example: Table1[Colommun1] Table1[Colommun2] Table1[Colommun3] Table2[Colommun1] Table2[Colommun2] Table2[Colommun3] Table3[Colommun1] Table3[Colommun2]...
  17. S

    convert # x # dimensions to decimal for panel size

    Hello, I am hoping someone has some experience taking dimensions and converting them into decimal format. I have made some code to extract all panels from a list and create a new sheet called "Panels." I need to take this one step further, and convert the # x # format into a decimal number...
  18. K

    How to add a dimension to convert a 1D array into a 2D array?

    I start with a 1D array, e.g., Array1(1 to 24), and would like to add a dimension and convert this to a 2D array, e.g., Array1(1 to 24, 1 to 36), while retaining the original values from the 1D array. I tried the following, but the VBA routine exits with an error: ReDim Preserve Array1(1 to...
  19. A

    Display highlighted cells dimensions

    Hello, We are working on a warehouse layout, which has huge floorspace, using excel spreadsheet. the layout scale is good enough to represent each square cell as One Square foot. We're trying to measure certain areas by highlighting group of cells, no matter if they contain values or blank...
  20. S

    Plot and plot elements dimensions

    I'm making a program that will rearrange scatter plot labels so they don't overlap. It's almost finished, but there are a few more kinks I need to iron out. 1. For some reason ActiveSheet.ChartObjects(1)'s dimensions are not right (I have only one chart on the sheet). From what I saw the height...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...