Can anybody help, I'm after making a spreadsheet in Excel to record
times for individuals, for example if I typed in 'early shift' with the
value of 10 hours, after 'noon shift' 8 hours as well as 'late' shift at
12 hours...etc, the total values would all show in a totals cell for
I would appreciate any help with the above.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
use a helper column which transforms this text string int...Changing Cells and entering data in them
Thanks for the help again.
Big thanks to Steve you've got me this far.
I went out and bought a book, but it's like reading a
I was informed today that I can't have message boxes come
I need to have the code point at the cells and if they are
blank turn which ever one is blank red or if both are then
both turn red then pause for each cell to be filled in.
Cell F14 "Last Name" then automatically go to Cell
F16 "First Name" on tab or enter.
Basically if Cell F22 or F23 has an X in it, Cells F14 an
F16 turn red and cell F14 has the focus...Sorting emails by domains, from org to edu (right char is the most significant)
I need to sort the domains according their emails.
That is, how to sort, according to the domain name ( the right is the
most significant )?
On Feb 15, 11:09 pm, "duzhid...@gmail.com" <duzhid...@gmail.com>
> That is, how to sort, according to the domain name ( the right is the
> most significant )?
you'll probably need ...Using Relative path for XML data file?
Is there a way to specify a relative path to an XML data file imported into
Excel 2003? I am writing a web app that generates report data as XML for the
user to download to their local machine. This data is to be consumed by an
Excel reporting spreadsheet, which contains display-formatted tables and
charts that are mapped to various data fields in an XML Map, which is in turn
linked to the xml data file they will download.
The idea is the user only needs to download the data for updates, not the
whole spreadsheet. However, since I cannot predict the path where the user
will store their...how to convert lookup values to the "display text"
I'm using an sql code (below) which uses a few lookup fields. Unfortunately
in the datasheet view, I get the "bound values" instead of the "display
values". How can I change the properties for the these lookup fields so I
can see the "display values" from the datasheet view?
UNION ALL SELECT
UNION ALL SELECT
I have following queries regarding new implementation:
If I ask that I have 8 outlets at remote locations & these are all garments
stores, which will communicate with HQ Server. Each store is having around
1500 items. Now the question is how much time/days will it required to
implement? Can anyone tell me an approximate time period? Just have an idea.
Which connection/line is fast/speedy for communication with HQ server from
remote stores? Like DSL, Dial ap. IS VPN necessary?If NOT Y and if YES Y??
•Will start from Store Operation Template Database.
•Af...conditional formatting sort
Is there a way to sort after conditional formatting. So, if I've set up a
conditional format to color my text red if the number is between 0 and 95,
then I want to sort so all red numbers are at the top of the spreadsheet?
Thanks for your time and assistance.
On Thu, 25 Oct 2007 05:08:00 -0700, rrupp
You can't sort by color, but you can add a column to your query like
SortColumn: Iif(SomeValue >= 0 and SomeValue <= 95, 1, 2)
Then sort by this column.
>Is there a way to sort after condition...The opposite of the "sort" function
I have a list of alphabetically ordered data in a column.
Is there a function for randomizing the order of these data?
In article <email@example.com>,
> I have a list of alphabetically ordered data in a column.
> Is there a function for randomizing the order of these data?
Exellent solution! thanks!
Let's say your data in A1:A10
In B1: =RAND()
copy from B1 to B10
Select A1:B10 > Data > Sort > Sort by select Column B > select As...Attaching Contacts to new email
Creating a new email. When contacts folder has "shared" contacts and
"personal" contacts how can you set your personal contacts as the default?
Example: creating a new email having never addressed the "send to" contact
before, you hit the "To" button. Currently my "shared" contacts opens up but
I would like my "personal" contacts page to open instead of having to drop
down to "contacts" to bring up that list.
Is there a solution to this?
On 2/26/2010 10:21 AM, assistantneedshelp wrote:
>...New to excel
I'm new to Excel ( and to this forum :) ) and so I hope somebody may b
able to help me.
I've got 2 questions....
I've got a spreadsheet which takes data from one worksheet and uses i
to calculate data in a second worksheet using the following code
=IF('4th November 2005'!B19="","nothing here dude",IF(B19<'4th Novembe
2005'!B19,"UP",IF(B19='4th November 2005'!B19,"Same",IF(B19>'4t
The problem is, when I create a new worksheet I have...How to create an autonumber field?
i need to create an autonumber field to automate account numbering. how can
i do this?
You can do this using a post callout piece of code so when you update an
account this code is called which calls back into the platform and works out
the last account number then adds one to it and updates the account record.
look on msdn.microsoft.com under crm for examples
Microsoft CRM MVP
"Max" <Max@discussions.microsoft.com> wrote in message
> i need ...How do I overlay text to a row without loosing the text in the ba.
I would like to know how to give an entire row (or column) a text overlay
such as "VOID" and still be able to view the text in the underlaying row (or
Thanks in advance.
Use WordArt from the Drawing toolbar. Change the Fill to None.
"Bruce Charles" <Bruce Charles@discussions.microsoft.com> wrote in message
|I would like to know how to give an entire row (or column) a text overlay
| such as "VOID" and still be able to view the text in the underlaying row
| c...How do I see when new messages without outlook running?
Without Outlook 2003 constantly running, how do I send mail or know when I
have new mail?
two possible answers...
1) you don't or
2) you acquired a 3rd party app to occasionally poll your pop3/imap account
"Leslie Adams" <Leslie Adams@discussions.microsoft.com> wrote in message
> Without Outlook 2003 constantly running, how do I send mail or know when I
> have new mail?
...Excel corrupts when asking to update vlookups
We are experiencing weird behavior with some Office 2K3 Excel spreadsheets
that contain lots of calculations, but no macros. On some pc’s Excel acts
normally, on others you get the error. I have a couple of screen shots
Any help is appreciated.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
Don Gu...data sort
ok now should be simple >>
I need to sort by month on data that is held in format >> day/month
custom/ends with/ 11... does not work
custom/ends with/ ??11.. or *11 does not work either
contains 11 does not work (& would also be wrong if data set contained 1011)
but still I am stumped so any help would be great
I would be inclined to add a new, temporary field of formulas that pull off
the right 2 digits, and sort by that: =RIGHT(A1,2)
...AR invoicing update GL but not receivables
We have an issue where the GL is updated with invoicing activity, but in some
cases the receivables side is not. Any piror issues with this, advice on how
to figure out the problem, etc?
I have only heard of the opposite happening - AR subledger is updated, but
the GL is not. Can you walk through exactly what happens? What type of AR
document in what screen? What is the 'On Account' amount? What are the GL
distributions? Where are you going to see that the AR subledger is not
updated? Where do you see that the GL is updated?
Microsoft MVP - Gre...New Record
I'm using the following in the On Click of a command button.
DoCmd.GoToRecord acDataForm, "frmMyForm", acNewRec
Anyway I can do this without referenceing the Object (Form) name??
DoCmd.GoToRecord , , acNewRec
Mark A. Sam
"JamesJ" <jjy@adelphia_darwin.net> wrote in message
> I'm using the following in the On Click of a command button.
> DoCmd.GoToRecord acDataForm, "frmMyForm", acNewRec
> Anyway I can do this without referenceing the Object (Form)...Pulling data from separate tabs
When charting in Excel 2002 is there a way to use sets of
data from two different tabs within the same worksheet?
For example, a spreadsheet contains separate tabs for
prior year and current year data. Is there a way to
reference the data or label series to pick up data from
I tried pointing and clicking, and then typing the
following as a reference for the axis labels:
='Prior Year'!$B$110:$M$110,'Current Year'!'$B$110:$M$110
but receive an error that I'm referring to an external
I've used the comma (') in the past to reference breaks ...get a result of an sql into a field
I would like to get a result of an sql execution (ms sql server) into aq
example i A1 I have a ID number
in A2 I would like to get the result of something like this 'select name
from address where id=A1'
Does this exist in Excel ?
Thanks in advance
Here is the sub i have written for loading an Sql Query into th
Target Sheet name
Column to begin from
Row to begin from
ex: CALL LoadData("MyServer","MyDataBase","Select UserName fro
"QueryData"...Formula for cross tab data filling
How to using formula for data filling as below (Y/N) ?
Product A Product B Product C
System A Y N Y
System B Y Y N
System A Product A
System A Product C
System B Product A
System B Product B
...Load image in a unbound control from a attachment field in recor
I have a unbound (single not continuious) form with 16 differant records from
the same recordset. No problem loading the this data from recordset in VBA.
PROBLEM I need to know how to load the unbound controls with Image's from an
attachment field in another recordset
The normal method of control = Rs!field does not work
dans l'article 78DC5502-3A76-4562-AA20-736446AB1448@microsoft.com, Tom �
Tom@discussions.microsoft.com a �crit le 21/01/08 20:28�:
> I have a unbound (single not continuious) form with 16 differant records from
> the same record...Help with importing data
Can I have users fill in a form in Access and have that data be transferred
and updated to a spreadsheet. Need for fill out several fields and then
export to a specific spreadsheet and place that data into the cells that will
update that cell (add to the total in that cell) of a spreadsheet.
I was wondering if anyone knows how to backdown security
updates? We ran the latest security updates for our
servers and now most of our applications won't run
properly. Has anyone had this experience before? Can we
back these down?
Control Panel -> Add remove programs ???
> I was wondering if anyone knows how to backdown security
> updates? We ran the latest security updates for our
> servers and now most of our applications won't run
> properly. Has anyone had this experience before? Can we
> back these down?
...form fields not saving to table
I have created a database with a form and three of the fields are not saving
the information to the table. I have checked the row and control sources and
now at a loss and thoughts?
As you scroll through existing records is the data of the table displayed?
Post the SQL of the query or form source.
Build a little, test a little.
> I have created a database with a form and three of the fields are not saving
> the information to the table. I have checked the row and control sources and
> now at a loss and thoughts?
...Cannot Delete Any Records
We're running CRM 3 Rollup v3 and we have recently found that we cannot
delete any records in CRM. We recently migrated over to a Windows 2003
Enterprise install running SQL 2000 Enterprise. Everything else is working
without issue for us. For example I am a Sys Admin, and I receive a generic
SQL Server error when going to delete an activity? I know that in the past
this was possible, any thoughts?
Sean; sounds like something went wrong with your migration. you can run a
CRM trace or a SQL Profiler trace while performing the deletion to see if
you can pin-point the error.