Search results

I have a template in which people will paste varying amounts of information into Column A - could be 10 records, could be 100. I need Excel to automatically fill down a set of data that remains constant. So if Cells A2:A10 are filled, I need the data residing in B2:C2 and fills B3:C10 with the...

I am trying to re-write the following SQL statement to eliminate the "where" part of the statement, as we need to use the value in single-cell table. However, I am having trouble getting the exact results, and I think the problem is with my joins. Original SQL: select...

Hi, I have a database pull that I use to build audits off of. However, I do have an issue with one pivot I build off the audit. Items for sale are grouped into "item families" Because of how the query is run (and the information I want), the investment quantities for each item family are...

I have two columns within a table that I am trying to write a query for. I am trying to compare "Coupon #" with "Campaign #" ... so I can pull out only instances where the Coupon # is being used across multiple campaigns. So for example, in the sample dataset below, 2 entries for 21645 should...

Hi, I'm having an issue with a particular bit of code. All the cells are unlocked prior to running the code. After I run the code, the cells also get locked up, which is not desired. I'm bashing my head trying to figure out why these cells are getting locked up, as nowhere do I have any...

I have a macro that closes a form and updates the table it is based on, then reopens the form. If I run the macro from the side pane it works fine, but when I try running it from a button on the form I get the following message: The database engine could not lock table ' TblLastUpdateDate '...

Thanks to Brian's help with a tweak, the other bit of code I wrote is mostly working. However, one issue I am having with the code I wrote is that the function doesn't always update despite changes on the sheet without hitting Ctrl-Alt-F9. Send keys doesn't work, nor do other methods I've...

Function previous(ByVal status_x As Range, ByVal date_x As Range, ByVal bin_x As Range) As String For Each C In Sheet6.Range(Range("F9"), Range("F9").End(xlDown)).Cells If Month(C.Value) = Month(date_x.Value) And Day(C.Value) < Day(date_x.Value) And Cells(C.Row, bin_x.Column).Text...

I'm trying to combine two formulas into one result. I have this formula: =IF(ISNA(VLOOKUP("Bin"&$A6&"Month"&F$3,Entry!$A:$S,19,FALSE)),VLOOKUP("Bin"&$A6&"Month"&F$3,Entry!$A:$S,19,FALSE),"Empty") and if it doesn't pull up any output, then I'd like for it to look one cell to the left to see if...

Hi all, One of my users is getting an error message 'Undefined Function "UCase" in expression' pop up. In the past, when someone had this issue, I'd tell them to check the references in VB and unselect anything that says "MISSING" which has fixed the issue in every case, until now. This...

Hello all, I've been struggling with finding a solution to this problem. I have the individual pieces correct, but when I try to combine them I have issues. Currently I have 2 sheets. 1 is an entry sheet in which a plant operator would indicate if bins are empty, hung, or have non-flowable...

I have a set of data of X and Y values, generated through formulas. When I try to graph the results of these values, they do not plot on the scatter -- everything displays incorrectly, points aren't plotted, and the scale is wacky. However, when I copy and paste just the values, I have no...

Hi all, I'm not quite sure how to graph this, since Excel keeps throwing back errors at me. All the values at the top are X values - 1,2,3,4,5,6, etc. Each value below the X value should be a Y value. What I want to do is graph each of these values, so in the current example I'd have a...

Hi, The organization I have been developing for is in the process of migrating from Office 2003 to Office 2010. It's a large organization, and thus I'm unable to convert my Access databases into a 2010 format without leaving a large number of folks behind -- and I'm not in I/S so I can't...

I am having an issue with file sizes due to a complex series of formulas that I'm trying to solve. Basically, I have an 'Entry' worksheet, which new entries are added to. Based off of each entry, a formula checks to see how to categorize each record that is added. Another formula creates a...

I have data that gets copied via macro from one area to another. However, when it copies, it converts the date format to a general format. I don't want users to have to then reapply a date format to the specific column. Is there a way I could assign a column's cells to be for a date using VBA...

Hi all, I'm trying to paste information from one sheet to another via macros, then have the first empty cell below the data insertion point to be selected. C7 is where the data set I'm working with starts, but currently the code just copies over what I've already got instead of adding it to...

So I've been delegated the unenjoyable task of trying to get a Microsoft Excel file to do what one would typically do with Access. It sucks. In my poking around Excel, I found Microsoft Query buried deep within the menus, which is able to query spreadsheets much like Access would. In fact...

How can I convert this into being a static date stamp? It does what I need it to do, but when that particular field is a zero, I need to be able to have a static date stamp when that happens. I've found a few posts about static date stamps, but none of them are very useful. Any idea how...

Simple issue here with vlookup but it's giving me a headache! :rolleyes: Anyhow, I have various columns showing the capacity of a bin for every item on every date. If a bin capacity drops to 0, I need to be able to return what date that occured on -- and there are 31 columns labeled with...