Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...Excel 2003 extract repeating cells
I have successfully sorted my data to show repeating entries in
relation to two specific columns. I can't seem to figure out how to
select these repeating entries (without doing it manually, of course)
and putting them either into their own column(s) or an entirely
different spreadsheet altogether.
The goal is to save time in managing THOUSANDS of documents in this
manner so that my colleagues can easily pick up repeating entries and
take according action. Doing it manually is very time-inefficient.
You don't really describe enough of your layout or what you actually mean...Exporting file names to an excel spreadsheet.
I have a folder containing many many many .pdf files.
Is there a way to export the filenames of these .pdf files into an
If this is a dumb question, I apologize. I didnt have any luck
searching for the answer here.
Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30611
View this thread: http://www.excelforum.com/showthread.php?threadid=547520
I use Jim Cone's fine Add-in called "ListFiles"for this sort of thing. It's
available free (a...cell looses name after sorting
Can someone help me with the following problem in Excel 2000:
in a table I have attached serveral cells with unique cell names, the
values in these cells are used in other sheets.
the problem is that when I sort the table, the cell names stay in the
original rowposition; they are not sorted! while their values are. So
Cell names get different values, and other calculations on my other
sheets get messed up!
How can I make the cell names relative instead of absolute?
thankx in advance,
Message posted from http://www.ExcelForum.com/
"jimfx >" <<jimfx.109zcv@exc...Change <value> in outlook
We Have Exchange 2003 sp2 and outlook 2003 sp2. I have renamed 2 AD
accounts. Changed all display names, accounts name etc with the 2 accounts.
When users open outlook and send to renamed account they see account name
<oldaccountname> in the autocomplete list. I have cleared nk2 files in
profile , but it still shows newaccount <oldaccountname> in drop down box. Is
there a way to edit the <oldaccountnam> value of the renamed account? I
tried the same thing with a freshly loaded PC. with the same result.
You can delete the nickname files.
MVP - E...How can I wrap text across merged cells?
I'm using Excel 2000. I have a set of merged cells A5-
E5. I have several lines
of text in the cells and I want them to wrap across the
merged cells and it is not working. All I get is the
first line of text showing and the rest is cut off. It
works if the cells are not merged, but I really need to do
it in my merged cells. Is there a way to this other than
manually resizing the height of the row?
Instead of merging cells, have you tried the "Center Across Selection"
The appearence is just about identical to what you would get using merged
cells, although I d...Multiple PST Files #2
I am running Outlook 2003 and would like to have Outlook use two
different .pst files (one for my work stuff and one for home) on the
same computer. Is it possible to do this?
If so, can I can I configure one of the pst files to get e-mail from
one account, while the other pst file is configured to get mail from
the other account?
Yes, you can create multiple PSTs. I keep mine stored in
the same file location but with different names.
Depending on which version of Outlook you run, you can
creat a new pst from file/new/Outlook Data File (I run
Outlook 2003 but had multiple P...Custom cell formatting
I need to create a custom format for a series of cells that will begin like
I can't figure out what the code character is fora volitile potentially
Can anyone help me??
something like this might work for you but you'll need to put all the
leading digits in for the entry with the alpha character
"MDavison" <email@example.com> wrote in message
> I need to create a custom format for a series ...Count unique values
I've some problems to count unique items (Invoice #) in a pivot table. There
is the default solution "Add-a-new-calculated-column" as mentioned on
http://contextures.com/xlPivot07.html#Unique, but in my case, it doesn't
My problem is, that these values aren't in a Excel worksheet; it's a
external data source - a SQL-Select via DAO/ADO. Because of that, I don't
have the possibility to add a new column. Another reason is, that the pivot
table should always be dynamic: Group over this field, group over another
field - and always show the number of unique...Using Sumproduct when some of the values are null
I am having a problem using Sumproduct when some of the cells have
null values. I will try to describe the problem. Please let me know
you need additional information. Do any of you have any ideas of how
can fix that sumproduct to get it to work?
A B C
Row Trend Claims
5 Emergency $0
6 Emergency $0
7 Emergency $0
8 Emergency 81.68% $24,444
9 Emergency 35.00% $164,758
10 Emergency 35.00% ...Multiple Bar Codes Per Item
I'm looking to use Microsoft RMS for a medium sized game store with
one terminal. One critical feature is the ability to have multiple bar
codes assigned to the same item. Can RMS do this?
If you are talking about multiple part numbers, yes, use the alias function.
Remember what a barcode is. Its a graphical representation of a partnumber
that is machine readable. It doesn't describe the item, it is only a number
to reference that item. Just like your phone number, it means nothing, but
everytime someone dials that number, it gets to you.
"gareman" ...Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my
classes.(Alphabetized names down left vertical column. Dates across
top of horizontal row.) I added a different color to all cells in
every other row to make for easier reading of each student's name and
absences. Every other row stays with a white background.
My question: I wondered if it was possible to lock row colors while
allowing data to change on top of them. If a new student is added to
my class in alphabetical order, the alternating color pattern is often
lost. It is a pain to rechange row and cell colors.
Any shortcut ...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Error saving a Shared Workbook
I have a user using a shared workbook and gets an error
everytime she does this ONE specific change. She deletes
a line and then saves and gets a message that
says, "EXCEL.exe has generated errors and will be shutdown
by Windows... blah blah blah". If she makes anyother
type of changes it saves just fine. I also had another
user do the SAME change and that person also got that
error message. When the file is changed to "Not Shared"
then the line is deleted it saves fine also. The problem
is obviously with the file itself and that is shared out.
can anybody ...How do I break URL address over two lines?
I am trying to enter website addresses into footnotes and Word automatically
forces the footnote onto a separate line. I need to conform to certain
aditing requirements and want the url to start right after the citation and
continue on to however many lines are necessary, but not leave a gap because
it starts the url on a separate line in the footnote. Help please.
In the edit hyperlink dialog, put the URI in both the Address and Text-to-
display boxes. That way you can use a space or linebreak to wrap the display
text to the next line without affecting the hyperlink ability. Hyp...multiple look ups
A B C D E F G
1 PO TRANS $ $ AMT $ AMT QTY QTY
# TYPE AMT RECV VCHR RECV VCHR
2 4227 RECV 668 668 0 26 0
3 4227 RECV 2,415.80 2,415.80 0 94 0
4 4227 VCHR 722 722 0 26
5 TOTAL 3,084 722 120 26 2362.34
For column F and G, I need each QTY RECV to have a matching QTY VCH
(***See note at bottom) whereby ultimately, the total RECV QTY equal
the total VCHR QTY w...Formatting Cells in Excel 97
Sorry if I sound real stupid but is there anyway that we
can control the column formatting in Excel 97 like let's
say column A = GENERAL(6), column B = GENERAL(4), column C
= TEXT(18) etc?
Appreciate any form of advice, thanks!!
I replied in the programming group. Are you seeking a programming
answer? It's usually best to only post to one group, and include the
remark "Please tell me if I should ask this in another group."
On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <firstname.lastname@example.org> wrote:
>Sorry if I sound real stupid b...Getting Cell Value from the Concatenate formula
I built a concatenate formula that returns the following result: =Jul!
I am looking for the cell contents of Sheet: July Column D Row 27.
I tried to use offset, but I am stumped. Can I add something to the
front of the concatenate to not only build the reference to the cell,
but also return the value instead of the =Jul!$D27 ?
Don't include the equal sign in your formula. And match the name correctly (Jul
Depending on the name of the worksheet, you may need to have a string that looks
=indirec...Only one line in Money invoice
I have been using Money 2007 Home & Business to create and print invoices.
This program has run with no problems for some time.
However, just recently, it will only allow one item to print on the invoice.
I can enter more than one item, and the invoice entry will show the
additional items, but when printed only one item will show up.
I have tried backing up my Money file to a spare disk, deleting the program
and the associated mny and mbf files from the computer, reinstalling the
program and reloading the backup. The same fault immediately occurs.
Strangely, I have now installed the sam...collating information from multiple sources
Apologies if this has been asked before, but I'm a bit of a newbie when
it comes to mucking around in excel, I've had a search but I don't
really know what to call what I want to do, so finding the answer is
Anyway. I have a dozen or so workbooks that are all of the same
format, 1 work sheet with a basic list of test scenarios in each, with
a unique reference for each row.
What I'd like to do is pull information from all those workbooks into a
separate workbook by the use of the unique reference. i.e If I type
in the unique reference in the master workb...Multiple Item Forms
Hi. I am new to your form and am struggling with the Multiple Item Forms. I
want a combo box on the top that will select an id number from a table called
'SurveyA'. The multiple item form should then only display the records in a
table called 'ActTravDiary' with that id number. As the ID number is changed
a new group of records should be displayed in the form.
I know how to initiate a change in one combo box based on another combo box
(i.e. Row Source), but I cannot find a similar property for the multiple item
forms. Please help.
On Fri, 12 Feb 2010 21:00:2...find match then change cell value
In column A I have cells filled with text and in column B I have cells filled
with numbers. I need to check if the number in cell C1 equals any of the
numbers in column B. If a match is found then I need to change the text in
column A to CBO.
Column A Column B Column C
aep 5 7
Since the cell C1 = 7 equals the 7 from column B, I need to change the data
in column A from xle to cbo. Is this possible...what is straight line depreciation and double line depreciation?
In article <928DC52C-D390-45C6-9847-693648A1A5DA@microsoft.com>,
MISSY <MISSY@discussions.microsoft.com> wrote:
"JE McGimpsey" <email@example.com> wrote in message
Quite a good article for wikipedia, but it misses one very important point.
The original purpose of charging depreciation to the P&L was to build up a
reserve in order to replace the asset when it became obsol...VLookup #VALUE! error help needed to resolve
The following is the funcation I have:
=VLOOKUP(B10,'FA CC Summary Report 1141'!F$9:G$92,2,0)
I have all the columns formatted the same; as in the column that the
function is using to lookup is text and so is the column for this figure in
order to pull back the appropriate answer. I have keyed the data instead of
having links. I have replaced the final '0' with TRUE & FALSE then put it
back. I have formatted the columns for text and for numbers.
But I am getting the #VALUE! error in SOME of the cells NOT all of the
cells. I don't know what else to d...Detect cell colour
I have spreadsheets where 5 cells have general titles and have
different background colours. In other sheets, dozens of cells list
topics and are also colour coded to show which general title they refer
I need to tabulate information so that a row would contain three cells:
the general title, a topic and data about it.
Is there a command that returns the colour of the cell background, so
that I could use this to select the correct title to accompany the
Yes there is:
FontC = Worksheets("Planning").Cells(<Row>,