Search results

Hello all, it's been a while since I visited, hope everybody is healthy and in good spirits. I have two tables, Orders and Prices, see below, I'd like to calculate totals for each row in Orders, by multiplying quantity by price, then summing them. Currently I do it by creating another table...

Howdy, it's been a while, hope everyone is doing fine. I have this rather simple code below that runs without errors, but it doesn't actually do what it supposed to do - copy a range of cells from one sheet to other sheets. Nothing is copied for some reason. Could you help please. Thanks in...

Hello. In Excel 2013, the borders color of the simplest of the PivotTable Styles (found in DESIGN->PivotTable Styles->upper left corner in the grid with all the other styles; it's strangely called 'None') is unfortunately grey. How can I make it black, as it used to be in 2007? I can probably...

Howdy, it's been a while, hope everybody's in good spirits. Have a question. I am trying to use a criteria to filter out nulls in concatenated variable, which slows the query considerably. Is there a quick workaround? The part that makes it slow looks like this - ... WHERE ... AND (([tbl1].[x]...

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

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

hi. i am trying to automate splitting the text file in excel. my data comes as a text file with one big block of data, no delimiters, just one digit per field. i figured that i need to use either Workbooks.OpenText command or Selection.TextToColumns commands to do the job, but in both cases...

it's probably trivial, but i can't get rid of that first row of my filtered range. i have this statement: Set RngVis = ActiveSheet.AutoFilter.Range.Cells.SpecialCells(xlCellTypeVisible) which correctly gives me only the visible filtered cells, but includes the variable names row, which i...

hi. i need to copy data from one worksheet to another based on certain criteria. i wrote the following simple initial code to do the job. i now have one problem and one question: 1 - the code works fine when i run it once. if i run it the second time, without any changes to worksheets, i...

i need to create an Excel file (most likely 2007), which will be shared by a few users at different locations. what's the best way to go about it? i've never dealt with anything like this before in Excel format. i've used google spreadsheets before, which worked fine, but this time the file...

hi. is it possible to identify the bold portion of the text in excel (2007)? i have quite a few pages of the survey somebody did in Word, with the answer highlighted in yellow (don't ask). if i copy-paste these Word pages into excel, the highlighted answers become bold. so i have single cells...

hi. i finally finished - with the help of the forum's own great pbaldy - the query that i was going to use as the data feed for my Excel 2007 pivot table. everything seemed to be working initially - i insert the pivot table, find my query in the 'External Connection...' dialog, the "Reading...

hi. tried to figure this out on my own (using the DCount function), but sadly in vain. say i have a table with two fields, Prop and DateInsp (property and date when it was inspected). i'd like to write a query that will produce the following output - Prop DateInsp Cntr Prop1 3/24/11...

hi. i am using the following static Subtotal function in my macro - Selection.Subtotal GroupBy:=2, Function:=xlCount, TotalList:=Array(6), _ Replace:=True, PageBreaks:=True, SummaryBelowData:=True i tried to make that "6" dynamic, but surprisingly got an error message. the code i...

hi. i am new to Forms, so was having problems with this probably very simple one. please see attached. basically, i need the user to enter the date, and then for each Park - the attendance. then hit the button or enter - and there will be five new rows in the attendance table. any help would...

very strange - i lifted this code from ozgrid site (thank you, ozgrid, and your long term member PCI) - Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If (Target.Address = "$A$1") Then Cells(2, 2) = Cells(2, 2) + 1 ' Your Code...

hi. i am looking for a very very simple and light excel chess board, and surprisingly can not find anything online (i thought everything has been done and tried on the world wide web by now). i am envisioning an 8x8 grid with white and gray squares and movable pictures of pieces, that's all. i...

hi. this forum is not exactly the place to post this question, as i'll be working mostly in SPSS and possibly R, but i thought i'll give it a shot anyway. i have a computer with 2.4GHz Pentium 4 and 1G of RAM. i will soon need to work on a large dataset, let's say 100 million records, shipped...

it's probably trivial, but my brain is boiling by now.. i am trying to offset the range to the right using the following - LastInsp = WorksheetFunction.Match(1, Range("EB" & r & ":EY" & r).Offset(0, c), 0) where 'c' changes from 0 to n as i go through the table. my problem is that it ADDS n...

is it possible? if i just need say a couple of numbers from a website?.. Excel Help has something on the subject, here (third topic from the top, i assume) - http://office.microsoft.com/en-us/excel/HP051995161033.aspx but whenever i click on 'Browse the Web' or 'Bookmark', i get an error...