copy a row of data to a column in another workbook?
I am trying to get the data i enter into my charity subscription workbook, to
be automatically updated in my gift aid register (workbook) so that i do not
have to input twice. The data is entered into the subs register in rows and
the gift aid register is entered in columns. Any ideas would be appreciated.
a formula like this in your gift aid register wb will draw
the data over from your charity subscription wb.
I don't know your file paths so you will have to change it
to fit your set up. in the gift aid register wb, put the ...Creating a field to search and enter non duplicate data
I have a team of 15 pople that all work with reference numbers, on occasion
a number has to be sent to a different work group. I've created a spreadsheet
for them to enter the numbers into, but we have been duplicating numbers. I
want to create a field to enter th number into, have the field cross
reference the exsting numbers, and if it does not find a match, enter the
number and sort the list.
I know how to create a custom macro that will accomplish what I want to do,
but I'd prefer a static formula if it's possible.
A formula can not do waht y...Create Multiple Hyperlinks in Excel
I am trying to link two worksheets using hyperlinks. The first
worksheet ( Worksheet1) has a field CompanyCode and contains sales
information . The second worksheet (Worksheet2) has the same field
CompanyCode and all the company address details. The two worksheets
are in exactly the same order.
I would like to create a hyperlink in Worksheet1 linking the
CompanyCode to Worksheet2 and then copy all the hyperlinks by
dragging . Is this possible, or is there another simple way of doing
this. (It has to be simple - I am not too good on macros or VB!)
i have twelve worsheets running on for each month of the year.
how can i extract two or three colums from each one, and put them in a chart.
One option would be to create a 13th "master" worksheet to contain the data
for your chart. You can create cell references to all 12 sheets from the
master sheet. In other words, the master sheet contains a summary range that
is made up of simple formulas that refer to the data in the other 12 sheets.
Build the chart based on that summary range.
"Monty" wro...Using the DLookup function
I have a table that includes a field StartDate. Another table (HOLIDAY) holds
dates announced as Holidays. I am trying to use the Lookup function to see if
my StartDate matches a HolidayDate. I have tried
If Forms!frmAssignment!StartDate = DLookup("HolDate", "HOLIDAY", "HolDate =
" & Me.StartDate) Then.........
Unfortunately, it doesn't run!! (The datatypes throughout are ShortDate).
I've tried the same using the # sign as part of the last section, but still
no joy. Would appreciate any help. Thank you. Andrew
The correct syntax shoul...issue with Workday Function
Subject: issue with Workday Function - not calculating workdays
Date: Thu, 05 Oct 2006 12:23:03 -0000
trying to use the workday function to calculate the number of workdays
from a specific date.
i am trying to calculate the 11th working day for each month.
it works for October, but not november and december 2006.
A1 = 01/10/2006
B1 = 02/11/2006
C1 = 03/12/2006
A2 = WORKDAY(A1,11,Holidays) returns a value of 16/10/2006 which is
B2 = WORKDAY(A1,11,Holidays) returns a value of 16/11/2006 which is
incorrec...how to get same sent items on multiple pc's (exchange)
I run Outlook 2003 and use two different PCs (home and work) to access my
mail which are both set up as microsoft exchange. It is a webmail account at
I love how it works, except that I have this one problem:
When I send a mail from home, it does not appear in the sent items at work
and vice versa. I have been trying to figure it out for a while now, but to
no avail. I think I m missing something simple...
Thanks for reading my post. Any help would be much appreciated!
You have not set the default delivery location your Exchange account then
...Query a non-MS/non-Active Directory LDAP Server
Does anyone know how to query an LDAP server from Access VBA that is not
a Microsoft / Active Directory (AD) server? I have found a lot of stuff
about how to query AD and have succeeded in doing so. But that does not seem
to transfer to the non-MS LDAP server. It gives the error "Automation error"
"There is no such object on the server."
Message posted via AccessMonster.com
Is there a chance that there...Excel Function not Evaluating to a Result
A colleague of mine has a spreadsheet containing a number of formulas which
reference cells in another sheet within the same workbook, so the cells
contain for example
He populates the sheet using VBA code inserting the functions into the
appropriate cells, and on initial creation this works fine and all the cells
show the correct result.
i.e. If the Reference Data sheet at cell A3 contains "Fred Bloggs" then
"Fred Bloggs" is displayed in the cell.
However, if he edits the cell function to change say the !A3 to !A4, th...Formula For Multiple Rows
In Excel 2009 I need to multiply rows 1 through 55 by $0.35. I don't need
any amounts of the rows multiplied by that, just the number of rows (55 x
$.035). How can I add that to a cell with a formula in it to add certain
cells of these rows for a total? Thanks.
Microsoft MVP Excel
"satrntgr" <firstname.lastname@example.org> wrote in message
> In Excel 2009 I need to multiply rows 1 through 55 by $0.35. I don't need
>...Copying a formula while leaving one cell fixed
I forgot how to leave one cell fixed while copying a formula down a column.
I recall using a Dollar sign ("$") to hardwire a cell in a formula. My
formula should then read "=RC[-3]*$R9$C3"
However, this doesn't seem to work.
Thank you for your help.
You can use the $ to fix the row or column -- but only if you're using A1
If you're using R1C1 reference style, then this:
would take the value in colum...Basic IF function help
i am new to excel and trying to use the IF function. i am trying to
figure out how to get excel to only display the result of the formula
is a number. in some cases, the formula has "0" in numerator so i get
"Div/0" answer. in that case, i want the result to display just a
any help will be appreciated.
my current formula is
In article <email@example.com>,
"gtd068a" <IKhan11@...Non Delivery Strangeness
I rebooted Exchange 2003 SP2 and received the following NonDelivery email on
1/3/2006 for an email sent on12/15/2005. I and other users received a few of
these and the server seems to perform normally for the 100's of other emails
that are sent and received daily.
Your message did not reach some or all of the intended recipients.
Subject: Purchasing From Your Site
Sent: 12/19/2005 2:05 PM
The following recipient(s) could not be reached:
firstname.lastname@example.org on 1/3/2006 10:17 AM
The e-mail system was unable to deliver the message, but d...Can I set up a formula to lookup a value for a condition
I am trying to set up a formula for a vendor list. Each vendor has its own
individual number in column C.Some of vendors are grouped together. If vendor
is not grouped Column D has same number as of C. If Vendor is grouped, first
vendor number in Column C is assigned to all the group members. I need to set
up a formula so that col. E will look for vendor number in col. D and add
data for one group. Please help. Below is an example of my data list
Vendor name vendor number grouping number Purchases Sales Profit
abcd 251 251 $$$ ...using percentile in an array formula
I am trying to find the value of AF at the 25% percentile of AW in the
following array formula.
I am getting a result but not the answer I am expecting.
You might try
if your data values in AW are in ascending order,
but in that situation you could also use
"Bruce" <Bruce@discussions.microsoft.com> wrote in message
...Run Query using Multiple Parameters
Hi - thanks in advance for help.
I have this query that will calcuate my positions on any day that
SELECT StockTransactions.DealCode, StockTransactions.Stock,
Sum(StockTransactions.Shares) AS SumOfShares
WHERE StockTransactions.TradeDate<[As Of]
GROUP BY StockTransactions.DealCode, StockTransactions.Stock
However, I'd like to have the query run for every day between two
dates that I enter.
So, if I input start date as Jan 1 and end date as Jan 15 it will run
the above query repeatdly using Jan 1 as [As Of], Ja...Excel Basic function #2
Thanks, works now
Lesotho's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1582
View this thread: http://www.excelforum.com/showthread.php?threadid=27315
...Method of calling a function where function name is stored in a variable or control
Is there a way to call a function (or sub for that matter) where the
function/sub name is stored in a variable?
For instance lets say I have a table that stores some function names. On a
form I have a list box that displays the records in that table. For this
example lets say they all accomplish similar things and all require the same
numbef of arguments and none of them return a value.
If Call were the right method to accomplis this it might look sometihng like
Dim lngArgument as Long
lngArgument = 1234
Call Me.lstBox, lngArgument
In this case Call would run the function...Re-post:Formula Finesse Needed: COUNTIF or DCOUNT or Something bet
I might have posted my original question in the wrong area initially. The
answer i recieved from the General Excel forum was way beyond my ken.
Please see the post below and the answer I recieved. If someone could
explain how the answer works or send an alternative answer that would be
"Sean Timmons" wrote:
> OK, make sure your months are actual numbers.. Jan would be, ay, 1/1
> formatted as mmm.
> in A2,
> should get it
&g...NON TAXABLE Item Setup, What TAX CODE to assign
What is the proper way to set up a non taxable item like a coupon or labor?
I was assigning the <not assigned> (RMS dbase Tax ID 0)
(But I just read said to delete the <not assigned> tax code. to prevent a
runtime error (we have not had yet))
Do I need to setup a Non tax tax code? and add all non tax items to it?
PS I have a < > (blank)(RMS Dbase tax id 3) tax code that seems to
need to be deleted, RMS assigned it tax code 3. There are currently no items
assigned to the < > blank tax id
I can not find any guidance in the RMS Help. It seems MS ex...NDR from non-existent email address
Any user that sends a meeting request to the user in question gets the
Your message did not reach some or all of the intended recipients. I changed
the info to the innocent.
Sent: 8/16/2005 9:01 AM
The following recipient(s) could not be reached:
Gay, Esse M. on 8/16/2005 9:02 AM
The recipient name is not recognized
The MTS-ID of the original message is: c=US;a= ;p=XXX;l=XXXXXXX-XXXXXXX
This only happens with meeting invites, regular email goes through just
fine. It is jus...AVERAGE function returns #DIV/0! error
I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
Is there a safe proof way to omit the invalid values out of the average
Try this. I assumed your range was A1:A10, change this to fit your data.
Enter this formula by using CTRL+SHIFT+ENTER as it is an array formula:
> I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
> Is there a safe proof way to omit the invalid values out of the average
=IF(COU...Non-cash, Non-regular Transactions
Money 2003 SE V11
I have a need to set up transactions, such as Mileage, to
keep track of non-cash activities. I currently handle it
by setting up Bills & Deposits split into two
transactions totalling $0.00. The first is the
Category/Subcategory I want to track and the second is a
Category/(Non-Cash Offset Subcategory) that I filter out
of all reports. This works ok for me.
Example: (meaning 23 miles traveled)
Mileage:Offset Non-cash Transaction -23.00
However, the transaction is not regularly occurring. Yet
we are required to ...Using multiple Back-end servers
I've installed Front-end and back end exchange 2003 servers. Now we have to
host another domain and old back-end it's full. I've so installed another
beck-end server where hosting new mailboxes. Which I've to set to Master?
Where put public folders and have to set replica? How set RSUS policy for
new domain and new mailboxes in another back-end server?
The additional backend should make no difference. The Routing Master and RUS
can stay the same. As for Public Folders you could point the new server to
the old server or create a replicas. Probably the best approac...