[mso] Excel Formula question
- From: Dallas Stearns <dallas_1973@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 12 Jul 2007 10:52:05 -0500
I save all the MSO emails- just so I can try to go back and reference a sub=
ject. However I'm having a HECK of a time trying to get Excel to do this..=
.
I have a product list for my company. I have 400 or so rows of products. =
I am trying to make a spreadsheet for my sales force to be competitive in t=
he field by creating a sheet that will have the cost of the item as well as=
4 different pricing structures (I.e.. one at 19% markup, one at 25% markup=
, one at 29% and one at 32%) =20
I know how to make the formula for each individual row- I'm asking is there=
a way to make a formula and have a shortcut- such as a copy and paste type=
of thing- but with it being able to reflect the new row number without hav=
ing to type anything in? I guess kind of like a macro of some sort- but I =
have no clue how to set it up. =20
I don't need help with the formula- I need help with the numbering of each =
formula- so that it reflects the correct row. Anyone know how to do this?
thanks in advanced!
Dallas Stearns
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
