Search results

a few people at my work were VERY impressed by pivot tables. also ability to bring data from the web. also HYPERLINK formula, but it's more impressive if you can link it to some web stored data. maybe Data Validation? good luck!

not sure exactly what you are trying to do, but if you have a query in Access, you can bring the data that it produces into Excel by going to Data tab (in Excel) then selecting 'From Access', etc, then use this data connection in Pivot Table.

save the code in personal.xlsb, perhaps? i would try that first, see what happens.

i had to do something conceptually similar recently, and after some research and testing decided to go with what i thought was the safest - cell by cell check. it's also the most time consuming, i believe, so judge for yourself if it suits your project. here is a piece of my code, it looks for...

i think 'Stop if True' does exactly what it says - it stops all the conditional formatting rules BELOW the checked check-mark. i don't recall ever using it, conditional formatting is finicky enough as is, i generally try not to complicate it even further.

probably not, excel file is rather big, over 7 megs, and forget about the database. i am attaching the pic of the file, and access query code is below, not sure it will help you, but just in case. thanks for your time and effort, i really appreciate. l SELECT A1.Boro, A1.District, A1.PropNum...

i'd guess it's just programmed that way. why it's programmed that way is another question.

i don't have any code in the excel file. nor in access where the data are pulled from. (ok, i do have some code in the excel file, but it's exclusively for formatting, just a couple of lines). it's the access query that's too slow. interestingly, i tried to run it today, and it seems a little...

a few minutes. maybe 3-5. the bar goes quickly almost to the end, but then gets stuck there, with not even a millimeter to go. i used Date(), not Now, i was just complaining that one of my variable names is 'Date', which is a big no-no, according to this forum.

i always have problems with conditional formatting ranges, they jump around and/or create new ranges if you start inserting/deleting/copying rows/columns/cells. try using $A:$R as your range, if you are ok with applying it to rows before 6th and after 500th, it may help.

aha, i think i see where you are going with this. except.. can this be part of the SQL 'WHERE' clause?.. nevermind, just checked, it can! (it looked like it belongs in VBA realm, which i am not too good at on the Access side) however - there is one issue. actually two issues. in my Excel...

the source is external data, from Access query.

hello. hope all are doing well, i haven't been here for a while. question - is it possible to limit the number of values that pivot table is displaying? i have years in columns, from 2002 to current, but every new year my table expands to the right. instead, whenever we roll into a new year...

could it be that in 2007 the function looks like .Insert Shift:=xlDown and in 2010 it looks like .Insert Shift:=xlShiftDown ?l

i would test for a few things - 1 - find value vs not find any - maybe it can't handle #N/A 2 - type of input - text or number or date etc - can be a problem with mismatch 3 - maybe it doesn't like '&'s ?

pivot table will automatically give you the number of times each part appears. just don't forget to create an additional column to record the name of the tab where the data came from - if you need that info.

maybe stack up all the data from 15+ tabs in one new tab and run a pivot table on this new big data block?

it may or may not help your cause - there is a neat wildcard trick to collect info from ALL the worksheets EXCEPT the one you are on, e.g - =SUM('*'!A2) will sum cells A2 of all the worksheets, except the one where the formula is. l

thanks for the quick reply, plog. i actually thought about it (except i used MIN function, not MAX, to keep older original records), but i am not sure what to do with the result. what do you mean by 'Bump it against your Inventory table...'? l

hello. i've been struggling with this seemingly simple task - deleting duplicates from a table. here is the situation - i have a table with 6 fields. first is a unique id (auto primary key), the rest 5 are just variables, which are being manually updated/added/deleted on a regular basis. when...