querry

  1. D

    Code looping twice

    Hi friends, I am stuck in a VBA problem. actually, the code is printing the value twice in subsequent rows its working fine on my previous excel version 2007 but now I shifted to office 365 and its printing the values twice whenever the cell changes. Attached photo for clarification see timing...
  2. 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...
  3. 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
  4. 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...
  5. 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...
  6. 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.
  7. 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...
  8. 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...
  9. 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...
  10. 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

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top