# Search:

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

Page 1 of 6 1

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

by RalphA
Replies
4
Views
355

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

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. ## Thread: How To Detect When # Of Characters In One Column Does Not Match # Defined In Other Column

by RalphA
Replies
12
Views
717

### Re: How To Detect When # Of Characters In One Column Does Not Match # Defined In Other Column

Well, good luck!

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. ## Thread: How To Detect When # Of Characters In One Column Does Not Match # Defined In Other Column

by RalphA
Replies
12
Views
717

### 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. ## Thread: Copy & paste from specific columns from one workbook to another

by RalphA
Replies
4
Views
355

### 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. ## Thread: Copy and Paste from other Workbooks

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

by RalphA
Replies
9
Views
692

Try this:
8. ## Thread: Check if data is 10% above or below rolling 3 weeks average

by RalphA
Replies
3
Views
377

### 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))

...

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!

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. ## Thread: Speed up SUMPRODUCT formulae - very very slow spreadsheet HELP NEEDED!!

by RalphA
Replies
1
Views
520

### 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. ## Thread: Copy data from one sheet to another depending on date

by RalphA
Replies
1
Views
244

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

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. ## Thread: Is it possible to print JUST the odd numbered pages from multiple tabs?

by RalphA
Replies
2
Views
368

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

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

by RalphA
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. ## Thread: Crosshair on a surface contour chart

by RalphA
Replies
1
Views
504

### Re: Crosshair on a surface contour chart

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

by RalphA
Replies
8
Views
2,556

### 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. ## Thread: Create shortcut to an OPEN file

by RalphA
Replies
5
Views
1,514

### Re: Create shortcut to an OPEN file

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. ## Thread: Create shortcut to an OPEN file

by RalphA
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. ## Thread: Auto calculate formula in blank cell

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

22. ## Thread: Using Dates as Ranges in SUMIFS

by RalphA
Replies
5
Views
985

### Re: Using Dates as Ranges in SUMIFS

by RalphA
Replies
4
Views
433

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

by RalphA
Replies
5
Views
985

by RalphA
Replies
4
Views
433