Search results for query: *

In the attached, if you go to the Data tab of the ribbon and click the Queries and Connections icon in the Queries and Connections section, a Queries and Connections pane will appear, then if you choose the Queries section of that pane you'll see 5 queries. Only the first 4 are needed. The...

Easy, see attached. However, I have a problem with that, to do with data integrity; The result looks linked because it's in the same block of cells, but these are in fact two independent tables. If you were to sort one, the other wouldn't sort in parallel. It get's worse - if you were to sort...

In the attached, a new table at cell H1 of the Data sheet with the Outcomes column added. You just need to right click a cell in that table and choose Refresh. I've removed the Comments column and annotations from the table on the Table sheet. You can update/extend/amend either or both source...

Ha! No. I cocked up.[rofl] I thought it was to do it the other way round![upsidedown][laughtears] (The only good thing about it then, is that it could be used to check that the correct procedure or formula works properly!) It was good educational though. If I get the inclination I'll try doing...

There'a a lot of referring to the sheet in those macro snippets, it might be worth trying something along these lines (I can't test easily):Dim Rng As Range Set myRng = Range("A1:R" & LastRow) rngVals = myRng.Value For i = 3 To LastRow If (rngVals(i, 4) <> "Broadband Service" And rngVals(i, 4)...

I realise this is 3 weeks late (I'm using your problem as practice), however the attached is your file, with an added table at cell K1 of the Table sheet. This table is essentially a copy of columns A to E of the same sheet with an added column headed Outcome which contains what I hope you're...