Recent content by laxster

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

Sorry, I should have clarified that - the IEP_OFFER_NBR should not appear in the where statements any longer, as we made a table that will contain the value we want for that for the purpose of automating many of the audits we do.

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

Well, coupon #s can be assigned to multiple items (IE: milk and cookies could get the same coupon #; this is an "item family"). I don't care about the duplicates within a campaign.... simply the coupon #s that are being used across campaigns. Below is the SQL I have so far that gets me close...

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

I am trying to make one more tweak to this bit of code, to no avail. Basically, I want "Hangs" to continue to show indefinitely -- ignoring the month they occur in. This is different than "Empty" bins, which simply stop the display of Empty after the month is up. Been fiddling with the code...

I ended up using a different macro which calls for the user to manually recalculate the sheet.

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

I've attached a "stripped down" version of the file with the relevant tabs. The tab that has the information driving this is the Entry tab, and is used in column T. I hope you're able to catch what I'm missing or provide some insight! :)

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

I keep the database file pretty well locked down -- where someone would have to hit the shift key when opening to see behind the scenes. Usually a security message pops up where you would then hold down the shift key, but he doesn't get that, so I'm not able to help him compile. Is there...