Moving thru sheets in Excel
Hi I'm new to this community but use excel a lot. I'm stumped by this one
though : suppose I have column in one particular sheet with say all of the
names of the top footlball teams in individual cells in alphabetical order
down the column. I also, say, have another sheet in the same workbook with a
similar column of the same names but in this case it's their position in a
league . I would like a macro so that I can move the cursor on a team in my
first column, then cnrtl"x" and I move to the same team on my next sheet.
I can't work this one out to save my liv...Out of Office- not working externally
Hi, OoO suddendly stopped working to emails sent from external domains (ie
OoO is only working within our own exchange domain).
I then done the following:
Using the Exchange System Manager, open Global Settings > Internet Message
Formats, right click "default" (on the right hand panel). Select Properties >
Advanced. Tick the "allow out of office responses" box. Click apply/ok.
This box wasn't checked, but since I have checked it the problem still
occurs. Does it take a while for it to be come effective? Anyone have any
This should wor...Different charts for different salesmen
I have a spreadsheet which shows, in rows, the type of business brought in
by different salesmen. It also has a column which has each salesman's
initials in it. So the seller in each row can be identified.
The relevant part of the spreadsheet looks like this
Initials Date Product
Initials Date Product
Initials Date Product
Initials Date Product
I want to produce a chart of the business types sold by each salesman.
Obviously I can do it for the whole firm but how do I produce a chart for
You need to prep the data. You could simply filter the dat...highlight cells not working with wireless mouse
Excel 2007- When highlight a cell using a wireless mouse, it highlights more
than one cell. For example, I want to highlight cell D7; but it also
highlights D8,9 and 10. I can't get it to highlight the one cell. Is this a
problem with Excel 2007?
No, it is a problem with your mouse. I have a wireless mouse and have no
trouble selecting a single cell. Is that what 'highlight' means?
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"cpajdc" <email@example.com> wrote in message
news:A1A4E886...Copying spreadsheets-did not work
Still don't have a clear answer. The problem is this... I,m trying to save
only a portion of a spreadsheet I have created to another folder. Each time I
copy and paste, it copies the entire spreadsheet and not just what I have
Dave, using |goto|special|visible cells only....had no effect. please advise
It's better to stay in the same thread.
Do you have both workbooks open in the same excel instance.
Close excel (as many as you have open).
Then open excel
Then file|open your first workbook
then file|open the second workbook
Then try the copy|paste.
tazsdad wrote...converting PDF to Excel Sheet?
Hello, I would like to convert a PDF to Excel using a simple linux
command line tool. Anyone know if that is possible? The tool coul
also be a windows tool, but I am looking for a tool that is completel
automated, with no user intevention.
The reason is that I have a program that downloads PDFs every hour o
so, and I would like to convert that pdf to an excel sheet so i coul
grab data off it easily.
Or maybe, does anyone know of an easier way to grab tables informatio
Message posted from http://www.ExcelForum.com
Take a look at
PDF and Excel
http://www.mvps...Return to main sheet
I was wondering if there is a way to always return to my default main sheet
after a macro runs.
What I have is the following:
1. Three sheets (Master, Name, Invoice)
2. Macro to create additional Invoice tab (Invoice2, Invoice3, and etc...)
3. After the invoice macro runs, it has the last invoice sheet in focus.
What I want is, once the macro executes, to return focus back to Master. Is
Thanks for any and all help with this
On Nov 14, 1:20 pm, "Charles Reid" <cr...@satx.rr.com> wrote:
> Hello All,
> I was wondering if...Excel 2007 display and print are different for different users
I have 2 users that open the same spreadsheet. The spreadsheet shading looks
quite different on both displays and prinnts the different shading. They are
both using the same 2007 version of Excel and printing to the same printer
...Permissions set on Word files differ from other permissions
We have a peer-to-peer network in Windows XP Pro. On ONE of our computers,
Word documents do not get the same permissions for sharing that all other
files get, or that all files on all other computers get. As a result, we
can't copy Word files from this one computer. That computer is set to give
"Everyone" "Full Control"; yet the individual Word files keep getting set to
NOT give "Everyone" "Full Control". Why would Word override the other
security settings, and how can I make it stop?
...Reverse a Macro
Thanks for considering this problem!
Is there a quick and simple way to reverse the events performed by
Hopfully there is a type of "back button" process, short of writing th
macro in reverse which can be very time consuming on complicate
spydor's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2843
View this thread: http://www.excelforum.com/showthread.php?threadid=49746
As far as I know there's no simple way to reverse the actions of a ma...Labels-creating different labels on the SAME page
I would like to print a set of labels, however, I do not want each label to
be exactly the same as my sheet of address labels are. I would like to number
the labels and print a sheet where each of the 30 labels on the sheet has a
different number on it.
How do I make each label on one sheet different?
Use a mail merge. Numbers instead of addressees. :-)
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"camionneur" <firstname.lastname@example.org> wrote in message
news:B8ECA494-24C7-44DE-...How to fill a sheet in Excel2003 with CSV data?
I use server-side calculations in an OWC(Office spreadsheet component)
send the resulting data as string (formatted as CSV) to my Client. Ho
can I fast fill an Excelsheet(2003) with this data passed as string
Must I loop through the CSV data? When saved as file (.csv) on th
server I can open the .CSV manually on the client fast like opening a
ordinary .xla file. But how do I do it programmatically when the cs
data is in a string on my VBA client? Cannot find the correc
Message posted from http://www.ExcelForum.com
If you paste it into Excel you can use Text to Columns
same as ...accessing sheets stored in add-in
I have an add-in that I built, with some worksheet templates in it. I
want my co-workers to be able to use the toolbar that I built for the
add-in to access the sheets that are in the add-in. Kind of like
unhiding them. How can I do this with a macro attached to the menu
Are you sure an addin is the best way to go?
The addin is a hidden workbook. And to make it so that the user can see the
worksheet, you'll have to change the .isaddin property to false. Then you can
display the worksheet that you want.
ThisWorkbook.IsAddin = False
&...Different Domains with Different GALS
I have read the some options and guides as to how to approach setting up AD
and Exchange to host multiple mail domains. Basically AD is separated by OU
and Exchange by security ACL - this from MSEXCHANGE.ORG.
Has anyone set this kind of thing? The goal is basically have separate GALS
for the users and not see the other GAL.
Microsoft has the service provider kit, but we are NOT service providers -
but a company with multiple subsidiaries.
On a high-level, how should we set this up?
...Edit : Find....not working between sheets
I have created a workbook that shows supplies for 20 differen
cabinets. Each cabinet is listed on a worksheet. When I want to fin
a particular item, I select all the sheets and go to Edit, Find an
type in the item and it takes me to the correct cabinet. The problem
am currently running into, is that if there are the same item i
multiple cabinets, it just goes to the last one, instead of starting a
the first one and continuing forth. So....If I have gloves of differen
types in cabinet 1, 4, and 7 and perform this function, it should tak
me to 1 and then when I click on Next, it s...Different TAX schedules in stores
Does anyone know if you have one store set as "Tax Exclusive" and all other
stores set as "Tax Inclusive" will this cause a problem with HQ?
Every store has it own preferences and paramters so there is no problem and
HQ will work fine in this.
> Does anyone know if you have one store set as "Tax Exclusive" and all other
> stores set as "Tax Inclusive" will this cause a problem with HQ?
I should have been more clear though, I knwo it won't cause a problem with
th...finding differing numbers.
How do I in a column of numbers some in duplication, how can i get a list off the entries which reflects these numbers but not in duplication. ie "numbers" 1, 1, 2, 3, 4, 5, 1, 5, 3, 5, 2, 1, 2. "result" 1, 2, 3, 4, 5
- select your column
- choose 'Data - Filter Advanced Filter'
- choose a new range and 'unique entries'
> How do I in a column of numbers some in duplication, how can i get a
> list off the entries which reflects these numbers but not in
> duplicat...Day and time difference
I am trying to get the difference between date and time.
Start Date End Date Completed within
12-1-09 8:00 AM 12-3-09 8:30 AM no. of days hh:mm
How can i get it to calculate the difference between the no. of days and the
look into CPearson web
"Shweta Srivastava" wrote:
> I am trying to get the difference between date and time.
> Start Date End Date Completed within...Referncing Problem...
I would really like the help for this problem, please!!!
In my XL macro, I am referncing another XL file to get some macros
from it. The problem is that one of these macros closes the XL file
that contains it. I could not modify this macro to prevent it from
The problem is that I am getting an error which says that the file
could not be closed because it is being by other files (which is my
How can I solve this issue!? How can I call a macro from another file,
which closes the XL file that contains it without getting this
Tahnx in advance
...How to make different cells fill in automatically from one entry?
Hi, I have a workbook with three sheets: Activity, Expenses, Income.
I only want to enter data on the Activity sheet.
I select the date, I select the DESCRIPTION (matches the sheets Expenses and
Income) and I select the Category (Categories match columns on Expenses and
Income sheets). I already set up the selections, the Category is a data value
dependent (indirect) function.
When I enter data on the Activity sheet I want it to appear automatically
where it belongs on the Expenses or Income sheets. - in the row for the date
(already there) in the column for the Category select...Taking out duplicates from a single sheet
I have a sheet with 12k rows with multiple duplicate records. Is there
a formula driven way to delete the duplicate records?
This is a list of companies with multiple contacts, so I am looking for
a way for example to take the 6 or 7 identical records of John Smith and
leave the other 5 or 6 contacts for the same company. Now that I'm
typing this I'm realizing that in a list this big the likely hood that
we have the same first and last name is pretty high.
I'm sure I need to provide more detail but I don't know exactly what I
would need to provide.
Pok...hyperlinks in different drives
I'm creating a spreadsheet that hyperlinks to about 50 differen
documents. Eventually, i want a CD to contain the excel file and al
the hyperlinked documents. To get the hyperlinks to run from the cd,
had to change all of the hyperlinks within my spreadsheet to the E:
(this is the drive where my burner is). I then inserted the cd into
different computer (D:\) and none of my hyperlinks work anymore? I
there anyway to make sure that the excel hyperlinks open to the file
stored on the cd, regardless of which drive it is in?
thanks in advance,
------------------...Fill color in Excell 2003 does not work?
I have upgraded from Excell 2000 to 2003. I also have purchased a Compaq
nx9600 with a 17" wide screen display. For some reason the "Fill Color"
formating/shading tool will not work. Nor will changing the text color.
Any suggestions to fix problem?
See MSKB article # 320531:
'Changes to the fill color and the fill pattern are not displayed in Office
"Mike Golfer" <Mike Golfer@discussions.microsoft.com> wrote in message
news:F63E2613-C065-4379...Does Word / Office 2003 work in Windows 7
Can anyone tell me if Word / Office 2003 works reliably and stably in Windows
It is time for a new computer, and Windows XP is generally unavailable on
the new computers and I simply do not wish to spend the time to learn a new
set of menus in Word / Office 2007.
As a general gripe, the biggest benefit of Windows over the years is that
the menus were always similar between Windows versions and most of the
programs that ran on Windows. Re-arranging the entire menu structure for no
reason seems more like a move to discourage upgrades rather than promote them.
Can you create different "personalities" in Outlook like
you can in Eudora? That is, can you set up several
different addresses to send from? How? I couldn't find
anything in the online Support Center and I don't use
Outlook (my boss does).
Tools-> E-mail Accounts...
Additional instructions depends on the version of Outlook.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and Restore
-Create an Office XP CD slipstreamed with Service Pack 3
"justturn" <email@example.com> wrote in ...