# ron

1. ### Simple Formula in Excel?

Hi, I need to pull a column from a dynamic data source based off one unique id(Math). Can someone help with a formula? I need to pull all names associated with the unique id onto another sheet. In a listed column. Example below: Data Source: <tbody> Name Class Ron Math Amy Science...
2. ### Automatic conversion of the currency

Hello! I have a table to be filled in with the prices of some products from different offers. Some products are acquired in the Euro currency and the others in the RON currency. My question is if is any possibility (macros, formulas) so that when I insert the value expressed in one currency...
3. ### Creating PDF On Mac: Multiple Sheet Orientation

I am attempting to create a PDF including several sheets from a Mac. (I am a PC user, but am doing this for a client who is Macs.) I referenced Ron de Bruin excellent post on the subject (https://www.rondebruin.nl/mac/mac005.htm), but there is one thing that is not working. The workbook that...
4. ### Limiting Validation Selections with VLOOKUP Data

So trying to build a spreadsheet for my daughter for a game she got for Christmas. Each card has a value 1-3. I can build the data validation and I have the VLOOKUP correct, but I'm trying to figure out how to make it to where she can only select the number of things that the card value is...
5. ### Meaning of some words ?

In part of my print macro, I have this ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1, Collate _ :=True, IgnorePrintAreas:=False Now what does IgnorePrintAreas:= False mean please? where can I find what all of these mean? Ron
6. ### this ones to complex for me

Sheet 1 holds all the information. Sheet 2 is going to be a kind of chart that I want to be auto created. on Sheet 1, Column A is the names, Column B is the Column # on sheet 2, Column C is the starting row # on sheet 2, Column D is the amount of times I want the name to be repeated...
7. ### Delete row if a specific value exist (VBA)

hello i'm using code based on Ron de Bruin's site I want to delete row/s if a specific value exist on either 2 columns Basically, I want to delete value 1 or 2 on column "A" and "955.46*" on column "D" i'm getting run time error '424' what I'm doing wrong?? (line "If Not IsError(.Value)...
8. ### Require formula

Hello, I have data in rows I need a max formula for the last 12 consecutive months.Formula should calculate value more than zero and the calculation should start from right. Formula result should show For RON its 24 & Jude its 9. <tbody> J F M A M J J A S O N D J F M A M J J A S O N D J F...
9. ### Require Macro

Hello, I need a simple macro code for the below In Column "L" I have "TRUE" & "FALSE" . I need a macro where it should insert a new row below every "TRUE" value. Thanks, Ron...
10. ### Formula help

Hello, I have a below data in columns <tbody> ron 4 shawn 3 max 8 jack 2 rex 1 swan 12 </tbody> The next column I need a output showing the maximum. example - in the 1st row the maximum number is 8 but I need the ouput as max, same with the 2nd row, maximum is 12 and I need...

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...