output

  1. S

    Getting a store chain's name from a branch

    Let's say I have the store column below. I'm trying to make a formula that will scrub the column and return an output with just the type of store as shown in the "Desired Output" column. Because the amount of words before/after the type varies, I couldn't use the mid function to look for a set...
  2. R

    Consolidate rows with a macro based on lack of value in certain columns

    I'm working on fixing a spreadsheet for work with very little VBA knowledge. I've got the original sheet working again but now would like to add a consolidation button for times when the outputted table is too long. This is an example of the output table from the macro: I'd like to output to...
  3. B

    lookup logic to interrogate specific exceptions

    Hello, See the below data example. Purpose: Output a 'Y' or 'N' based on a look-up. If the data is found in the columns in the look-up, a 'Y' is output, else 'N'. This is probably a IF/THEN type logic, but your assistance is greatly appreciated! Logic/Rules: 1) If the look-up matches...
  4. F

    Vlookup on multiple matches

    Dear All I have a query related to multiple matches through VLookup In my attached sheet I have 2 list. List1 has Field1 and Time. List 2 has Field2 Field2 matches to Field1 to get the output on column E through Vlookup. But due to multiple matches I cant have the desired output. Desired...
  5. S

    Merge Every 3 Rows into 1 row

    I have a data file of say 60,000 records and each record are up to column K. I need to combine every 3 rows as one row into a new worksheet. Input rows will be: A2 to K2, A3 to K3 and A4 to K4 Output will be on a new worksheet will be from: A2 to AG2 This formula will be for entire worksheet...
  6. C

    Check a list of values against multiple columns and output a list that appears in each?

    I'm stumped. Been trying this all morning. I have an excel file with two sheets: A. Master List + Output -- contains the base list of value that I want to check presence for against in all other columns in the "Daily Orders" sheet. B. Daily Orders -- contains lists of each day's purchased...
  7. D

    Input and output in Excel

    Hi all, i am have a small issue with my excel function. my goal is if i enter a file name it outputs the drive letter is should be on. the problem is that all of the file names are numbers and i only want it to search the first three characters but it does not. my function is...
  8. D

    Questions before diving in a cash management model using powerpivot and DAX

    Hi there, I'm refreshing/improving a cash management tool / dashboard I developed last year and I'm looking into information to do it the right way. The environment is as follow : - group has several companies and multiple bank account per company - some account are checking accounts and some...
  9. danhendo888

    How to transpose(?) column to desired output

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col...
  10. A

    format Date VBA

    I want to format the date output as "mm/dd/yy", however the code is not accomplishing what I want Original code output display show 1/15/2019 Cells(SRow, 22) = Cells(RowNum, 3) I tried this, but nothing happens. the output display show 1/15/2019 Cells(SRow, 22) = Format(Cells(RowNum...
  11. T

    How would you set this up - building from scratch

    I'm building a Macro for a project. It's going really well but quite a learning curve. The project has about 20 outputs. The first steps for all 20 are the same, but at a certain point the process diverges for each, mainly in terms of producing a Pivot Table with different fields (but all from...
  12. B

    Error 1004 when saving copied worksheets as new workbook

    I am automating the production of a load of output reports, and was getting a 400 Error when I tried to run. I have now narrowed it down and through the err.description have identified it as a 1004 error "The cell or chart you're trying to change is on a protected sheet. To make a change...
  13. L

    Weight Break calculations - A method question

    Hey everyone, Although this account is new I have been around before and ive always gotten good answers and im hoping once again i may get some help. This question is about how to convert a single line of parameters into slightly different static parameters. I could quite easily create a...
  14. F

    How to programmatically create a document with Excel data?

    Let's say I have an Excel spreadsheet with 3 columns (Name, Wife, date of death). Let's say I want to create a Word document that takes those three columns worth of date and prints it to the document like this: John Doe married Jane Jones and he died 1 Apr 2014. Sometimes, however, the person...
  15. J

    IF "THIS or THIS or THIS" then DOTHIS BUT IF "THIS or THIS or THIS" AND ALSO "THAT" then DOTHAT

    Sorry if the title is confusing, I think i might be going crazy by now haha. Trying to look at two columns of data and output accordingly. to simplify it lets say COLUMN A can have data input either (1,2,3) or any combination of them ie. 12, 123, 13, 23 COLUMN B can have data input (1, 2...
  16. E

    Data dumping output from 'Find and Replace' box

    Should be an easy solution but i can't seem to figure it out. Let's say you're looking for a specific word in a data set using the find and replace function and hit 'find all' - it displays all the results for the word you find. All i want to do is copy the 'Cell' reference output and paste...
  17. K

    Limit numbers for X and 2

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> The code below generate any combinations I use for example Const v& = 4 to 14 where Array is ("1", "X", "2") (3^4=81, and 3^14=4.782.969) so in the given example 3^4= 81 combinations are generated in the column A and column C & D there is a...
  18. B

    Decompress Alternate Spellings

    It would be incredibly helpful if someone could help me solve this problem. I have a list of alternate spellings of words (Column B), coupled with a unique number (Column A) Essentially I need a list of all the alternate spellings. There are two rules / means or () means optional sounds...
  19. M

    VBA filter function that includes only the next 3 months

    Hi guys, I am making a macro in excel for a weekly data output from an excel file. i already have two filters included, but the third one i would like to make is a little more tricky. <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...
  20. I

    Access Statusbar in a specific workbook

    I often have several workbooks open. When I run one of my macros, I output to the Statusbar using Application.StatusBar but that output to the statusbar in all of my workbooks. Is there a way to specif which statusbar you want to output to?

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top