TAB Name Linked To Cover Sheet

Jul 31, 2009

I have a workbook that has a cover sheet which contains the names of all the tabs in the workbook. I need to be able to change the names in the cover sheet and the names in the tabs to be change to whatever the corresponding cell in the cover sheet text is.

View 14 Replies


Make Macro To Bring Tables From Another Sheet To Cover Sheet?

Jul 8, 2014

I am trying to take the tables you will see in the dummy page on the second and third sheet and have them output onto the first sheet based on the parameters of the drop down menus. Is there a way to have a button on the first page that controls a macro to do this?

View 4 Replies View Related

How To Print Cover Sheet In Front Of Database

Jan 21, 2013

I have 36 pages of names, addresses & contact info ETC that I want to print. I have a printer that offers a cover sheet in the print setup.

My list of names addresses ETC takes up two full pages of paper for each name. There are 16 columns across the sheet that contain data for each entry. I would like to print this so that I can turn the pages like an address book and see all of the data for a given set of contacts on each two page spread. So what I need to do is print the first half of the contact info on the inside of the first page and the second half on the next page and so on.

How can I set this up?

View 4 Replies View Related

Deleting Linked Sheet Causes #REF

Jan 5, 2007

I have a Main sheet that has many formula on it that link to several Data sheets. Now sometime I want to delete the data sheets and recreate them by copying a Data template sheet and remaming it to the same name as whatever my data sheet was called.

I see that this basically causes a Ref#! error in all the formula on my main sheet so when the data sheet is recreated it wont recognise it.

How can i stop it changing the formula path to Ref#!?

View 3 Replies View Related

Sorting A-Z Linked List In Same Sheet?

Mar 11, 2009

I have a list of movie titles A3-A9999(Infinity), their disc numbers in B3-B9999(Infinity). The titles being written in text, of course.

All I want to do, is have another list, in the same sheet in D3-D9999 that will be the same list as the original list that I input movies onto, except alphabetical and automatic from when I type in the movie title in the original list. When i just use "=A1, =A2, =A3 ~~~ =A999" in the D cells, then try to sort, it only sorts by the cell numbers, not by the actual text that I want it to.

Is there a way to do this? I know excel relatively well, but I'm definitely a noob compared to experts.

View 4 Replies View Related

Missing Sheet In Linked File

Jun 14, 2007

I have a summary file in which I capture data from multiple sheets in one existing file (targetfile.xls).

One month might contain sheets that do not exist next month. When updating (edit) links, Excel reports an error (invalid external reference) on the first missing sheet, and does not continue checking/updating links for the rest of the document.

I tried =IF(ISERROR( SUM('[targetfile.xls]sheet1'!$M:$M)),0,SUM('[[targetfile.xls]sheet1'!$M:$M)),

View 3 Replies View Related

Auto Copy In To Cell On A Linked Sheet

Feb 2, 2010

I am wondering if there is a formula/macro/VBA that will find the last date entered in a column and fill that date in to a cell on a linked sheet.


sheet ONE has columns C through S. (each customer has its own sheet)
On this sheet, in column H the date of the last payment made is entered. This date of course changes as payments are made, so the row would change as well.

sheet TWO has columns C through O. (all customers on this one sheet)
The rows on this sheet remain the same for each individual customer.
I would like the last date entered on sheet ONE column H to be auto copied to sheet TWO column O.

Is there a way to have the last date entered on sheet ONE auto copy to Sheet TWO?

View 9 Replies View Related

Listbox Values Linked To Sheet Names

May 25, 2007

I have created a userform in excel with a listbox that has the names of 4 different sheets located within that workbook. I would like for whenever a name of the sheet is highlighted in the listbox, that sheet is opened. I have played around with the listbox.value and if then statements and can't seem to get it to work.

View 2 Replies View Related

Excel 2010 :: One Sheet Linked To Another File Just For Visualization

Mar 6, 2013

I have a workbook with several sheets with formulas, etc. one of the sheets its like a "resume" of the workbook. I want that sheet with the "resume" to be visualized by other person's without giving the access to the workbook.

The idea it's a file with linked data with the workbook that have the sheet with the "resume". When I change some data in the workbook the file with the linked data must be updated when someone open it and cannot edit, it is just for visualization.

View 5 Replies View Related

If Then Statements Linked To Data Validation Lists On Different Sheet?

Apr 13, 2014

On Sheet1 I'm attempting to auto populate specific cells in columns B,C & D with information found in Data Validation lists (found on Sheet2) based on the "value" chosen from a list in column A. For instance,

If A2=Pig Then B2=Slop, C2=Pen, D2=Food

Is this best accomplished through VBA or a basic Function?

View 5 Replies View Related

Find And Replace :: Cell Moving Down In Linked Sheet?

Jan 26, 2010

I have a spreadsheet which is linked to other spreadsheets. When I use "find and replace" on this spreadsheet, it causes one of my linked cells to move down one row. Why does it do this? This particular cell has nothing to do with the "find and replace" option.

I have no idea how to stop this from moving this cell down.

View 9 Replies View Related

Excel 2007 :: Data Validation List Linked To Different Sheet?

Dec 11, 2012

I am using excel 2007

I am attempting to put a drop down list using "Data Validation". I can get it working when my list is on the same sheet (sheet 1) and the column of cells I want the drop down list to show up in....(you know..when the drop down list shows up in each individual cell)......BUT...when I put the list on another sheet (sheet 2) and try to do the "Data Validation" back on sheet 1, excel won't let me go highlight the list on sheet 2.

I even tried writing sheet2 and the range and that still doesnt work.

View 1 Replies View Related

Prevent Linked Cells Showing Error When Deleting Rows On Other Sheet

Feb 14, 2013

I want to establish a link from my worksheets. Using the conventional link method I was able to link the values from my first worksheet to the second worksheet. My problem is when I delete a particular row. The reference of the second worksheet will have an error #REF! since I deleted those cells. Is there any way that I can link my two worksheets without any error that even if I deleted a particular cell/row the reference is still intact?

View 2 Replies View Related

Cell Cover Up

Jul 17, 2008

What i need is someway of when ever these certain numbers:


are entered into any row on column 1, then are automatically blacked out and un readable untill the cell is changed to another number.

View 9 Replies View Related

Disable User Access To Master Sheet Through Doubleclicking Locked Linked Cell

Feb 23, 2010

I have a master spreadsheet that houses most of the information that remains in my control, and several other user spreadsheets that update cells from that master through links.

I am having some problems lately with users doubleclicking the locked linked cells in their workbooks, and excel then wanting to open and give the user access to my master spreadsheet. Is there a way to disable this feature? I would like it to not even acknowledge the action if that's even possible because it confuses them as to why they are getting a prompt to open another document.

View 5 Replies View Related

IF Function To Cover Several Columns

Oct 18, 2007

I am need to setup an IF Function to cover several columns. I need the function to be able to look at Column A, B, C, and D and see if any are blank. If any of these is blank I need the function to give "Pending". If all of these columns have a Y then I need the function to give me "Completed".

View 9 Replies View Related

Create Shape & Cover To The Last Used Row

Jan 18, 2010

Is there any way that this bit of code can be combined to create a shape using dates that fall on weekends (that are listed in row2) and at the same time cover all rows up to the last Row used in a worksheet?

For instance, in the columns of Row2 we have many dates and we would have "16-Jan-10" in one column and "17-Jan-10" in another column (usually the next column) which are weekend dates. the shape should be created in the next row under the weekend date and cover the column all the way down to the last used Row (last Row contaning data).

With ActiveSheet.Shapes.AddShape( _
Type:=msoShapeRectangle, _
Top:=.Top, Left:=.Left, _
Width:=.Width, _
.Placement = xlFreeFloating '
.Fill.ForeColor _
.RGB = RGB(Red:=192, Green:=192, Blue:=192)
End With

View 9 Replies View Related

Getting Dates To Cover Week Numbers

Jan 10, 2014

I wanted to work backwards from a weeknumber (as defined in Excel). In other words, given a week number (i.e. 5) what is the first date and last date of that weeknumber. These are the formulas that I came up with and they work fine.

Formula: [Code] ......

Ffor 1st of the week and

Formula: [Code] .......

For the last of the week.

Attached File : Weeknumber.xlsx‎

View 5 Replies View Related

Calculate Time To Cover A Distance

Aug 6, 2014

this is normally a very simple thing to calculate and I know how to calculate for speed, distance and time or SoDiT as we learnt at school..

I have a period of time where a distance in feet is covered. Lets say 1 hour 25 minutes to cover 12,600 feet, just over two miles.

What I need to solve for in this case is not speed exactly, but how long it takes to cover 10 feet in this scenario.

I start to do the math in excel and then the formatting jumps when I set to hh:mm:ss and I get confused whether I'm multiplying or dividing by 60 and it all becomes a mess.

View 4 Replies View Related

Insert Shapes That Don't Cover The Grid?

Apr 5, 2009

I have tried to make cartesian coordinates (X)and (Y) using excel 2007. now I want to represent some shapes (circles, squares, triangles, and so one). My problem now is with formating those shapes. I use this path (Insert > Shapes),, but the shape I add cover the grid,
I want (for example) a circle but I need only its circumference, and without covering the grid by its area. the same for other shapes.

View 3 Replies View Related

How To Make Worksheet Cover All Of Paper

Jan 17, 2013

CK Nursery and Finish Inventories.xlsxAttachment 207447

I would like the "Finish Summary by Age" tab worksheet to look like the "Nursery Master Sheet" and "Circle K 1 - CD Farms Nursery" tab worksheets. I'd like the "Finish Summary by Age" tab worksheet to cover the majority of the paper like worksheets on the other tabs.

View 1 Replies View Related

Creating Cover Worksheet Called Averages?

Feb 8, 2013

I have attached a workbook with various worksheets. the aim being to create a cover worksheet called "averages".

Every few days i will manually add a new worksheet in the same format as "332" i had to delete most of the data from "333" to meet the file size limit but you should still get the idea. I would like the "averages" worksheet to work out an average rating and pull the data for all competitors from all worksheets.

I All my data is obtained from 2 columns, USERS & rating which i manually copy paste to a new worksheet every few days from that info i build my basic pivot table. maybe i can gather all the USER & rating columns on the same page and use a more complicated pivot table and thus do away with all the worksheets completely? But I do like being able to easily compare each individual rating against the other competitors for that particular day.

Attached File : competitor ratings1.xls

View 1 Replies View Related

Extending Vlookup: Price List To Cover Up To 10,000 Lines

Feb 9, 2009

However I only put in a small price list when i tried extending it the workbook produced error as per attached. I thought i would just need to amend the row numbers but it doesnt seem to work

unable to upload at present but prevoius is available on this thread. Need to extend price list to cover up to 10,000 lines

View 5 Replies View Related

Calculating Current Cover Based On Forward Requirements

Nov 17, 2007

I have drawn up a simple summary to show what I am trying to achieve: ...

View 9 Replies View Related

Formula: Calculate The Weeks Cover Of Current Inventory

Jun 10, 2008

Calculate the weeks cover of current inventory based on a sales forecast. the forecast is in weekly buckets so I was thinking using some form of loop statement within the function which basically starts with the inventory figure then subtracts the forecast week by week until the inventory figure is less than the weekly forecast. I should then be able to divide the inventory by forecast and add back the number of loops to give me the weeks stock figure.

I have done this using if statements but it will only allow me to use 10 statements in the function and I need to do this for a full years worth of forecast.

Does anyone have a suggestion as This problem is becoming quite frustrating.

Here's an example of how the spreadsheet looks

Forecast103050205040Inventory 20019016011090400Weeks Cover6.

View 9 Replies View Related

Expanding Already Provided Formula For Removing Duplicates To Cover More Columns

Jul 20, 2013

I have a list A2...A11

In cell B1 is the following formula: =SUM(IF(FREQUENCY(IF($A$2:$A$11"",MATCH("~"&$A$2:$A$11&"",$A$2:$A$11&"",0)),Rvec),1))

Rvec is defined in NAME MANAGER as: =ROW(Sheet1!$A$2:$A$11)-ROW(Sheet1!$A$2)+1

In cells B2...B11 is this formula: =IF(ROWS($B$2:B2)

View 6 Replies View Related

Conditional Formating (cell Based On The Value Of Another Cell Whish Is Linked To Another Sheet)

Oct 24, 2007

I am trying to create conditional formating of a cell based on the value of another cell whish is linked to another sheet. I an using the "The formula is =$AA$30=1" where the cell AA30 is the cell linked to the other sheet. the problem is I have to do thiss for approx 200 cells ie =$AA$30=1, =$AB$30=1, =$AA$31=1, =$AB$31=1 --- =$AZ$42=1. Do I have to enter the formulea for each cell or is there a way to automate this?

View 2 Replies View Related

Linked Cell

Jul 17, 2009

I have a cell with a link to a closed worksheet.

The problem I am experiencing is when the linked worksheet is open the data found and the cell automatically populated.

When the linked workbook is closed, I get nothing.

If I check links/source I get the message Error: Undefined or non-rectangular name, neither of which are true statements.

Linked workbook closed

Management - Prepared  HVHWHXHYHZIAIBICIDIE7 £                  -   £                 -   £                 -   £                 -   £              -   £              -   £                  -   £                 -   £                 -   TRUESpreadsheet FormulasCellFormulaHV7{=SUM(IF(ISNUMBER(SEARCH("SALAD ONION",'L:Customers StatsSaladsDatabase salads2.xls'!Description)),IF('L:Customers StatsSaladsDatabase salads2.xls'!Period>=$HQ$7,IF('L:Customers StatsSaladsDatabase salads2.xls'!Period<=$HQ$6,'L:Customers StatsSaladsDatabase salads2.xls'!SaladVal))))/1000}HW7{=SUM(IF(ISNUMBER(SEARCH("SALAD ONION",'L:Customers StatsSaladsDatabase salads2.xls'!Description)),IF('L:Customers StatsSaladsDatabase salads2.xls'!Period>=$HQ$11,IF('L:Customers StatsSaladsDatabase salads2.xls'!Period<=$HQ$10,'L:Customers

Linked workbook open

Management - Prepared  HVHWHXHYHZIAIBICIDIE7 £        3,624.89 £        4,144.82 £          373.62 £          664.80 £       764.06 £       373.62 £           235.14 £          263.18 £          314.38 TRUESpreadsheet FormulasCellFormulaHV7{=SUM(IF(ISNUMBER(SEARCH("SALAD ONION",'Database salads2.xls'!Description)),IF('Database salads2.xls'!Period>=$HQ$7,IF('Database salads2.xls'!Period<=$HQ$6,'Database salads2.xls'!SaladVal))))/1000}HW7{=SUM(IF(ISNUMBER(SEARCH("SALAD ONION",'Database salads2.xls'!Description)),IF('Database salads2.xls'!Period>=$HQ$11,IF('Database salads2.xls'!Period<=$HQ$10,'Database salads2.xls'!SaladVal))))/1000}HX7{=SUM(IF

View 9 Replies View Related

How To Combobox Linked With Arrays

Jan 13, 2014

How can I link the names of severall employees in a combo box (or data validation cell), with specific and individual arrays?!?!

View 3 Replies View Related

Linked Documents Cell Changes

Feb 7, 2014

I have several excel documents all linked to one unique excel document which I will call document A.

Document A is a performance spreadsheet where I have percentages, sales figures and times, for my sales team.

Each sales person has their own unique dashboard (another excel document) that I am currently trying to finalize.

Their personal dashboards have pie charts with text boxes. The text boxes within the charts link up to their relevant cells in document A.

When Document A is open and I open 1 of the sales person's dashboards. Everything looks good and works, however.

When I close document A the dashboard information changes. For example, the dashboard information could be showing 25% but when I close document A it reverts to 0.25

If I close down the dashboard and open document A back up, change it to 30% then close it. The dashboard recognizes the change BUT reads as 0.30. This is the same with them all.

The only fix I have figured out is creating another tab in Document A then duplicate of all the information required for the dashboards then save the cells as TEXT (as opposed to currency, percentage etc).

This kind of defeats the object because I have formulas set up in Document A and don't want to be doing twice the work.

View 4 Replies View Related

Copyrights 2005-15, All rights reserved