querry

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

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

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

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

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

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.

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

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

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

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