multi-column data consolidation
Hi guys, here is my problem....
- Column A to F are months (Jan to June)
- Beneath each month (starting row 2 downwards), text data will b
How can I have the six months add up or compiled as a single colum
database in another sheet or a separate column in that same sheet?
will be adding data every so often under these months and it shoul
update the database.
Thank you for any assistance/help
Message posted from http://www.ExcelForum.com
Question is not clear to me.
Not sure what 'add up or compile' means with text entries
Perhaps, in G2 enter =...Publisher 2007 Booklet Print Problem
I created a small 4 pg booklet using a designed template from MS online. This
is a 1/2 booklet format 5.5 x 8.5; I set all margins to 1/4" in the master
and page set up. I successfully insert my pics & bled them to the edge of the
The problem comes with printing samples on my HP PSC 1350 home printer. I
lose 1/2" of printing on the front edge of pg 1 & pg 3; meaing that for 1/2"
from the edge.. it is blank and my full image doesn't print fully. I want to
bleed all the images to the edge and use printed sample pages or send a pdf
to the printer for fi...Character Problem
Here is another thing that I can't figure out.
I am writing a text to a file
File.WriteString(_T("2 x 3 = 6 3 x 2 = 6 6 � 2 = 3 6 � 3 =
But when I read it back I get
2 x 3 = 6 3 x 2 = 6 6 2 = 3 6? 3 = 2
I am not sure why the � (character 0xF7) is not showing up correctly?
The funny thing is that the first one doesn't even show up, and the second
one shows up as a block.
Any solution to this?
Looks like a font problem, but is the character in question stored in the
file correctly? And are the proper chars in ...Problem with DECLARE CURSOR
I am using SQL Server 2005, Visual Basic 6 (SP6) & Microsoft ActiveX Data
If I run following query through SQL Server 2005 Management Studio through
QUERY only then it works FINE. But if I run from application using Execute
method of Command Object of ADO then it process maximum 49 records in CURSOR
and query completes without any errors.
I had checked by inserting records in a Temporary Table. If I do Not Use
UPDATE statement then it INSERT maximum 65 records in Table and if I use
UPDATE statement then it INSERT & UPDATE maximum 49 records.
...Problems with hyperlinks
I hope I can explain this well enough for everyone to understand. Here goes:
I am using Excel 2003. I have a workbook that has approx. 2,300 Rows of
data. Within each row there are 4 Columns that contain different hyperlinks
that go to corporate websites. I have come across some errors where the
hyperlinks are going to the wrong URL. Sometimes when I click the ‘Insert
Hyperlink’ button and ‘Remove Hyperlink’, I find that when I go to relink the
cell, it still has another hyperlink even though I just removed one. It’s
like there were two different hyperlinks in one cell. How does...Multi profile
I have configured outlook 2007 to use multi profiles. When I close the
outloop and re-open to select other profile the profiles select list is not
prompted. I have set for prompt for profile. But I observed this, after
closing outlook still the task manager shows Outlook.exe is runing..when I
kill that and re-open I can see the profiles and select particular.
Now my question, why Outlook is runnning though its closed. My setting "Hide
when minimized" is already OFF.
have a look in the "Task Manager" under "Process" if Outlook.exe is stil...A question about thread,please help me #2
My program environment is .net2005.The partial code is shown as below:
void CfinalView::OnRButtonDblClk(UINT nFlags, CPoint point)
AfxBeginThread(RUNTI...Saving Files Problem
I have been using Excel at work to do simple spreadsheets. When I wan
to take some data home to enter, I saved this info on a 3.5 diskette
When I try to open it at work I get a message that this file cannot b
accesssed. I am using the same systems on both machines.( Excel 2000.)
The message says " the file is either read-only or you may be trying t
acess a read-only location. Or, the server the document is stored on i
Message posted from http://www.ExcelForum.com
Never work directly in Excel from/to a diskette. There are many documented
...Problems with Office 2004
All of a sudden I am having problems loading Office 2004
applications. When I try to load them it says "The Application (Word,
Entourage, Excel, Power Point) quit unexpectedly." I am given the
option of "close", "report" or "reopen". I have found I have to
choose "reopen" at which time the I get the message "the application
Excel quit unexpectedly after it was reopened". I can then "close"
"Try Again" or "Report". If I say Try Again it finally opens.
I have reported it and even deleted the programs ...Problem with Microsoft excel reports
We are implementing a project on Microsoft CRM 3.0.
I have developed a report in Microsoft Excel using Microsoft Query. I
have uploaded the same on CRM in the Reports section. The problem is when I
open the report from the Reports section, the CRM web instance closes. Is
there a solution for the same?
On top of separate connection issues, I suffered the same problem last week.
I'm going to look for a KB article today top see if this is a documented
issue. I'll keep you posted if I find something. Do you have the Update
Rollup 1 installed?
>...Problem with WMC for Win7 x64 -- live TV setup problem
When I try to setup WMC (Win7 x64) for live TV it goes through the
region setting question, then the zip code, then when it goes to
"configuring" it hangs. I got a tip to run "mcupdate.exe" from
another forum to overcome the hanging.
After is scans for channels it asks if ATSC digital is what I want (I
do, for OTA TV)... then comes this dreaded screen:
"TV setup has encountered a serious problem. Select Finish to exit,
then try again. If this problem persists, restart Windows Media
Center or the computer."
I&...Problem exporting/importing .psf
Hi guys, I searched the community before and couldn't
find anything regarding this issue. I am trying to export
an Outlook 2000 mailbox from one user account to another.
However, when I try and import it, I get the message
saying that "Personal Folders "Properties for this
information service must be defined prior to use". I have
looked up solutions for this and they say to make sure
its not read only. I tried this and it doesnt work, its
currently NOT read only.
Please note: This is a computer where the Outlook folder
source for the export is on a user account no...Mac Stuff CDs, A to Z, updated 15/Jan/2006, and Win & Mac programs, 'WinMac', 'PC/MaC', 'Win-Mac', 'Multi', 'Multi-Platform', 'MultiFormat', 'MULTIOS', 'HYBRID'
Mac Stuff CDs, A to Z, updated 15/Jan/2006, and Win & Mac programs,
'WinMac', 'PC/MaC', 'Win-Mac', 'Multi', 'Multi-Platform',
'MultiFormat', 'MULTIOS', 'HYBRID'
GARAGE SALES, buy, risk-free purchase, working, tested, fully
functional, very cheap discounted price, low cost, quality OEM
Abvent Artlantis v4.5 Mac 1CD
Adobe Acrobat 6.0.0 Professional Mac OSX 1CD
I recently had to reinstall xp and always change the registry so that the
number lock is always on as below. I find now since the reinstall the
registry won't keep the changes for HKEY_USERS, does anyone have a
>InitialKeyboardIndicators = 0
>InitialKeyboardIndicators = 0
Isn't there a setting in the Bios for that? If you enabled it stay on
"JT" <email@example.com> wrote in message
news:Swldn.9717$4N4.1...problems with Outlook client running on the Window2000
My Outlook client runs on Windows2000 SP4 and IE SP1 , office2003. now,
there is a serious problem which the IE will appear the message "the page can
not be displayed correctly", when i save the e-mail activity in the outlook
does any one know how to fix it?
I've seen that others have a problem opening Publisher files from different
versions so it's a popular request, but I'm trying to open a file and I'm not
sure what version it was made in (I think 95). I need it for Publisher 2000.
Would someone be willing to convert it for me?
I'll convert it, be aware you may lose some formatting.
gsauer at columbus dot rr dot com
Mary Sauer MSFT MVP
"matmorris" <firstname.lastname@example.org> wrote in message
news:0...problem view causes amt to invoice and price extension not to update in sales order entry
I created a view with an index and it caused some odd behaviors in
Sales Order Entry. The quantity to invoice no longer updated when I
tabbed off the quantity field and also the price extension didn't
compute either. Once I deleted the view, the problem went away. Here
is the view & index T-SQL.
/****** Object: View [dbo].[gvaWholeSaleInventoryPrices] Script
Date: 09/29/2008 09:24:23 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER VIEW [dbo].[gvaWholeSaleInventoryPrices]
W...SFO problems 02-21-06
Re-posting because i didnt get a response. Can someone please help?? Matt,
We have developed a custom multiselect lookup in .net. This .net page is
called from an iframe inside the entity form. This works fine on the server.
However, when we deploy this code on SFO (we have copied the project folder
and created a virtual directory on the SFO client machine), an alert message
saying "access is denied" is popping up. Can someone please help with this????
CRM 3.0; SQL 2000; VS.NET 2003. Looking to upgrade to SQL 2005 and VS.NET 2005
Good chance it has something ...threads won't close and then reopen correctly...
I have a MFC VC++ project that has a thread started in the
OnInitDialog() function of a dialog box.
AfxBeginThread(ThreadProcess, (LPVOID) this, 0);
I handle the thread in the the following function
UINT Questions::ThreadProcess(LPVOID param)
//do some stuff
Everything works well until I close the dialog box and then reopen
it. When I do that the thread doesn't work as it should the second
time around. Anyone have any thoughts on why I am getting this
unwanted behavior and what I can do to correct it?
Thanks in advance,
"RAB&...Multi-threading with multi-port server
Can I ask your guidance on how to imeplement server with multi-
threading and multi-port? meaning, I would like my server to receive
audio and video in different ports, and they run concurrently and send
the data to clients.
I am so lost, because I would mess up my .accept and .listen and
setparent if i have videosocket and audiosocket object. I tried and it
"Rehmet" <email@example.com> wrote in message
> Hi guys,
> Can I ask your guidance on how to imeplement serve...Calender Problem after Exchange Migration
I've got a bit of a Exch Calendar problem. We recently migrated from
Exch2000 Srv to Exch2003 Srv. We also changed domain names (AD and company)
Due to time constraints and other issues I won't go into, things were a
little rushed and the way we did the migration was probably not by the MS
rules. Basically we restored a backup of the mailboxes from the old Exch2000
server to the new Exch2003 server. This was done via Qinetix MB idata agent.
We thought this would be quicker than exporting the mailbox's out as PST
files and then importing them. This part app...Can't open the link to a reply to a thread I posted
Hi Everyone, I received a reply to a question RE Excel/Office, but when I try
to open the link, the page except for the header is blank. Have you ever had
that happen, and what can I do to fix it?
I really appreciate the help and goodwill that you send my way. Hopefully, I
can reciprocate, somewhere.
"RkyMtn" <RkyMtn@discussions.microsoft.com> wrote in message
> Hi Everyone, I received a reply to a question RE Excel/Office, but when I
> to open the link, the page except for the header is bla...A little Excel Problem.
Can I hide negitive but not posivtive values in cells?
Using Conditional Formatting (Format>Conditional formatting...) set the cell
value to less than 0 and set the font format to white (Presuming no colour
in cell background... if there is use this colour). The data will still be
there but invisible. It will print though
Microsoft MVP - Excel
"Qallupilluq" <Qallupilluq@discussions.microsoft.com> wrote in message
news:E8D652F9-0EF8-44CA-B711-1965F49005BE@microsoft.co...Problem with InvalidateRect
I am trying to play a video in a MFC application using a view. To
display frames quickly I have to call InValidateRect() so that the new
frame gets painted. My view is getting updated perfectly but my other
controls on the view like buttons or toolbar buttons are either not
displayed or either are shown disabled even when I have written code
to enable them. If I remove InvalidateRect then everything works fine
but my view does not get refreshed and hence I cannot see the video.
Is there any way to solve this problem or Is there any other option
Thanks and Regards,
...Multi Store Workflow Question
We have one store and a warehouse. We need to order and receive items at the
warehouse and transfer them to the store. We need the store to be able to
see what is on order and all inventory at the warehouse. Is anyone doing
something like this, and how easy it it? At a recent demo, this required
many steps, logging into 3 different databases, doing updates, etc. Very
confusing for simple tasks we need to do every day.
Microsoft RMS HeadQuarters would be the solution for you.
You can view the inventory in Warehouse and items on order from the Store