Data From One Sheet to Another
I'm trying to set up my home based business ans keep track of stock et.
I've set up a workbook with several worksheets.
The first shows all the product purchased, columns for:-
A/Ship (mandatory monthly purchase):
Each of the other sheets id dedicated to one of the catagories, i.e. A/Ship,
Retail, Promo etc.
To save entering each invoice a couple of times, how can I get Excell to
populate the additional sheets when I enter the data in the first?
There are many w...data permutation / combination
i need to find a way to permute my data in an excel sheet.
I have 5 different group of data which i need to permute with.
rate diame material surface schedule
150 1/2 321 rf 10
300 3/4 304 ff 40
600 1 316 rj xs
900 1-1/4 105 80
1500 1-1/2 alloy 20 160
2500 2 ens s32720 xxs
well for diame 1, such as for...Smoothing Data?
If I have a list of numbers in a column such as:-
Is there a function to smooth the data, as I think the top end is a bit
What do you mean by Smoothing data?
> What do you mean by Smoothing data?
I know the top larger numbers are a bit too biased over the lower numbers.
I'm not looking for an average.
I guess I could plot them on a graph and get a linear representation?
On Feb 8, 11:54=A0pm, Saxman <john.h.williamsremovet...@btinternet.com>
> CurlyDave wrote:
> > What do you mean by Smoothing data?
>...how to sort the rows based on data in one column
Operating System: Mac OS X 10.4 (Tiger)
How do I explain this? <br>
I have an excel spread sheet that I got from the county assesor. <br>
They gave me a list of names and addresses. <br>
Name is in one column, street address in another,city in one, state in one, zip code in another. <br>
In Column D is the city. Most of the cities are listed as Flagstaff. I am trying to sort these out for two mailings. First I want to make a list of all of the rows that list in Column D as any city But Flagstaff. <br>
Then I want a second list of all row...EXCEL HELP (ROWS & DATA)
I have a table in Word that has many rows and cells with text in it.
I have a column of text in excel.
I would like to get in excel the information from the work document of just
the text that is found in my excel column.
I tried vlookup but the document in word may have a sentence in it and vlook
look at a whole cell not part of it.
Thanks for the help very much.
Example: word docuement has "table four is next to table three"
in excel I have a column
...conditional formatting based on the value of another cell
I want to apply a conditional format to a cell based on the value of another
cell having nothing to do with the value of the cell I want the format to
effect. for example - if the value in cell m5<0 i want cell a5 to be italic
(regardless of the value in a5)
You need to use the CF/ Formula Is ... option, rather than CF/ Cell Value Is
then you can use Formula Is =M5<0
"bwilde" <firstname.lastname@example.org> wrote in message
>I want to apply a conditional format to...Viewing Account Totals in CAN not US
How can i view my total balance of all accounts in CANADIAN dollars. I also
purchased Money 2006 Canadian Edition, however everything looks the same as
the US version, anyone tell me what the difference is?
AFAIK Money decides if it is Canadian or US version by the Regional Settings
in Windows Control Panel.
Microsoft MVP - Money
For UK tips & fixes see
For wishes or suggestions see
or for UK wishes http://www.microsoft.com/uk/support/money/feedb...Can't Remove Backup Files
I recently had to "REPAIR" my system due to trying to install the Win 7
upgrade. It screwed up my PC. Repair saved all my previous files, including
system files on my C drive. But I need the space.
I tried to delete them but I get a message that I am not authorized. I
tried to change the permissions but it wouldn't let me. I really need this
file space. Am I just screwed?
Retired Boeing Bill
From Help searching for Access Denied
I installed a new version of Windows and now I can't open a folder.
----------------------------------------------------...Unable to see massages in Outlook 2003
When trying to open a mail after having worked a little on the PC, I get the
Can't open this item. Out of memory or system resources. Close some windows
or programs and try again
However, doing that doesn't work, in fact, the only thing that works is
restarting the computer which gets old pretty fast.
Where do I go from here? I'm desperate!
...How can I minimize the all windows
I want to minimize all windows showing on the desktop. Is there some APIs
can do that?
It seems that there is not a shotcut.
But you can find out all windows then make them minimize.
Try these APIs:
Here's how to do it with Shell
HRESULT hr = ::CoInitialize(NULL) ;
hr = ::CoCreateInstance(clsid, NULL, CLSCTX_SERVER, IID_IUnknown, (void**)
IDispatch* pDis...Purge Analytical Accounting data?
We're still trying to install AA in a test environment prior to implementing
it live, and in between dealing with the many problems we're having doing so
I happened to think about a production issue.
I noticed (and Microsoft confirmed) that there's no procedure for purging
the AA tables. Considering that these grow exponentially, I thought that was
Has anyone dealt with this? How would one go about removing unneeded data
(for example, after purging the sub modules)?
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Cu...how can I sign mak key
i have a mak key but i dont know, where can I use this number for office 2010
You will have to give a more detailed explanation of what you are trying to
Microsoft Word MVP
"mercures" <email@example.com> wrote in message
>i have a mak key but i dont know, where can I use this number for office
On Wed, 23 Dec 2009 22:45:01 -0800, mercures
>i have a mak key but i dont know, where can I use ...how can I change the order of trendlines in a legend?
I've got a chart in excell with some trendlines. THey are however in the
legend in the wrong order. Is it possible to change the order of the
trendlines in the legend?
Looks like the order of trendlines is simply the order they were added
and once added, unlike the normal chart series, you can not change the
> I've got a chart in excell with some trendlines. THey are however in the
> legend in the wrong order. Is it possible to change the order of the
> trendlines in the legend?
Andy Pope, Microsoft MVP - Excel
http://www.an...Is this do-able?
A user has created a 'select' query in MS Access.
1/ runs the query (the user is prompted for an 'end' date / filter)
2/ switches to 'pivot table view'
3/ exports to MS Excel
We would love to do this in one step.
* I know how to link to external data in MS Excel, and could then refresh
the raw data in Excel. However, the number of lines in my resulting
spreadsheet varies so my pivot table would have to be recreated or the range
reset, I believe.
Thank you for any ideas.
(** Is there a better newsgroup to post thi...Forcsaster Analysts can't see their data
I set up a complete forecaster template as administrator. I gave 5 users
access as analysts. These users can log in to Forecaster and the manage
connections test pass. However, they can't acces the departments I've given
them access to.
Any idea what I'm missing here?
...Data validation failures
I have several templates set up that are called by a master sheet. These sheets contain information with Data validation drop down lists. Excel is continually having problems with these data validation cells and commonly this is in the form of either only 1 cell with data validation drop down list functioning, or it is interfering with pictures on screen or it is moving combo boxes around the screen. This is not in code to do this either, it is very confusing and I am tempted to say that the data validation option has been very badly programmed!
Like I say these functions all work perfectly in...ITK ... how can I get it?
How can I get the Implementation ToolKit?
Course 8018 refers to the ITK as methodology and templates in CRM deployment
Thanks in advance.
It's on the partner site, if you have access go to:
You can download it there from a link at the bottom of the article.
> How can I get the Implementation ToolKit?
> Course 8018 refers to the ITK as methodology and templates in CRM deployment
> Thanks in advance....winxp not able to join domain
hi! recently, i've some issues in a small grp of clients about 5% of the
total 1000 PCs. We're not able to join these PCs into our win2003 domain.
I've to rename the PCs before i can join to the domain. I've checked in the
AD, the computer name is not there and all the dns, gateway and etc are
correct. I didn't see any related msg in event viewer as well.
for some of these pcs i've to re-join the domain for the user to login again.
has anyone encouter this before? pls advise. thx
Are the machines created from a not sysprepped image? Did...data in row didnt match import type 01-01-06
while importing almost 800 accounts , i got the following error for
of accounts though i imported only 7 accounts.
'Data in row did not match the import type'
what is the solution? How can i match it? whats is the way of
is it possible you are trying to import accountnames into fields where crm
is expecting the actual account guid rather than name?
Microsoft CRM MVP
"Aami" <firstname.lastname@example.org> wrote in message ...Input Boxes and data validation
If I am using input boxes to enter data into a worksheet, is it also
possible to have data validation on the cell?
Data validation only tests values that are typed in the cells. You could
use programming to test the values entered in the input box.
> If I am using input boxes to enter data into a worksheet, is it also
> possible to have data validation on the cell?
...Refresh external data message
I have a workbook that comprises of 2 worksheet, wk1 and
wk2. Wk1 has detail information which feeds into a pivot
table in wk2. I have one macro attached to the activate
event on wk2 to refresh the pivot table.
However, every time I open the workbook I get a message
saying "This workbook contains queries to external data
that refresh automatically......" "Enable automatic
refresh" or "Disable automatic refresh".
To the best of my knowledge I don't have any queries or
links...can anyone tell me why this message is coming up
and how to get rid of i...can't retrieve emails, only send
Before upgrade, I was using outlook express on Windows
2000 Professional, then installed Office XP Standard. Now
trying to use Outlook 2002. Outlook can only send emails
out. Outlook can't retrieve emails. I've tried resetting
default email client in Internet Explorer.
...Not matching transactions, think I see what is going on.
One of the banks with Yodlee I'm using is PNC bank. I finally figured out when my downloads are coming
in in capital letters, they are seen on PNC's web site as "current transactions". They will download again
but the next time with blank areas in the "pay to". But the transaction will have the history in the memo area
I found that it is this download that needs to be filled in with the correct information in catagories,otherwise it
if I delete this one, it will download again.
Is anyone else seeing this with other banks? Could it be that they are using an e...How to make Macro RunCode ? Doesn't see my Function???
I've got some simple code for a form...
Option Compare Database
Public Function TestCode()
MsgBox "Function Worked"
I understand that the "Run" and "Debug/Step Into" doesn't work for
code in Access... you must execute the code from an object or Macro...
so I am trying to create a macro...
>From the "Design Window" I click on Macros and then New
For "Action" I select "Run Code"
Then I click in the "Function" field at the bottom and open the
I see two folders... Bui...Can Not Sign In
I have been unbale to access my account today. I have
even tried changing net passowrds but no success. Even
my hotmail account seems to be acting up. Any advice?