Re: Assign autoformat to a macro
Select your data
Then Format
Then AutoFormat
Then Classic2
Then Click OK
I think this is what you are looking for.
Re: Assign autoformat to a macro
Select your data
Then Format
Then AutoFormat
Then Classic2
Then Click OK
I think this is what you are looking for.
Re: Start Macro X minutes after opening worksheet
This would help me with one of my problems but I was just wondering if there would be a way for the macro to start after the datafeed finished versus the time setting. If the data builds beyond a 2 minute time level or drops in time, the macro could start early or waste time.
Re: Looking up and using formulas from another WS
I am not the best at VBA so hopefully someone else will step up and help.
I will take a look at on Monday morning, sorry I dont have the time over the weekend. If not worked out by Monday I will get right on it. Good Luck
Re: Looking up and using formulas from another WS
So I am playing around with the choose formula
which allows up to 29 values. So here is what I came up with
=CHOOSE(D11,IF(D11<=2,$A11*$B11),IF(D11<=3,$A11*$B11),IF(D11<=4,$A11*$B11),IF(D11<=5,$A11*$B11),IF(D11<=6,$A11*$B11),IF(D11<=7,$A11*$B11),IF(D11<=8,$A11*$B11),IF(D11<=9,$A11*$B11),IF(D11<=10,$A11*$B11),IF(D11<=11,$A11*$B11),IF(D11<=12,$A11*$B11))
This appears to work and using the formula palette is very manageable, So if someone Knows why this wont work (it sounds to easy to me) please let me know.
Re: Looking up and using formulas from another WS
Well you are restricted to 7 so the best way beyond that would be to use vba.
How many are you going to need?
Will this be something you do once, or constanly changes?
Re: newbie vba help
Alt+F11 or right-click on the tab.
You will now be in VB On the left you will see your pages and maybe modules.
click through those to see the code.
Re: Desperate!-covert data in columns to rows and columns with intersection values
Not a God I just figured them out a couble of months ago and now they're my answer to evrything. So have fun! :guitar:
Re: Looking up and using formulas from another WS
Here is the other one you need
=IF(D11<=2,$A11*$B11,IF(D11=3,PI()*$C12^2,IF(D11=4,1/3*PI()*$C13^2*$B13)))
Notice this doent actually import a formula but rather has all the formulas. Drag fill the formula down as needed.
Re: Looking up and using formulas from another WS
I think this what you are looking for the shape
=CHOOSE(D11,'Table 1'!E10,'Table 1'!E11,'Table 1'!E12,'Table 1'!E13)
Re: Desperate!-covert data in columns to rows and columns with intersection values
Have you tried a pivot table?
Re: Textbox to multiple sheets
Thanks willr your code did do it, the problem was in a offset formula in my named range, I got that worked out and the code did the trick, thanks.
Re: Formula Evaluate to Blank if Referenced Cell Blank
No problem, so many people help me out its nice to help somebody else.
Re: Textbox to multiple sheets
Sorry for not better describing but that one box will go to just those two pages. I tried that line of code and it didnt work, I didnt really see anything that named the specific sheet so I edited it to
Range("DateFirstName").Cells(txtRow.Value) = txtFirstName.Value
and
Sheets("Date Info").Range("DateFirstName").Cells(txtRow.Value) = txtFirstName.Value
Neither worked.
Re: Clear Button error
I dont know if that helped out Joe but I appreciate you taking the time to write that out. It helped me understand some much needed information. Thanks iwrk4dedpr :rock:
Re: Textbox to multiple sheets
I want the value placed within range "DateFirstName" on sheet "Date Info".
The txtrow box contains the row value.
The box is located on a user form in sheet "Data" and the values for that page are placed with
Re: Output a range selected by the user
Our apoligies, we realize that you have been looking for two days and are now frustated with us when you did not get your answer within minutes. We realize that since we all volunteer our time to help each other that we should feel guilty. I hope your friend can help when you need two lines of code.
Re: Hiding formulas
Also notice on your formula bar the "="
Click on that and you can select the formula you want to use.
Read through the descriptions and play around with the formulas it will open a whole new world.
Re: Hiding formulas
Put a value in cell a1 like 5
Put this =IF(A1>10,A1,"") in b1
Its broke apart by the commas first is your equation A1 value is greater than 10 then Your answer if True A1 Value Then False ""
Hope that explains it
Re: Hiding formulas
You could use an if formula and make [if answer is zero or less than value egauals "".]
Or select tools>options>and uncheck zero values. But that does the whole page.