Search:

Type: Posts; User: RalphA; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.13 seconds.

  1. Re: Copy & paste from specific columns from one workbook to another

    Say, alvinwlh, is your sentence,
    If Not c Is Nothing Then
    the equivalent of
    If c <> "" and c <> 0 Then

    I'm just curious, as I don't really do VBA, only BASIC and QuickBASIC.
  2. Re: How To Detect When # Of Characters In One Column Does Not Match # Defined In Other Column

    Well, good luck!
  3. Thread: balancing data?

    by RalphA
    Replies
    1
    Views
    279

    Re: balancing data?

    I would say that the stating point is to add the numbers ("sum of 16"), then divide by r, getting an answer ("sum of 4"). Now, each of the four groups you select must equal the "sum of 4". ...
  4. Re: How To Detect When # Of Characters In One Column Does Not Match # Defined In Other Column

    Here's one way:
    Highlight J3:J300 (assuming row 300 is the last row you will use)
    click on Format, Conditional formatting..., select "Formula is:", and enter:
    =(B3<>"")*(B3<>0)*(LEN(J3)<>B3)...
  5. Re: Copy & paste from specific columns from one workbook to another

    See my answer to yournext post. However, even thought it's an easy solution for your problem, it doesn't answer your request for code. Perhaps you can use the logic in my solution to produce your...
  6. Replies
    1
    Views
    345

    Re: Copy and Paste from other Workbooks

    To me, the easiest thing to do is to simply copy the source file to the resulting file, then, delete columns F-R and all columns following T. Then, sort the first column, delete all the rows above...
  7. Replies
    9
    Views
    692

    Re: Conditonal formatting

    Try this:
    http://www.mrexcel.com/forum/showthread.php?t=350875&highlight=conditional+formats
  8. Re: Check if data is 10% above or below rolling 3 weeks average

    I entered this formula,

    =OR(B23>(INDIRECT("B"&ROW()-21)+INDIRECT("B"&ROW()-14)+INDIRECT("B"&ROW()-7))/3*1.1,(B23<(INDIRECT("B"&ROW()-21)+INDIRECT("B"&ROW()-14)+INDIRECT("B"&ROW()-7))/3*0.8))

    ...
  9. Thread: Starting macros

    by RalphA
    Replies
    9
    Views
    357

    Re: Starting macros

    Now, that requires mor knowledge of VBA than Ihaave! Hopefully, someone else will pick this up from here. good luck!
  10. Thread: #NUM error

    by RalphA
    Replies
    3
    Views
    361

    Re: #NUM error

    The Excel Help shows:
    The #NUM! error value occurs when a problem occurs with a number in a formula or function.

    Have you checked out the above?
  11. Re: Speed up SUMPRODUCT formulae - very very slow spreadsheet HELP NEEDED!!

    The first thing to do is to change the 10000 and 25000 to the number of actual rows, which you state to be 3365.

    If the calculating time is still too large, post back here.
  12. Re: Copy data from one sheet to another depending on date

    This is one way, using formulas:
    Assuming your data starts on Sheet1, cell A2:
    On Shhet2, cell A2, enter: =IF(AND(Sheet1!$A2>0,TODAY()>=Sheet1!$A2),Sheet1!A2,"")
    and copyto the range A2:E500,...
  13. Thread: Starting macros

    by RalphA
    Replies
    9
    Views
    357

    Re: Starting macros

    Creat the code you need, using Tools, Macro, Record new Macro. Then, click on Tools, Macro, Macros..,. choose the macro, and click on Edit to change it. Or, go to a sheet tab, do a right click,...
  14. Re: Is it possible to print JUST the odd numbered pages from multiple tabs?

    I have seen a selection choice of "Print odd pages only", "Print even pages onlky", but, I don't find such choices in my present printer. I am almost 100% sure that this choice is contained in the...
  15. Replies
    2
    Views
    482

    Re: Maximum Iterations

    My editing time expired, so, I am posting the follow up.

    Right Click on the sheet tab, choose View Code, then, on the side, select VBAProject, Microsoft Excel Object, and double click on Tis...
  16. Replies
    2
    Views
    482

    Re: Maximum Iterations

    I can't help you on hoiw to maintain the iterations at 9999. But, I can help you with a macro to change that value to 9999, every time you open your workbook. Here's how:

    Click on the Macro...
  17. Replies
    1
    Views
    504

    Re: Crosshair on a surface contour chart

    since you have had on answers to your post, I will volunteer an approach to your problem, which might be totally unsuited!

    Say your data starts in cell A2, and the headings in A11. Insert two...
  18. Re: automate drawing rounded rectangles to circle data

    Jerry:

    Since, apparently, no one has answered your post, may I suggest that you let Excel write your macro, then you can Edit it, copy it, and put it in your code area.

    I hit the Record Macro...
  19. Replies
    5
    Views
    1,514

    Re: Create shortcut to an OPEN file

    EUREKA, I have the answer!

    On any part of your open Excel worksheet, do a Copy. Now, on your Desktop, do a right click, then choose "Create a Shortcut". I could hardly believe how easy it was,...
  20. Replies
    5
    Views
    1,514

    Re: Create shortcut to an OPEN file

    Perhaps this will help.

    Click on Help,Contents and Indes, enter "shortcut", double click on "Creating: (under "shortcuts"), choose "Add a folder or file shortcut to the Favorites folder", and...
  21. Replies
    3
    Views
    937

    Re: Auto calculate formula in blank cell

    Wameld:

    Please forgive me for not answering sooner, but, it seems that Excel has, somehow, cut me off from the automatic emails I used to receive.

    As to your question, without your actual...
  22. Replies
    5
    Views
    985

    Re: Using Dates as Ranges in SUMIFS

    Sorry, I missed reading your "All is well, now" reply. I am happy to know that your problem was resolved that simply.
  23. Replies
    4
    Views
    433

    Re: Unresolved question...help please!!!!!!

    I copied your original formula,
    =LOOKUP($J$32,NS_Tally!V1082:V1360,NS_Tally!W1082:w1360)
    to an Excel spreadsheet, to cell X1082. I noticed two things that may be wrong.

    1. the third part of...
  24. Replies
    5
    Views
    985

    Re: Using Dates as Ranges in SUMIFS

    I went to your original site, and saw your anser to domenic, indicating that all was well! I recommend that ou return to the otiginal thread, and post there, as it always badly received when an...
  25. Replies
    4
    Views
    433

    Re: Unresolved question...help please!!!!!!

    Mark:
    When you merge two or more cells, you have instructed Excel to consier that group of cells as one, namely, the first one in the merged group.
    In your case,wWhen you tell Excel to find...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4