| Thread | Last Post | Replies |
|
| protect custom toolbar from being changed ? | 29 Jan 2008 01:14 GMT | 4 |
as the subject suggests... :) is it possible and if so, how ?
|
| How to Print Protect | 29 Jan 2008 01:07 GMT | 2 |
This may be a real easy question but I can't find it in the help file. How do you put a write protect on a workbook that will not allow someone who opens it to save/copy/print? An example for use would be a financial type document.
|
| Finding Similar Data in worksheets | 29 Jan 2008 00:59 GMT | 4 |
I have a list of contacts and would like to compare it to another list from a different department to find duplicates. The issue is that some of the information on both lists are recorded with slight variations (one includes Inc. while other doesn't, etc...). Normally,
|
| how to proctect a workbook, then allow updates to be seen as read | 28 Jan 2008 23:41 GMT | 2 |
I'm working on a work book that I want to be able to make updates to and allow other people to open the file as "read Only" and see the changes I made. I can't seem to get to work.
|
| If Function with multiple variables | 28 Jan 2008 23:33 GMT | 2 |
On a worksheet, I am using an If function, but now I need to add a second set of variables to that If function, how can I accomplish that?
|
| Multiple Workbooks. | 28 Jan 2008 23:32 GMT | 1 |
On every other computer I've ever worked on when I open up a second or third workbook I can go back and forth to them using Ctl+Tab. On my home computer this does not work. Ctl+Tab just goes to the current workbook in Excel which, if I am already in Excel means it goes nowhere. I ...
|
| Count Check Boxes across Sheets | 28 Jan 2008 23:26 GMT | 3 |
Hi I'm trying to count check boxes across multiple sheets. I tried = COUNTIF(Start:End!A2, "TRUE") but that didnt work, is there another way of doing this? Thanks! I dont think it matters but I am using Office 2003. Thanks again!
|
| How to count duplicate or repeat values | 28 Jan 2008 22:55 GMT | 12 |
Hi friends, I have 6 columns with 100 names, I would like to count how many the names appear in the differnt columns and have the results on the same or another sheet with the number of times the name repeates
|
| Need a to automatically create a new excel from every sheet | 28 Jan 2008 22:35 GMT | 1 |
A customer sends us an excel file with over 20 sheets in it. In order to upload it to our main server in need to manually create a separate excel file from every sheet and name it by the name of the sheet.
|
| Reverse VLOOKUP | 28 Jan 2008 22:34 GMT | 1 |
Okay, I need help with pulling data when the Col_Index_Num is to the left of the lookup value in the array. I tried the following, with a negative 7 thinking it would do the opposite...drive 7 rows to the left but it did not work.
|
| Reverse VlookUp | 28 Jan 2008 21:55 GMT | 1 |
I cant find the post I made last week RE: making a vlook from column index number to the left of the target number. I know thee was use of index and match, but I am not familiar. Can someone please help me - thx
|
| Calender Generation | 28 Jan 2008 21:41 GMT | 5 |
Hi I was wondering if you could please help I have made a calender in Excel for this year 2008 on sheet 1 it just shows a table devided into 12 months with the relevent dates My Question is can I get it to generate a calender 2009 with the with the
|
| Cells.Find with a variable | 28 Jan 2008 21:30 GMT | 4 |
Reposting since I can't find the previous question. I have a spread sheet that contains 2 columns and multiple rows: WORKSHEET1 ProgamName Level
|
| Move list to different tabs | 28 Jan 2008 21:25 GMT | 2 |
I have a spreadsheet with a list of data. At each change in, for example, the date, there is a page break. Is there a way to take to data and put it on separate tabs (at each page break or change in date)? I would rather not copy and paste large amount of data onto 40 separate ...
|
| Working with vlookups | 28 Jan 2008 21:21 GMT | 4 |
How do I use the vlookup function (or else) to find data from 4 different sheets? For example I need to extract information about a part # but the list is 4 sheets long. The part #'s are numeric and alphanumeric. The report is 4 sheets big full of inventory data (for example Part ...
|