attributes

  1. L

    Averageifs Function with dynamic number of Criteria - Toggle Criteria On/Off

    Hello all, I have spent the better part of a day unsuccessfully trying to see if there was a way to toggle the number of criteria on / off to perform a dynamic average. I have included a screen shot of file - essentially, I would like to toggle on / off certain attributes and perform an...
  2. A

    What is a Range

    For example, if I have Dat= Range("O59:CL59") what have I got ? I cannot see it in a Watch, nor print Len(Dat). What can I do with it ? Can I put it onto another sheet? And could it carry across any attributes (font, back color etc) as well as values ?
  3. H

    Select specific part number in one excel tab and the other tab changes accordingly for this selected part

    Hi all: Very new to the VBA. Here is the goal I want to do. I have to two data set in two excel tabs. One tab has part attributes for specific part number and the other tab has sales information. So, my question is how can I filter one part number in part attributes tab and the sales...
  4. R

    Column header based data validation vba

    Good day experts. I'm not sure if this has been attempted before, i'm new here, so if anyone of you have come across this situation before please link me to the correct thread :) My question is, can we vba code data validation in a table to check the value of a column header and then allow...
  5. B

    VBA compact attributes in less columns

    Hi everyone. My first post here but used as inspiration many times. The original data is on A1:F14 and the desired outcome in K1:M14. I`m looking to use less columns to show attributes for each ID on column A. The single restriction is that the unique strings must be placed on the same column...
  6. S

    How to set cell A1 to pull from Cell B1 but then remain static even if B1 changes?

    My company creates an ID for each product based on certain attributes of the product (size, colour, etc). The problem is I need to make it such that if those attributes change the ID must not update. Is there any way to say run this formula once but do not update? Currently I just cut the ID...
  7. H

    How to format existing text in headers/footers?

    Hi there. First, my apologies if this has been covered and I failed to see it when I searched; if so, I'd be grateful for a link. Is there a simple way to apply formatting to existing text in the LeftHeader? The text will have been manually typed and (sometimes) formatted; it is not added via...
  8. M

    Vlookups ? Creating a traffic light matrix using

    Hi, I am trying to create a traffic light kind of a report using excel. There are three different attributes based on which the performance of a project is assessed - Cost, Time, and Quality. These attributes can take one of three Status (R)ed, (A)mber, or (G)reen. What I am trying to create is...
  9. D

    IF + INDEX-MATCH and return value from different cell

    Last time I asked here something this forum was very helpful, so I hope one of you can help me with my next problem. I have data in one sheet, with an ID number, Attributes that go with it and corresponding values. But one ID can have multiple attributes and values. And this data has to be...
  10. S

    If I have an average (%) how to know the values of it...

    Hello, I have a table with attributes from 1,2...8 and respective percentages. If you see, with higher attributes, the percentages are also increasing. For 6 and 7 I do not have percentages, but I have average of 6 and 7 that is 26,78%. I it possible to find the percentages of 6 and 7, if we...
  11. T

    Copy specific data from master worksheet to specific worksheet *VBA*

    Hi all. I have a basic understanding of Excel so please bare with me. I am trying to create a macro that will copy data from a master worksheet and paste it into a worksheet that corresponds with data ID (see example). I hope this makes sense, Thank you:) Master <tbody> ID Value Description...
  12. S

    [VBA] Code to Query Outlook LDAP Attributes Not Working After Switch to Outlook 2013

    Hello again guys. The organisation I work for has very recently upgraded from Outlook 2010 to Outlook 2013. For the past few years I’ve been using the below code in various Excel Workbooks but since the change to Outlook 2013 it’s stopped working properly. I can’t remember where I got the...
  13. Z

    VLOOKUP Problem - Duplicate information

    Hi, I'm stuck and I'm not sure what to do. I'm not what you would call an Advanced Excel user but I'm able to get around and most of the formulas make sense. I've linked an image of what I'm trying to do. Essentially, I'm trying to take information from the Total Responses section and show it on...
  14. L

    Folder properties

    Hi all, I'm looking for a simple code that can obtain the properties of a windows folder. On windows if you right click a folder and go to properties you can obtain the number of files/number of folders etc. in a few seconds. However, if you use the recursive method of looking through each...
  15. S

    CSV File attributes

    Hello I have Excel vba that merges CVSs files and produce one master file. I want now to add file attributes to the master csv file. The date and time was easily retrieved using fileDateTime function. Is there a similar function to get the owner/author for that file?
  16. blaksnm

    Macro reading updates from closed files

    Hi I have a master file wher a lot of updates rom oher files are processed (manually transpor of data). The inputs come from a number of provider-files. I really should have a check on every provider-file if it is updated or not since last inputof mine (match attribute: Time Modyfie?) Can this...
  17. A

    Transposing Product Attributes from Columns to Rows

    I have a large batch of product information that I am looking to reformat so that it can be imported to our website. Below is an example of the format that it is in now is: <colgroup><col><col><col></colgroup><tbody> SKU Number AttributeName ProductAttributeValue C01 Width 2.6" C01 Length...
  18. J

    New Range Attribute / Property

    Team, Is it possible to create, via .xla, .com or some other method a New attribute or property for a range or a cell? E.g.: Worksheet("Sheet1").Range("A1").NewAttrib = 0 I need to test every cell that has data. So I'm looking for some method to store if: 1) The cell has not yet been tested...
  19. L

    Pasting again, vba attributes

    Sounds simple, but... I have a sheet with 11 columns of data. Each row is formatted according to values in certain columns (e.g. if person is project leader = Fat text, has left the project = red background) etc. Now I want to copy some cells (No problem here thanks to people on here) and...
  20. M

    Filename Properties

    I have a question and it's probably a long shot, but maybe someone will have a suggestion I can use. What I am trying to do, is get the Modified & Creation Date of all files in a series of folders. For instance, the files can be .pdf, .xls, .doc, .rtf and would be located: in "This Folder" and...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top