1. M

    Incrementing worksheet number in a formula ?

    I have data in workbooks and on worksheets and I would like to show some of it on another workbook. I understand how to get the values from the cell I want but is there a way to copy and paste the formula so that it changes incrementally. I have a workbook called Trends, with numbered...
  2. E

    Tracking Multiple Trends in a Worksheet

    I am looking to create a worksheet where I can track trends within a row. There are about 20 different optional trends and each user can pick up to 5 trends per row. However, I want to be able to analyse these trends as a whole in a pivot table (rather than separated as trend 1, trend 2 etc). It...
  3. T

    VBA to get Google trends automatically.

    Hi all, I've been searching for a way to use VBA code to get Google Trends data automatically on to a spreadsheet. Does anyone know how to do this? I can't seem to find a way at all. Thanks :)
  4. I

    Multiple Budgets over a range of months and years, with monthly cost/estimate showing by month for each project

    I have hundreds of rows of data. Each row is a project and cost with start date and end date. Some projects are old and complete, others have started and are ongoing and some have not even started. Using the full range of dates, I want to show the cost of each project by month. I've added the...
  5. R

    Advice on using .NET programming to create Custom Excel reports tied to SQL Server

    This is more of a career question for general advice on Excel Object Model Programming. Not that I have been looking for it, I have not seen .NET applications that utilize Excel Object Model Programming. Is this a niche' market? Would it be something worth pursuing? Does Mr Excel have training...
  6. M

    Trend (?) tutorial

    Can someone point me to a good tutorial? I have very simple data - On certain dates, I measure how much hard drive space I am taking up. I would like to project when, based upon date and the rate I will be out of space. I think that is Trend, but could it be "Linear"?? <TABLE...
  7. C

    Graphs, trends and series data Help needed

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>:confused: </o:p> Hi All,<o:p></o:p> <o:p></o:p> I currently have a graph based on 7 data sets, 5 are similar. 2 are % trends. I have a column graph, with values on top of each other, in weekly...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...