Click here to Skip to main content
15,895,084 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Export Excel Formula Pin
Kschuler2-Jun-09 5:59
Kschuler2-Jun-09 5:59 
GeneralRe: Export Excel Formula Pin
ross16642-Jun-09 19:18
ross16642-Jun-09 19:18 
QuestionVB.net: How to update database from datagridview Pin
Roger Rainey2-Jun-09 4:35
Roger Rainey2-Jun-09 4:35 
AnswerRe: VB.net: How to update database from datagridview Pin
Kschuler2-Jun-09 5:45
Kschuler2-Jun-09 5:45 
QuestionRe: VB.net: How to update database from datagridview Pin
JohannNutter22-Jul-09 9:08
JohannNutter22-Jul-09 9:08 
GeneralRe: VB.net: How to update database from datagridview Pin
Kschuler22-Jul-09 9:35
Kschuler22-Jul-09 9:35 
GeneralRe: VB.net: How to update database from datagridview Pin
JohannNutter22-Jul-09 10:26
JohannNutter22-Jul-09 10:26 
QuestionVBA and XL - Is this a Viable Function Request? [modified] Pin
Dalek Dave2-Jun-09 4:18
professionalDalek Dave2-Jun-09 4:18 
In one of the regular Spreadsheets I am asked to do, I need a Column that does a complicated SUMming.

There are a number of columns of data, between 2 and, say, 10 columns (Depending on other factors).
In Each Column there is a set of data such as Land Price, Build Cost Prelims etc. At the Head of Each column is a number representing How Many of Each Type.(The column data is shown for the cost of 1 of each type).

Currently I am having to type in the cell the following...

=($G$5*G8)+($H$5*H8)+($I$5*I8) etc (not too bad with three columns, but if there are 10 or more it takes a while!
(Because of the $'s I can Copy Down with impunity)

So at the end column for each ROW I get a total cost for the project on each of the Parts.


I would like to do away with having to waste my life and that of my keyboard by having a Function that I can put into the Totals Column.

Something like =FACTOREDTOTAL(5,("G5"),6)
This being there are 5 columns of data, locked at G5 for the first column (but moving 1 column along each iteration), starting 6 columns to the left.

Does that all make sense?


OK, I have tried, and tried, I have failed and failed.
I know it must be possible either as a function or as a Macro, but either I am dim or my brain is fried, but has anyone got any pointers to this?

MOD - I can do it as a macro, but I would rather have it as a function!

------------------------------------

"When Belly Full, Chin Hit Chest"
Confucius 502BC

modified on Tuesday, June 2, 2009 10:28 AM

AnswerRe: VBA and XL - Is this a Viable Function Request? Pin
David Mujica2-Jun-09 4:55
David Mujica2-Jun-09 4:55 
GeneralRe: VBA and XL - Is this a Viable Function Request? Pin
Dalek Dave2-Jun-09 5:02
professionalDalek Dave2-Jun-09 5:02 
GeneralUnderstood Pin
David Mujica2-Jun-09 5:15
David Mujica2-Jun-09 5:15 
GeneralRe: Understood Pin
Dalek Dave2-Jun-09 5:23
professionalDalek Dave2-Jun-09 5:23 
Questionrandom access files .net 2005 Pin
vurdmal2-Jun-09 3:22
vurdmal2-Jun-09 3:22 
AnswerRe: random access files .net 2005 Pin
DidiKunz2-Jun-09 3:34
DidiKunz2-Jun-09 3:34 
GeneralRe: random access files .net 2005 Pin
vurdmal2-Jun-09 4:09
vurdmal2-Jun-09 4:09 
GeneralRe: random access files .net 2005 Pin
Jay Royall2-Jun-09 4:40
Jay Royall2-Jun-09 4:40 
GeneralRe: random access files .net 2005 Pin
vurdmal2-Jun-09 5:10
vurdmal2-Jun-09 5:10 
GeneralRe: random access files .net 2005 Pin
Jay Royall2-Jun-09 5:24
Jay Royall2-Jun-09 5:24 
GeneralRe: random access files .net 2005 Pin
vurdmal2-Jun-09 6:26
vurdmal2-Jun-09 6:26 
GeneralRe: random access files .net 2005 Pin
Jay Royall2-Jun-09 6:32
Jay Royall2-Jun-09 6:32 
Questionhow to embed hardware info programmatically to an executable at install time Pin
JayKhatri2-Jun-09 2:06
JayKhatri2-Jun-09 2:06 
AnswerRe: how to embed hardware info programmatically to an executable at install time Pin
DidiKunz2-Jun-09 3:24
DidiKunz2-Jun-09 3:24 
GeneralRe: how to embed hardware info programmatically to an executable at install time Pin
JayKhatri4-Aug-09 4:36
JayKhatri4-Aug-09 4:36 
GeneralRe: how to embed hardware info programmatically to an executable at install time Pin
DidiKunz7-Aug-09 6:47
DidiKunz7-Aug-09 6:47 
Questioninno script Pin
Derberos2-Jun-09 0:58
Derberos2-Jun-09 0:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.