Merging Column Data
 

Another problem has been discovered in my Excel Spreadsheet as I have
a dilemna on utilizing two formulas in one box. For example, I want
column C to automatically pop up a certain number of hours when Column
A has a name inserted into it. However, while doing so I also want
whatever number of hours pops up for Column C, I want to subtract
whatever is in Column B from it. Is there any possible way to get this
done, and sorry if this was a little confusing, not really sure how to
describe it other than this.

Thanks!

Merging Column Data
 

Looking back to the response to your previous query, I would offer a
modification to one of the lines as follows:

Target.Offset(, 2).Value = 0 - Target.Offset(, 1).Value

--
Ian
--
"Ahh, Excel's Tough" wrote in message
oups.com...
Another problem has been discovered in my Excel Spreadsheet as I have
a dilemna on utilizing two formulas in one box. For example, I want
column C to automatically pop up a certain number of hours when Column
A has a name inserted into it. However, while doing so I also want
whatever number of hours pops up for Column C, I want to subtract
whatever is in Column B from it. Is there any possible way to get this
done, and sorry if this was a little confusing, not really sure how to
describe it other than this.

Thanks!

Merging Column Data
 

On Jun 29, 2:19 pm, "Ian" wrote:
Looking back to the response to your previous query, I would offer a
modification to one of the lines as follows:

Target.Offset(, 2).Value = 0 - Target.Offset(, 1).Value

--
Ian
--
"Ahh, Excel's Tough" wrote in ooglegroups.com...



Another problem has been discovered in my Excel Spreadsheet as I have
a dilemna on utilizing two formulas in one box. For example, I want
column C to automatically pop up a certain number of hours when Column
A has a name inserted into it. However, while doing so I also want
whatever number of hours pops up for Column C, I want to subtract
whatever is in Column B from it. Is there any possible way to get this
done, and sorry if this was a little confusing, not really sure how to
describe it other than this.

Thanks!- Hide quoted text -

- Show quoted text -

Perfect solution, Ian, I was wondering if it was possible to also
clear out Column C when there is nothing in Column A, for example when
I clear out the name in Column A, Column C will clear out whatever
number of hours is still in Column C and return to a blank box.

Merging Column Data
 

On Jun 29, 2:36 pm, "Ahh, Excel's Tough"
wrote:
On Jun 29, 2:19 pm, "Ian" wrote:





Looking back to the response to your previous query, I would offer a
modification to one of the lines as follows:

Target.Offset(, 2).Value = 0 - Target.Offset(, 1).Value

--
Ian
--
"Ahh, Excel's Tough" wrote in ooglegroups.com...

Another problem has been discovered in my Excel Spreadsheet as I have
a dilemna on utilizing two formulas in one box. For example, I want
column C to automatically pop up a certain number of hours when Column
A has a name inserted into it. However, while doing so I also want
whatever number of hours pops up for Column C, I want to subtract
whatever is in Column B from it. Is there any possible way to get this
done, and sorry if this was a little confusing, not really sure how to
describe it other than this.

Thanks!- Hide quoted text -

- Show quoted text -

Perfect solution, Ian, I was wondering if it was possible to also
clear out Column C when there is nothing in Column A, for example when
I clear out the name in Column A, Column C will clear out whatever
number of hours is still in Column C and return to a blank box.- Hide quoted text -

- Show quoted text -

Also, I just realized that Column C does not subtract Column B's data
when there is something in Column A.

Merging Column Data
 

Your last comment suggets that you are amending the value in column B after
entering data in column A.
Your previous requests suggest that when data is entered in column A, you
need column C=0 unless there is a number in column B in which case C=-B.
Does this have to be done in code, or would a formula do instead?
=IF(A1="","",-B1)

--
Ian
--
"Ahh, Excel's Tough" wrote in message
ups.com...
On Jun 29, 2:36 pm, "Ahh, Excel's Tough"
wrote:
On Jun 29, 2:19 pm, "Ian" wrote:





Looking back to the response to your previous query, I would offer a
modification to one of the lines as follows:

Target.Offset(, 2).Value = 0 - Target.Offset(, 1).Value

--
Ian
--
"Ahh, Excel's Tough" wrote in
ooglegroups.com...

Another problem has been discovered in my Excel Spreadsheet as I have
a dilemna on utilizing two formulas in one box. For example, I want
column C to automatically pop up a certain number of hours when
Column
A has a name inserted into it. However, while doing so I also want
whatever number of hours pops up for Column C, I want to subtract
whatever is in Column B from it. Is there any possible way to get
this
done, and sorry if this was a little confusing, not really sure how
to
describe it other than this.

Thanks!- Hide quoted text -

- Show quoted text -

Perfect solution, Ian, I was wondering if it was possible to also
clear out Column C when there is nothing in Column A, for example when
I clear out the name in Column A, Column C will clear out whatever
number of hours is still in Column C and return to a blank box.- Hide
quoted text -

- Show quoted text -

Also, I just realized that Column C does not subtract Column B's data
when there is something in Column A.

Merging Column Data
 

On Jun 30, 3:55 am, "Ian" wrote:
Your last comment suggets that you are amending the value in column B after
entering data in column A.
Your previous requests suggest that when data is entered in column A, you
need column C=0 unless there is a number in column B in which case C=-B.
Does this have to be done in code, or would a formula do instead?
=IF(A1="","",-B1)

--
Ian
--
"Ahh, Excel's Tough" wrote in oglegroups.com...



On Jun 29, 2:36 pm, "Ahh, Excel's Tough"
wrote:
On Jun 29, 2:19 pm, "Ian" wrote:

Looking back to the response to your previous query, I would offer a
modification to one of the lines as follows:

Target.Offset(, 2).Value = 0 - Target.Offset(, 1).Value

--
Ian
--
"Ahh, Excel's Tough" wrote in
ooglegroups.com...

Another problem has been discovered in my Excel Spreadsheet as I have
a dilemna on utilizing two formulas in one box. For example, I want
column C to automatically pop up a certain number of hours when
Column
A has a name inserted into it. However, while doing so I also want
whatever number of hours pops up for Column C, I want to subtract
whatever is in Column B from it. Is there any possible way to get
this
done, and sorry if this was a little confusing, not really sure how
to
describe it other than this.

Thanks!- Hide quoted text -

- Show quoted text -

Perfect solution, Ian, I was wondering if it was possible to also
clear out Column C when there is nothing in Column A, for example when
I clear out the name in Column A, Column C will clear out whatever
number of hours is still in Column C and return to a blank box.- Hide
quoted text -

- Show quoted text -

Also, I just realized that Column C does not subtract Column B's data
when there is something in Column A.- Hide quoted text -

- Show quoted text -

Let me see if I can clear this up a bit, as I've gotten a bit confused
myself, So I'm forming a type of timecard that has the user inserting
names inside column A. I want a value to come up in Column C
automatically when a name is inserted into Column A, I would like this
value to come up from data from another sheet called Lookup Sheet at
this point in time. I want something similar to C2 =
B2FromLookupSheet*8-B:B. Is there an Excel formula for this type, I'm
not sure, I am fairly new to Excel and have only begun to tinker with
macros and formulas.

Merging Column Data
 

On Jul 2, 1:37 pm, "Ahh, Excel's Tough"
wrote:
On Jun 30, 3:55 am, "Ian" wrote:





Your last comment suggets that you are amending the value in column B after
entering data in column A.
Your previous requests suggest that when data is entered in column A, you
need column C=0 unless there is a number in column B in which case C=-B.
Does this have to be done in code, or would a formula do instead?
=IF(A1="","",-B1)

--
Ian
--
"Ahh, Excel's Tough" wrote in oglegroups.com...

On Jun 29, 2:36 pm, "Ahh, Excel's Tough"
wrote:
On Jun 29, 2:19 pm, "Ian" wrote:

Looking back to the response to your previous query, I would offer a
modification to one of the lines as follows:

Target.Offset(, 2).Value = 0 - Target.Offset(, 1).Value

--
Ian
--
"Ahh, Excel's Tough" wrote in
ooglegroups.com...

Another problem has been discovered in my Excel Spreadsheet as I have
a dilemna on utilizing two formulas in one box. For example, I want
column C to automatically pop up a certain number of hours when
Column
A has a name inserted into it. However, while doing so I also want
whatever number of hours pops up for Column C, I want to subtract
whatever is in Column B from it. Is there any possible way to get
this
done, and sorry if this was a little confusing, not really sure how
to
describe it other than this.

Thanks!- Hide quoted text -

- Show quoted text -

Perfect solution, Ian, I was wondering if it was possible to also
clear out Column C when there is nothing in Column A, for example when
I clear out the name in Column A, Column C will clear out whatever
number of hours is still in Column C and return to a blank box.- Hide
quoted text -

- Show quoted text -

Also, I just realized that Column C does not subtract Column B's data
when there is something in Column A.- Hide quoted text -

- Show quoted text -

Let me see if I can clear this up a bit, as I've gotten a bit confused
myself, So I'm forming a type of timecard that has the user inserting
names inside column A. I want a value to come up in Column C
automatically when a name is inserted into Column A, I would like this
value to come up from data from another sheet called Lookup Sheet at
this point in time. I want something similar to C2 =
B2FromLookupSheet*8-B:B. Is there an Excel formula for this type, I'm
not sure, I am fairly new to Excel and have only begun to tinker with
macros and formulas.- Hide quoted text -

- Show quoted text -

Also, one of the main problems I seem to be facing is having two
formulas sit in one box without one clearing the other, however if
there is a formula that will populate it with something like
C2=B2FromLookupSheet*8-B:B, I'd be incredibly grateful. Thanks for
sticking with me here Ian!

Merging Column Data
 

I'm not sure exactly what you require. The first part of your "formula"
makes sense, but I don't know what you're trying to achieve with the -B:B
part.

As for the rest, try this in C2:
=IF(A2="","",'Lookup Sheet'!B2*8)


--
Ian
--
"Ahh, Excel's Tough" wrote in message
oups.com...
On Jul 2, 1:37 pm, "Ahh, Excel's Tough"
wrote:
On Jun 30, 3:55 am, "Ian" wrote:





Your last comment suggets that you are amending the value in column B
after
entering data in column A.
Your previous requests suggest that when data is entered in column A,
you
need column C=0 unless there is a number in column B in which case
C=-B.
Does this have to be done in code, or would a formula do instead?
=IF(A1="","",-B1)

--
Ian
--
"Ahh, Excel's Tough" wrote in
oglegroups.com...

On Jun 29, 2:36 pm, "Ahh, Excel's Tough"
wrote:
On Jun 29, 2:19 pm, "Ian" wrote:

Looking back to the response to your previous query, I would offer
a
modification to one of the lines as follows:

Target.Offset(, 2).Value = 0 - Target.Offset(, 1).Value

--
Ian
--
"Ahh, Excel's Tough" wrote in
ooglegroups.com...

Another problem has been discovered in my Excel Spreadsheet as I
have
a dilemna on utilizing two formulas in one box. For example, I
want
column C to automatically pop up a certain number of hours when
Column
A has a name inserted into it. However, while doing so I also
want
whatever number of hours pops up for Column C, I want to
subtract
whatever is in Column B from it. Is there any possible way to
get
this
done, and sorry if this was a little confusing, not really sure
how
to
describe it other than this.

Thanks!- Hide quoted text -

- Show quoted text -

Perfect solution, Ian, I was wondering if it was possible to also
clear out Column C when there is nothing in Column A, for example
when
I clear out the name in Column A, Column C will clear out whatever
number of hours is still in Column C and return to a blank box.-
Hide
quoted text -

- Show quoted text -

Also, I just realized that Column C does not subtract Column B's data
when there is something in Column A.- Hide quoted text -

- Show quoted text -

Let me see if I can clear this up a bit, as I've gotten a bit confused
myself, So I'm forming a type of timecard that has the user inserting
names inside column A. I want a value to come up in Column C
automatically when a name is inserted into Column A, I would like this
value to come up from data from another sheet called Lookup Sheet at
this point in time. I want something similar to C2 =
B2FromLookupSheet*8-B:B. Is there an Excel formula for this type, I'm
not sure, I am fairly new to Excel and have only begun to tinker with
macros and formulas.- Hide quoted text -

- Show quoted text -

Also, one of the main problems I seem to be facing is having two
formulas sit in one box without one clearing the other, however if
there is a formula that will populate it with something like
C2=B2FromLookupSheet*8-B:B, I'd be incredibly grateful. Thanks for
sticking with me here Ian!