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 =...Double-Clicking a cell for Multiple Options
I recently came across a spreadsheet where a cell was double clicked for the
multiple options to become available.
This was similar to a drop-down list, but there was no drop down list!!
The cell currently shows a value of "A".
I double-click on this cell ... the cell changes to "B".
The new value is not random, but coming from a pick list or a pre-determined
Does anybody know how such a feature is created?
If you rightclick on that cell and choose "Pick from DropDown List" do you get
the same effect?
If yes, ...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...Reporting Options
Can someone tell me where the static reports are stored? I found some static
reports (PDFs) that load up in a webpart; however, it's unclear where they
are stored. In general, I am researching the various reporting options. We
would like to create reports (scheduled) and store them in a document
respository, making them available to specific users based on custom roles.
...Converting linked currency values into equal negatives
Is it possible to link to a positive dollar amount and then have Excel
automatically convert it in my spreadsheet into its identical but negative
Excel uses a hyphen as a minus sign, so if your positive value is in A1, you
can use the formula =-A1
"infdismd" <firstname.lastname@example.org> wrote in message
> Is it possible to link to a positive dollar amount and then have Excel
> automatically convert it in my spreadsheet into its identical but negative
...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
...No autorepublish option in Excel 2003
We have several XP machines in the office with Office 2003. We want to
publish a Excel Workbook on the intranet. That's no problem. It works
fine. But on some machines we have the option "AutoRepublish every
time this workbook is saved" and on other machines we don't have this
option. Does anyone know why we don't have this option on some
I have 2 check boxes in an option group, I have 1 check box for yes and
another for no, when i start typing in a field the no check box automatically
gets checked, I tried to set the default option group value to isNull but
the check keeps appearing in the no box.
Message posted via http://www.accessmonster.com
Is you option group bound to a yes/no field from your table?
If so, the problem is that Access does not support Null in yes/no fields, so
as soon as you start entering something, the yes/no field becomes False.
Presumably the one text box has the Option Value 0 (for False), ...Payment Options #2
The Payment option of CHARGE is not included in MS POS v2 as a payment
option. Is there anyway I can get around this? maybe by adding it myself Or
maybe use one of the other types for this purpose.
Also can I use Gift Payment Method without having to go through a online
MSPOS does have a charge account you would need to upgrade to RMS to get the
1-800-426-5708 XT 1307
"Dawn Oneal" <email@example.com> wrote in message
news:uga5QqWqJHA.500@TK2MSFTNGP06.p...Currency and euro in reports
I have a db keeping track of potential investments, with locations all over
the world. In my investment table i have a field for the approximate
investment amount. the field is set for currency. However, for certain
european investments, the amount is based on euros. Is there a way to allow
me to choose which type of currency i can use, and then create a report to
display the appropriate currency symbol?
On Feb 5, 2:15=A0pm, JackAtArcLight
> I have a db keeping track of potential investments, with locations all ov=
...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" <firstname.lastname@example.org> wrote in message
> Hi guys,
> Can I ask your guidance on how to imeplement serve...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
Diviasoft, In...Multi axis chart
Hi, I want to show a stacked chart, ie 4 products sales value in a given
month. But then compare it to the prvious years results.
I know you could use a 3D chart to show 3 axis, however I can't find how to
have the 2 axis (last year and this year) stacked.
Hope you understand what I'm asking
A 3D chart is more likely to obscure than show anything.
I'm not sure what you're looking for. Perhaps a stacked-clustered column
chart, where each column in the cluster has the four stacked values for each
Does anyone know whether Office 2004 has built in additional languages?
Say if I buy the Japanese or Spanish version and install on English OS =
X, do I=20
have everything in English (GUI)? In Office v.X this did not work. Does =
joe <email@example.com> wrote:
> Does anyone know whether Office 2004 has built in additional languages?
> Say if I buy the Japanese or Spanish version and install on English OS X,
> do I have everything in English (GUI)? In Office v.X this did not work.
> Does it now?
Considering that the application would need a fairly...adding another options into field in the workflow manager
I would like to design a workflow to assign an activity to manager if the
case is not finished within three days since the statuscode turns into "In
progress". I have the idea of solving this problems, which add an option into
the field in the design screen of Time Based Time. does anyone got the idea
how to change the property..
Add a statement to your workflow that points to a manual rule that says wait
3 days if status = In Progress then assign to owner's manager. Also create an
Update rule for cases, that changes the Status field from In Progress to
something el...Bibliography options gray
I am working on a paper and have used the citation system before. But now, I
am unable to access the options to add a citation, create a source, etc.
This is a new install of Office 2007. One paper has existing citations, but
this happens even in a new document. Ideas?
I never encountered it myself, but there seems to be a bug in the Office
2007 installation process every once in a while where the bibliography tools
are not installed correctly. If you were never able to use the tools on that
specific installation, I'm guessing this is the problem.
The only known soluti...Multi-select list box for multi-column query
I have a list box lstBudVols from which I want users to select 4 items. Once
these are selected, I want to use the selection for each as criteria for a
different column in a query eg select 2010, 2011, 2012, 2013 in the list box,
the output columns would be:
TSL 2010 2011 2012 2013
xx xxx xxx xxx xxx
I've done this earlier already using 2 different list boxes, but it would
not be a smooth, well built database if the user had to select from 4
Is there a way of modifying:
For Each vItm In Me.lstBudVols.ItemsSelected
I need...Restoring Public Folders in multi-site environments
we have 1 exchange organization, 4 exchange servers in 4 locations and have
public folders replicated to all 4 servers. Some days ago, one of admins
accidentally delete one folder with subfolders using System Manager:-(
We are going with restoring public store on one of servers. All goes fine,
until replication was done. Folder became deleted once more, due to
replication from other 3 servers.
I search MS site regarding this fact.., but nothing found.
As I understand, there should be some mechanism like authoritative restore
for AD, but I've only found utility authrest.exe,...Equity Option
I have entered an equity option short sell trade in moneycentral. When I
2004, it does not download this trade. It downloads equity trades. What can
PS. I posted this a few days ago but I did not see it in my Outlook. Sorry
if it is a duplicate.
Do anybody know all the available save options in Excel.If not I
recommend this post
...SmartList Builder Multi-company
When you create a multi-company SmartList, how can you get it to list the
company that the record comes from? For example, I built a SmartList to give
me all the GL account numbers and descriptions for 10 different companies.
But when I run it, I can't tell which company it it pulling a particular
I tried to link the Company Master, but it only links to a couple of temp
If you create a view with the information, you can add a company reference
and display it in your SmartList.
> When you create a multi-company SmartList, how...Multi-sheet bar chart data problems
I have a multi-sheet workbook. Each page has a sell containing a total
- let's call it "D2" again... :o)
I want to take data from cell "D2" on each sheet and make a "clustered
I also want each column to take the name of each sheet, thus:
__ __ __
__ __ __
sheet1 sheet2 sheet3 etc.
Is this possible? I have tried using the Chart Wizard but, when I
select cell D2 across all sheets...
Data range: ='sheet1:sheet4'!$D$2
....it returns an error: "Refer...Aged Trial Balance w/options
Is there any way to set the Aged Trial Balance w/options report to age
Have you tried using the historical aged trial balance report instead?
Dynamics GP MVP
Flexible Solutions - home of GP Reports
"mlubbs" <firstname.lastname@example.org> wrote in message
> Is there any way to set the Aged Trial Balance w/options report to age
I was able to run the Historical rep...Pivot Table
Is there any way to set the default settings for the Table Options for every
new pivot table that you build?
Also, is there a way to change the default format for a numeric field
(number, 0 decimal places, instead of the original 2)
...How do I place currency symbols by themselves in Excel?
I asked this question before but perhaps I was less than specific.
I want to place a currency symbol, by itself ,in a separate cell or column
when using Microsoft Excel.
I know about Format,cells,number headings,etc. but how do I get JUST the
symbol , without other numbers, in the relevant box??
I am looking for help.
Just type it in the cell.
Microsoft MVP - Excel
"The Angry Ant" <TheAngryAnt@discussions.microsoft.com> wrote in message