We have a shared workbook that about 15 staff share and update info on their assigned sheets. Lately when we open the workbook some of the sheets are missing, they are deleted and no longer exist. This is a problem since these sheets link to other workbooks and when they disappear they cause errors in the other workbook. Any ideas why this is happening? Thanks.
We have a shared workbook that about 15 staff share and update info on their assigned sheets. Lately when we open the workbook some of the sheets are missing, they are deleted and no longer exist. This is a problem since these sheets link to other workbooks and when they disappear they cause errors in the other workbook. Any ideas why this is happening? Thanks.
I have to load the data in Sheet 3 but before I do that I have to make sure that a ny organisation name that already exist in either Sheet 1 or Sheet 2 should be removed from Sheet 3.
Sheet 1 has 226 Organisation Names
Sheet 2 has 62 Organisation Names
Sheet 3 has 664 Organisation Names
I do not know how to write a Macro, nor d o I know how to write code.
Can someone help with a formular or code? or is there another simple way to do it?
Hi
I am trying to create a a excel model that will let me Update, Insert and
Update on one excel spreadsheet, some of the information will be then
reflected in another excel sheet (same book) I can do the update by using
'=Sheet1!A1'. but if I delete this gives a #ref error and insert rows is not
reflected.
Thanks for help or suggestions.
Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
Hy guys,
I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help
Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.
-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?
Thank you.
Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub
Ok, first I want to thank everyone for helping me with my last question. I have a new question:
Is there a way I can delete all worksheets EXCEPT 4 hard named sheets; i.e. Data Entry, Time Sheet, Service Ticket, Setup.
Same project as befo http://www.box.net/shared/owqeow144c
I create multiple service tickets and on Monday would like to be able to click and remove last week's tickets and clear out the data entry. I know how to clear the data entry information but not how to delete all but some worksheets.
I thank you all in advance for any help you can provide.
Thanks,
Dave
Hi Everyone,
Do you guys have a site similar to the site the word folks have below for
creating and manipulating pivot tables? We would like to learn how to
create pivot tables in excel 2000, we will soon be getting Office 2003 but
will be keeping 2000 also. We also have some money in the budget for some
books. Do you have any recomendations? We work in the medical field so are
not computer geeks yet so we need books that are geared towards non
programmers. Our excel use is mainly for tracking outcomes and not a lot of
heavy math. I have a couple of database books that were recommended for
using Access from the Access group. One is Access 2000 from QUE and
Database design for mere mortals was another and both have helped out alot.
We would like books similar but for Excel.
http://www.word.mvps.org/FAQs/Format...ingColumns.htm
Thanks,
Linda
