Hello Guys,

I am struggling to get one formula right in my assignment.
In what if>data table, how do we use a formula as our reference cell?

Please check attached image, the annual operating cost formula is =C4*12+C5+C6+C7+C10*C8
but when using data table when I use as cell reference the cell I created with this formula, it returns in the same value for all table.

Please assist.

Regards,
Mahomed Ramiz

Simple Question...

I know and understand VBA in Excel. VB 2010 and Express have more control capability. Can Visual Basic 2010 or 2010 Express be used to control Excel in the similar manner as the on board VBA that comes with Excel?

thanks
tex

I have 31 sheets in a single excel file, each one has these follow information i want: date and value, those information are located in the same place in each sheet, for example, sheet_1 A1 has a date value and sheet_2 A1 too.I want to create a graphic with these information, date on the horizontal axis and values from each date on the vertical axis. Can you help me?

I currently have a herd of cows that get fed a range of different feeds at different levels daily the amount of feed is calculated daily using excel.
What I would like to do is keep a record of how much was fed on what day. I would also like to be able to put in current inventory levels as well as deliveries.
The database would then take current levels minus the days feed to give me what's left.

hi
i need help in creating formula

lets suppose a cell A6 have a date in it. and cell A7 have some number

in cell A8 i want to insert a formula that tell me if A6 have previous date and A7 is empty then A8 show "argent" in red color. if A7 have number then it shows "paid"
if date is today and the A7 is empty then A8 show "Due Today". if A7 have a number then "paid"
if the date is in future then then it shows "due Later"

Thank you

Hi

actually i need user groups, thats consits team name and users under this team.
there may be any number of teams and users,
the idea is, when i click on team name, the users under that team should appear and vice versa..

if u can help me this, im happy...
thank you

Hi
can any one help me to get the data in groups in user form,
like i have group1- in that we are having subgroups, like gp1-subgrp1, gp1-subgrp2, .. like this.
when we click on group1, the subgroups should appear and when we click again subgroups should hide..
like we can have grop2 and group3 , .. so on..

i can acheive by this treeview concept, but i need in any other way.. so pls help me in this..
thank you

I'm trying to create a list of bough-out items for various assemblies I'm making from week to week. These assemblies are called AA, AB, AC, etc through to ZZ, so as you can imagine there are quite alot. I do not use the same assemblies each week, so no week is the same. Each assembly has between 1 & 12 bough-out items per assembly, some of which are common to other assemblies. So what I'm trying to do is type into an excel spreadsheet which assemblies I want next week inorder to get a full list of bough-out items for that week.

Hi,
I have a Cell Value "SG1+PA20-0328-01 D PCBA,15"DISP,5WIRE". How can i just copy in a new cell a value which starts after '+' and ends before first space. (PA20-0328-01).
Thank you...

hi. I am trying to solve non linear equations using Gauss siedel itterations. Somehow, the code taking too long to run. please advise . attached is my following code

Option Explicit
Sub crossisedel()

Dim y(0 To 10, 1 To 2) As Variant
Dim x(0 To 10, 1 To 2) As Variant
Dim Q(0 To 10, 1 To 2) As Variant
Dim ff(10), fp(10), pr(10), P(2), pf(10), counter, im1, retentate(10), fr(10), theta, pp(10), i, j As Double

Dim alpha, area, currentcell, areaperstage, nostages, nocomponents, errmax, maxItteration, Err1, Err2, Err3 As Long

currentcell = 5
area = 1000

I have data in a table, and I want to repeat the table below, but with one of the columns sorted, and all the other entries on each side of it automatically sorted with it. In the attached example I would like to sort Column C in descending order, but the other columns need to sort with it. I need to use a formula, I can't use the sort function because I want the data sorted in a seperate location to the source data.

Thanks

Hi,

I have put together a xlsm that takes input from four tables (containing 1 column and 8 rows) on the input page and copies the data into separate sheets (in the same workbook) to keep a track of the data. It knows to copy the data to the next free row in the "data collecting" sheets and to then clear the forms on the frontpage/input page.

What I am trying to do is to get the input page to be on the web, is this possible?

I need excel formula to fill one table from 2 other tables in excel sheet.

Suppose we have two tables: table1(id,name), table2(id,date). I need to fill third table MyTable(id,name,date) from data in table1 and table2 based on matching IDs on these tables.

VLOOKUP doesn't help because this accepts one item as a searching key, I need function which accepts array of data as a searching key (list of IDs in my case).

Does someone know what formula to use?
Thanks!

I have a workbook with some code inside of it. When I turn off Autofilter after using the buttons in the top left of the sheet to filter by cell color all of the text fields on the entire sheet are moving to A1 on top of each other. I have no idea why this is happening nor is it throwing an error. I uploaded the sheet here www.justinvalinski.com/newTest.xlsm for further review. I tried uploading on this site but the file is too large to upload. This one is just perplexing so any advice or if you know of a fix PLEASE let me know as I've been staring this one down for quite some time now.

Olympus Tours (OT) Programming Project
R: 6/15/12 3 pm dd
Assume you have just been hired by Olympus Tours (OT), a bus-rental company located
in Orem, Utah. OT provides busses for groupssuch as schools, family reunions, travel
clubs, etc. The smallest group OT will bus is 20 people and the largest group is 120
people. If the user enters the number of users as less than 20 or more than 120 display
“Enter a number of people between 20 and 120” on the screen.
Two types of busses are available for use: small busses (25 maximum riders per bus) and

Hi,

I have to convert the first to the second program (attached image), but i don't know how to do this

Attached excel file: the first sheet is the first program which is correct (i think), the second sheet is a failed attempt to write the second program.

Can somebody please help me out?

Gilles

I found a web site for VBA code to convert currency to words, but its not in the format I want (http://support.microsoft.com/kb/213360)

e.g. 123.45 is converted to "One Hundred Twenty Three Dollars And Forty Five Cents", how do I change it to appear as "Dollars Hundred Twenty Three And Cents Forty Five only"?

I looked at other websites and all of them have similar code to the one I found:(

Hope someone here can help me with this, thank you.

Hi excel experts

Please help with vlookup:

In colA which is my vlookup value, I have a name and surname, there is no space or character seperating them e.g JohnSMITH [so cant do text to columns].
Then I have the table, with peoples names, only this time the format of the names are different. The name has the initials and the surname with spaces eg J Smith.

How can I design a vlookup or work around this problem

Many Thanks

Dear ppl

Can you please help we out. From the two columns below you can see that one columns represents a Currency and the second column Amount. I would like to total for a Single Currency the Sum of all +ve Amounts and Sum of all Negative Amounts.

-----------------------------
Current Data File
-----------------------------

GBP 161.41
GBP 22.58
GBP 24.07
GBP 29,531.41
GBP 16,912.67
GBP 1,602.32
GBP 200
GBP -11345
GBP 541
GBP -41,101.28
GBP 23035
GBP 329,811.79
JPY -423,898.81
JPY -4,135.45
SAR -42558
SAR 89045
SDD -20,444.02
USD 7,024.77
USD 10
USD 310.23

Hi, I hope someone will be able to help with my question.

I have been trying to find a VBA code but have been unsuccessfull

on the attached spreadsheet i would like thin information from 3 different cells to show in one particular cell depending on a selection that a user chooses in another cell.

this is affectively what i would like the code to do, but i have been struggling to get anything to work.

if cell B5 = TO then D3=C19
else if B5 = MSU then D3=C13
else if B5 = 2ND Stage then D3=C25

any help would be greatly appreciated

thanks

Anthony

Hi Guys,

Unsure if this is possible so here goes:

Total value in Cell H9

1st Target value in cell I9 (If H9 is =>I9 but 2nd Target value in cell J9 (If H9 is=>J9 but 3rd Target value in cell K9 (If H9 is=>K9 but 4th Target value in cell L9 (If H9 is=>L9, display text “extra mile”

In cell G the target achieved to display as “text” (depending on value reached in Cell H9, “not achieved, achieved, exceeded or extra mile”.

I hope this makes sense, apologies if not.

Look for a macro to perform conditional formatting of cells within a range(ex. fill color or bold) that contain closest value to a multiple of a given number. Ex. (for multiples of 100): 88, 97, 105, 170, 188, 210, 277, 294, 303......

How can I upload test questions using Excel?

Hello,

This is my first post and really hoping someone can shed some light on this problem.
I have a Pivot running on an Excel 2007 spreadsheet using the 1904 date system as it deals with negative times.
The pivot works fine on my computer per top screenshot

When a colleague opens the spreadsheet and updates the Pivot it gives out some ridiculous figures (second screenshot). I can only imagine the problem lies in the use of the 1904 date system or some options that I have enabled but my colleague has not.

Can anybody help!!!

Thanks
Martyn

Hey I have this rule which highlights duplicates in a row in different colors so if you have a row that is

1
1
1
2
2
3
1
3

All the one's will be blue 2's red and 1's white. Currently the rule below only works on column A. All my columns have headers, and I need it to instead of working on column A work on the columns with header names I choose.
Anyone have any idea how this can be accomplished??

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rng As Range, Dn As Range
Dim K
Dim col
Dim c As Integer
If Target.Column = 1 Then

Hi All,

Is any body could help me.. ?

I have 10 variables name in a FORM, for example : Prd1, Prd2, Prd3, Prd4.....Prd10
To make calculation or adding value for all variables, is there any way to write the syntac using the FOR ... NEXT ?

For Example :

for i=1 to 10
Prd & i.value = i
next i

Regards'
AqieqS

See attached for worksheet functions (non vba) approach

hi
i have a public sub in a worksheet "a" :

public sub ABC()
''blabla bla
end sub

in the same workbook i have a modal userform that on clicking one of its buttons - calls that public sub in the worksheet.

now, calling like this
worksheets("a").ABC
fails with an error (dont remember which)

but if i write :
thisworkbook.worksheets("a").ABC
- well, that's fine.......

why ?
the sub is public and in the same workbook where the call comes from.

Here's a VBA solution... Hope it delivers what you're after

Nick

In the tutorial "Teach Yourself Excel Lesson 10 - Format Data" while formatting date column, point-3 says "Press CTRL + # (useful shortcut for formatting dates" but CTRL + # is working as shortcut for italics on or off.

Please suggest on this.

Thanks & Regards
KumarSreenivas A