querry

  1. K

    Querry Stopped Updating

    Question: What would cause a simple query to stop updating? I can see historical information but can't edit or add. I can delete an old record directly from the table and that appears to be reflected in the query but no other edits seem to pass between the query/form and table. We've used this...
  2. 1

    Formula query

    Hi all. I have inherited a spreadsheet with the following formula in it, can anyone please explain what it is doing. =4/3*PI()*C210^3 Many thanks in advance
  3. K

    Vlookup in a querry?

    Hi, I have a table of employees (TblEmployees). I use their ID key to link to whom they supervise EmployeeIDName SupervisorIDSupervisorName 1 John 2 Peter 2...
  4. B

    Dynamic Query path (Power Query)

    Hello, Is there a way to set dynamic querry paths in Excel? Example: I have a Master file which uses connections to 3 files which all have the same structure. The reason there are 3 files is because there are 3 people who must fill in their data. Then I created a querry in this Master file with...
  5. J

    Copy non-blank cells

    I have the results from a form in a series of columns with each row being a unique form submission. There are a series of optional comment columns. I would like to copy the non-blank cells from the response sheet to a summary sheet with each comment on a unique line for ease of reading.
  6. Y

    Accessing data in SQL Server via VBA

    I am currently writing aset of macros thatare supposed to get data from an SQL server, paste it in two sheets and then mash it up and send. Point 2. and 3. is easy but I have no experience with SQL whatsoever, hence thequestion. I've read several other threads on the subject on this forum and...
  7. B

    I need help with creating a complicated Access Query from Excel

    Hey everyone. I have no experience writing any VBA or Macros in Excel. I need to perform a very specific function to get an Access query into Excel. What I need to do is below: I need to have a button on the Excel spreadsheet that will start the act of pulling info from Access I need to COPY...
  8. S

    How to make this data easy to analyse?

    Hi, I have a problem trying to analyse a big inventory data from 2 different spreadsheets. Here's what my problem is: Data 1 (for On hand stock) <TABLE style="WIDTH: 283pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=377><COLGROUP><COL style="WIDTH: 56pt...
  9. J

    Report Problems

    I am trying to create a report with a list of residential lots for various subdivisions and the status of these lots. If I do a crosstab query it gives me the "count of" and if I run a regular query or report it is about 100 pages long. I would like everything to be arranged so that I have...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top