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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top