how can you view cells from different worksheets in to one sheet,.
I have multiple worksheets, more than 200 of them, and i wanted to summarize
some cells in to one sheet, I know how to do it by entering the code manually
(='7'!$D2), this shows cell d2 in sheet 7, but is there a function to do that
like drag or something?
You can use this macro myasin
Regards Ron de Bruin
"myasin" <firstname.lastname@example.org> wrote in message news:07759D01-70FE-416A-B54B-009646C2C365@microsoft.com...
> I have multiple worksheets, more than 200 of them, and i...picture is not showing up in Excel
I have a picture that is in an Excel worksheet. I can see the handles
and if I move the handles some, the picture will show up. However, it
will not show up in print preview at all or page break preview. I can
open the same file on another computer and it will show up fine.
Any help would be appreciated.
Tools -> Options ->General
Do you have "Show All" selected for Objects?
> I have a picture that is in an Excel worksheet. I can see the handles
> and if I move the handles some, the picture will show up. However, it
> will...Embedded pictures
I noticed that the when we set the picture property of a button or another
control as embedded, it takes a lot of place.
Is there an explication that show why the Access file encrease in size by
more than the picture size (even if it is a bitmap, a format that is normaly
An mdb without picture would take 4 MB
the same file with pictures would increase to 40 MB with only 400 KB of
pictures. In JPEG format.
Is it because Access uses a non efficient compression to include the image
Thank you in advance for any suggestion!
PS: I know that I can set the pictur...Pictures don't print in outlook 2000 or 97
How do I get pictures to print when I print messages for Outlook 2000
or Outlook 97. I'm using XP Home.
Have you checked to make sure you have all of the latest Windows and Office Service Packs installed? I remember this issue from a whle back, and it was corrected in one of the service
Scott Atkins MCSE, MCSA
Partner Technical Lead - Outlook
Microsoft Technical Support
for Platforms and Business Applications
>Subject: Pictures don't...Find a empty cell in next column
Dave helped me with this before, now i need more help.
I use this code to find a column called PoF and the numbers written in the
cells below it. This code work in every row/column (i dont need to name it).
PoFRow = 0
PoFCol = 0
On Error Resume Next
PoFRow = Worksheets(2).Range("PoF").Row
PoFCol = Worksheets(2).Range("PoF").Column
On Error GoTo 0
If PoFRow = 0 Then
MsgBox "No range named PoF on worksheet:" ' & .Name '
Set numberPoF = Nothing
On Error Resume Next
Set num...Inserting picture from "My Pictures"
When I add a pic from "My pictures" the entire picture does not appear on the
slide and when I try to format it it is impossible to get it back to the same
pic I am attempting to add. If I am trying to add a pic I might only get a
nose or a blade of grass instead of the original picture from "My Pictures".
Reduce the zoom to 10%. Coul be a too large image
"PP Neophyte" <PP Neophyte@discussions.microsoft.com> a �crit dans le
message de news: CA5F97E6-D4D8-401B-B066-E261024F082F@microsoft.com...
> When I add a pic from "My pictures" t...Need event macro to tab past a (calculated) cell
I have an Excel 2003 List (aka Table in Excel 2007). There are some
protected (calculated) columns that I don't want users to enter data into.
But I can't protect the sheet, because that prevents users from entering a
new record at the bottom of the List.
Does anyone have a suggestion on how to deal with this? I'm thinking of
using an event macro invoked when user tabs out of say column C, which makes
the selection skip the cell in column D and go directly to the cell in
column E. I guess I'd have to use Worksheet.SelectionChange. But I don't
know how to do...Picture in Publisher
When inserting pictures in publisher the picture does not show. I can see
the frame. The same thing when I load a publisher file created by someone
else. All the inserted pictures does not show. View>pictures is set to
Any suggestions for a solution?
Read the third FAQ here
Mary Sauer MSFT MVP
"Thor" <Thor@discussions.microsoft.com> wrote in messag...validity of a cell
i want to set a cell so that only text (alphabet) can be written there. when someone try to write number there error message will come out.Please help. thank u
One way, assume it is A1 that you use, do data>validation>allow>custom
won't obviously work for mixed letters and numbers like A2 which
can be entered.
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"melirus" <email@example.com> wrote in message
news:D7180552-315C-4DB4-...append a string of text to all cells in a column?
Is there a way to do this?
The cells that I want to append to all contaio plain text.
Assuming column of text is A
In B1 enter =A1 & "textstring"
Double-click on the fill handle of B1 to copy down.
Gord Dibben MS Excel MVP
On Wed, 14 Feb 2007 17:37:14 -0500, "Lisa Hetherington"
>Is there a way to do this?
>The cells that I want to append to all contaio plain text.
"Gord Dibben" <gorddibbA...picture in picture
Have to digital pictures & would like to put a couple of people on one
picture into the other picture. How do i do this? Anyone got any ideas? TIA
"ted medin" <firstname.lastname@example.org> wrote in message
> Have to digital pictures & would like to put a couple of people on one
> picture into the other picture. How do i do this? Anyone got any ideas?
Well not with Vista. You need a Graphic editing application.
The Gimp may be able to do this. (It's free, Open Source but is a bit tricky
yo get to lear...format cell #3
I have this in a cell; "2 vs 3" (without quotes), I want
to find and replace it with "2 - 3" (without quotes).
When I do this it either turns it into a date or a string
of five numbers. I have formatted the cell to be "text"
or "general" yet it still converts to a date or a string
of numbers. I would appreciate any help, thank WAB
Try replacing with '2 - 3.
Using the single quote at the beginning will force to maintain the text.
Don't worry, the sinqle quote will not show in the cell.
"wab" <anonymous@discus...Formatting Cell #2
I have a block of text that I auto corrected and shows
corrected in the Normal view. However, when I preview the
sheet there is space between cell above it and the text in
my cell. I want the text to come all the way up against
the cell above it. How do I fix this?
Format-Cells-Alignment tab. Set the vertical text alignment to "top."
"Mike" <email@example.com> wrote in message
> I have a block of text that I auto corrected and shows
> corrected in the Normal view. However, when I preview t...Picture Link
Appreciate some help here and thanks in advance.
I link my pictures to the following folders
C:\Documents and Settings\MyName\Desktop\Picture.jpg
C:\Documents and Settings\MyName\My Documents\Picture.bmp
If Me!pic1a = "X" Then
Forms!startpg!fmpPic!Img.Picture = ""
Forms!startpg!fmpPic!Img.Picture = Me!pic1a
It works on my PC but when I copied the program to another PC, it does not
This is because of "MyName" and the other PC has a different name. Is there
a way to ignore "MyName" for any PCs
"ChoonBoy&quo...Sending pictures with text and then another picture with text.
I receive some e-mails with text and then a picture with more text and again
a picture. Some of these will have 8 to 10 pictures with text under each
picture. But when I send it out it is received with all of the text in a
group and the pictures are all sent as attachments. How do I get my e-mails
to send the pictures and text the way I receive them? Thanks for any help
you can give me. Bob
...blinking or flashing cell or cells
I want a cell or string of cells to flash or blink constantly when i open the spreadsheet. It does not matter if the text or background blink or flash. Is this possible?
Possible? Yes. Recommended? No. Why? Slows down the
processing time. But a search through the google archives
yielded a lot of solutions. Here's one from MVP Chip
>I want a cell or string of cells to flash or blink
constantly when i open the spreadsheet. It does not
matter if the text or background blink or flash. Is this...Picture in header
How do I get a picture in the header?
This was added in xl2002.
File|Page setup|header/footer tab|custom header
There's an icon that looks like a picture near the far right.
> How do I get a picture in the header?
If you are using a version of Excel before 2002 then check out:
for a workaround.
"Dave Peterson" wrote:
> This was added in xl2002.
> File|Page setup|header/footer tab|custom header
> There's an icon that looks lik...Extract data from a cell after a constant value
I have a spreadsheet that contains 1 column of data, if the cells of the
column are the city names and populations of towns in the following format:
Appleton, Wisconsin (WI) (pop. 70,087)
The 'pop.' is always present.
I want to extract just the population number (ie: 70,087) from these cells
into another cell.
What is the simplest way to accomplish this?
On Sun, 19 Aug 2007 12:29:37 -0500, "Wolfman" <firstname.lastname@example.org> wrote:
>I have a spreadsheet that contains 1 column of data, if the cells of the
>...Can pictures be centered in a picture frame in a catalog?
I have created a catalog for items we sell. I have added the pictures to the
catalog through the Excel worksheet. When the worksheet is imported, all of
the pictures left-justify in the picture frame. Can this be centered?
...Cell colour according to date
Is there a formula that would change the cell colour if a date in a cell was
out of date afetr a set number of years.
Cell B9 contained date 140506
I then want the cell B9 to turn red when the date reaches 2 years later
Thanks in advance
Let's assume that your example date is 14 May 2006.
Click on B9 and:
Format > Conditional Formatting... > Formula Is > =TODAY()-B9>731
then pick the colour red.
Gary''s Student - gsnu200773
Use conditional formatting with a formula of
Our company goes through a budgeting process every year utilizing fairly
complex Excel spreadsheets.
These workbooks are sent out to the department managers shared so the
changed may be merged when they are returned with their changes.
This process of sending and returning is repeated numerous times thoughout
Everytime the workbooks are returned we upload into our SAP system.
When a workbook is returned to me again...I only need to upload the cells
that have CHANGED...which makes the upload process MUCH faster.
How can I identify those cells that have had their values changed...thumbnail in CListCtrl cell
Hi there, I've found ways to put icon in a CListCtrl
(report view) cell. But when I tried to change the icon to
a bitmap, which is bigger, the reults is just empty cell.
Is there any way to enlarge the cell so that my bitmap
could fit in?
How about this source,
I made it and still have some problem in thread, I think it can help you.
...attaching pictures as an icon
Hi I am trying to save memory in an excel report and I
wish to include a picture in this report as an icon that
shows the picture when selected.
If you're going to try to save memory in the workbook, then it sounds like the
big picture will be outside excel (a common LAN folder???).
If yes, then maybe you could create thumbnails of each of your pictures (using
????) and then add a hyperlink to each thumbnail.
The hyperlink would use whatever program is associated with the extension to
open the big picture--outside of excel completely.
(I don't know how you'd include the big p...Counting cells with specific month in
How can I count the number of cells in date format which contain a certain
How can I count the number of cells in column A which contain an October
date. The answer here would be 2.
Try this formula (set the month number, 10 in this case, as needed)...
Rick (MVP - Excel)
"JRD" <JRD@discussions.microsoft.com> wrote in message
> How can I count th...How do i change the cells in a column at the same time in Excell?
You post is way thin on details and to insure you get some goo
feedback, it is important to take the time to be a specific as possibl
about what you want to happen.
That being said; here is an example of changing an entire column'
If you want to apply the same formatting to all the cells in a column
click on the column letter A,B,C........, you will notice that th
entire column is highlighted. Now, go straight to Format>Cells an
begin selecting the formatting changes you would like. These change
will be applied to the entire selected column.
Hopes this helps,