build

  1. N

    Lookup/Index/Match

    Hi team, I was wondering if someone can help me with an interesting lookup issue I am having. I will receive a file that will be similar to Tab 2, out of which I need to build a view similar to Tab 1 below (I have manually filled in the numbers, to show what those cells should read). I tried...
  2. I

    build a matrix with conditions

    <tbody> AMOUNT 1 AMOUNT 2 220000 154 153000 1001 74000 2521 756349 3256 122000 4566 856746 1566 444352 816 212158 612 346777 315 </tbody> Hi all, I need a little help with a matrix and formulas inside. I have 2 columns - AMOUNT 1 and AMOUNT 2 and I need...
  3. H

    SQL Query using excel to build the where clause

    Hello, I am trying to write some VBA code which builds a SQL query using cells in my excel spreadsheet to build the where clause. I currently have a string like the following: SQLStr= "SELECT * FROM TABLE". I would like to build in some where criteria, which would grab field names and field...
  4. A

    Creating a Timeline

    Hello, I have had zero luck trying to build a timeline chart mainly because I have no idea what I'm doing. I appreciate any and all assistance. My worksheet is working correctly in generating the correct times per task. Data is built in the following format: Task Event Start...
  5. H

    Dynamically Building VisibleItemsList

    Hi All, I need to build a VisibleItemsList to be able to filter based on the Criteria that the PivotItems names Should begin with DC- but not DC-PLANNING. My idea so far is this: (I) Build an array of values and (II) use the array in the .VisibleItmesList Here is the code I got so far. Sub...
  6. B

    Excel Perforamnce Issues

    Has anyone else noticed that offi efor excel is vastly slower and more unstable than 2013/2010. I have multiple users that are experiencing lock ups, hanging and even white screens after moving from 2013 to 365. Some of these issues have been resolved in build 1807 compared to the dreadful state...
  7. E

    Looping through months and years

    Hi I Want to build an excel file that looks like this: On column A the user put years (i.e: a1 is 2015 , a2 is 2016 , a3 is 2017) I want the macro will put on column C the year/month (i.e: c1 is 1/2015 , c2 is 2/2015 , c12 is 12/2015 , c13 is 1/2016 , c36 is 12/2017) I want to get 36 cells with...
  8. R

    Build new table from existing table

    Hiyas, I have a worksheet ("Plugins") that contains a table ("tblPlugins") with one of the columns ("Installed") having data validation that contains Yes/No. I'm trying to build a new table in a separate worksheet based on the condition that if the column ("Installed") has a value of Yes, that...
  9. L

    Build a string

    Hi I have a range in which the same code is repeated, but this code has another code called Priority. I need to go through the codes and build a string with the Priorities. Exampe: Code Priority String 10.......1........12 10 ......2........12 I try with this For Each: For Each celP...
  10. C

    Link to a file name with a cell value

    Hello, I have 2 files. file 1 collects information from multiple files, just numbers. i want to be able to type in a person's name in file 1, and have it use that name in multiple formulas in that file to grab different cells in file 2. i.e. ='c:\temp\jonsmith_file.xlsx'!C1. I want to be...
  11. P

    Calculating Returns for an insurance with annual rate and fees

    Hey! I am working on an excel model where i want to be able to compare the returns from different retirement insurances where I want to be able to calculate the returns based on a few different variables. Lets say I have the underlying amount of $1000 with 1) Expected to grow at 5% per year...
  12. R

    Creating a Line Graph

    I work with Excel a lot, but have never really had the need to use graphs. For the project I'm working on, I'd like to use some. I'd like to run the values of a column along the bottom of the graph (the X axis?), and have the values of a few other columns serve as the actual lines (the Y...
  13. F

    Multiple IF statements and separate formulas

    I am trying to build a formula that will verify a word in the first section and in another section, however if the word was to change the. It will produce a separate result. I have been able to complete it for one result but once I try and build upon it the formula no longer works. It says I...
  14. T

    How to wait for a Webs Service to complete a Download?

    <tbody> How to build a macro </tbody> How to build a macro that senses when a multi-column csv file has finished downloading and then proceed to process that information. The web service is called manually by the User; it does not support a Data Connection but it does download to the User's...
  15. M

    Trying to build a load plan. need help ! thanks

    Hi, i'm trying to build load plan in which i require multipul shop cage counts to add up and then see where they fit on to a wagon. i have got that part done but im wondering if it is possible to fill in, as many boxes with a shop name as there are in the sum? wagon would be 3 boxes wide ,by...
  16. M

    Pivot Table

    Hello there everyone, i have a question about pivot tables, or i think thats the best way to do what i want to accomplish. so i have a table of data that looks as follows: <tbody> Part # Part Name Dept. Op Description Mag 1 Mag 1 Build up Mag 2 Mag 2 Build up Mag 3 Mag 3 Build up...
  17. N

    Live autoupdating line graph mirroting stock portfolio performance

    Hi all, I'm not much of an Excel guru but I'm trying to build a replica of Google Finance Portfolios now that the Portfolios portion is being axed. I've managed to replicate everything into a live spreadsheet but the line graph. I would like to build a line graph that plots the value of my...
  18. B

    Not delete record, hide/deactivate?

    Hi I have a set of forms connected to my tables. Currently i let users remove records. But id like to stop that and instead find a way to hide or deactivate the records instead of running the delete command. Does access support something like this? Or do i have to build something? If i have...
  19. M

    Find blank cells replace with text value

    I have searched the forum and have been unable to find the answer. I have a cell that is used for data validation and as I build the sheet I am finding that a good portion of the cells are blank which is what the validation is supposed to prevent. To build the spreadsheet I would like to go...
  20. S

    Vlookup or macro to auto fill next few rows

    I have a master sheet which has different build ups of roofing system. I would like to be able to (select or type) the system in column B of a separate workbook and the have Column C autofill with the components (this can be anything from 1 to 10 rows) hen have a blank row and continue with...

Some videos you may like

This Week's Hot Topics

Top