Search results for query: *

I was able to figure it out with the solution below. Hopefully someone will find it useful. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 'Range of Names If Not Intersect(Target, Range("B2:B400")) Is Nothing Then Cancel = True '"N2" is a cell...

Hello all, I have an Excel problem that I need help with. Imagine a Fantasy Football Draft using Excel. You have a column of player names and a column for the "Pick Number" or the number that the player got chosen. 1 Adrian Peterson 2 Le'Veon Bell 4 Jamaal Charles 3 Eddie Lacy How could I...

Hi Duane. That works perfectly. You learn something new every day. Thank you and have a Happy New Year! TommyP

Hi All and Happy Holidaze, I'm stumped. I am using a date serial formula to get current year, prior month GP%. Some of my sales and cogs have 0.00 and Access gives me the old division by zero error. I cannot figure out how/where to insert an iif statement so the query runs. Here is what my...

Just click on the Grey Cell that shows the columns letter. This highlights the entire column and limits the find and replace option to just this column.

Why not use CTRL-~ (Control + Tilde) This shows the formulas, not the results.

All Excellent solutions. Thank you all.

I am not quite sure if this can be done, but here goes. I have two columns F and G that I use to compare cell data. Example formula in Column F =B1=D1. Column G would have formula =C1=E1. In column A I am trying to figure out a formula to do display the words "ADD", "Update" or "Do Nothing"...

Sort the spreadsheet by the column you'd like to check for duplicates. For this example lets say it's column A. In cell B1 type this formula: =A1=A2 If they are equal the formula returns TRUE, if not equal it returns FALSE. If you want to delete the duplicates then copy your formulas in column...

Write your formula and then copy it to the next column. Then highlight the cell/column that you want to show the formula in and do a find/replace to change the = to '=. This way the formula will display as text. You may have to anchor your formula so the cell reference does not shift...

With your original spreadsheet open, click on the icon to create a new spreadsheet. Usually this would be named Book2, book3 etc. Click "Window" from the menu and select your original spreadsheet from the bottom choices. Right click on the worksheet you want to copy to Book2. Select "Move or...

You could always Winzip it with a PW until you need it again.

Hi all, If I try to load a csv file and it contains a number like 1E123 excel treats it as scientific notation. Is it possible to change Excel's default cell format "Text" instead of "General"? TIA TommyP

Hi All. I cannot figure this one out and was wondering if anyone knows if this is possible. Scenario: Multiple vendors with many materials in a table. Vendor Material 1 A 1 B 1 C 2 X 2 Y 3 Z Is it possible to export vendor ones materials to...

Here is the response I received from Yahoo regarding what ports they use. Basic Connection: Protocol: TCP or HTTP Servers: - scs.msg.yahoo.com - scsa.msg.yahoo.com - scsb.msg.yahoo.com - scsc.msg.yahoo.com Port: 20,23,25,80,119,5050,8001,8002 Webcam Connection: Protocol: TCP...

Hi All. I am on a quest to fing out how to transfer files with a BESFR41 and Yahoo Messenger. No matter where I look on the internet I cannot find the port# that Yahoo uses for this. Or is there a different setting I should be looking at? Tommy P

You could also create a standard "Duplicate" query and un-check the "Show" checkbox in the "Count" column.

Correction, the problem is back. When I broke the relationship between the two tables in the query and re-established them again, the problem went away. For how long I do not know...

Here is my solution to the problem I initially described. I did not have any spelling errors and no other queries were being run. All I did was to break the link betwen two tables and re-create it. Now the query runs like it should. Now why would access behave normally after breaking a link...

willr, ignore the last post. I will look everywhere! Thanks for your suggestions!