linking workbooks

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Excel hyperlinks: Hi, I have a small database in Excel with hyperlinks to .jpg files. In Excel 97, the link would open the .jpg with the program associated with the .jpg extension. In Excel 2002, the file is displayed with Microsoft Photo Editor. How can I change the association in Excel? Thanks, Richard Tag: linking workbooks Tag: 57229
  - 2
    - SUM of Numbers with colons (:) such as Hours & Minutes Does anyone know how to get the SUM of a column with numbers formated as Time (hh:mm) useing the SUM formula to get the total numbers of hours in that column. For example: Day-1 10:45 Day-2 11:05 Day-3 09:10 Total 31:00 Help is very appreciated. Wally Tag: linking workbooks Tag: 57224
  - 3
    - Array formula Hello, Why doesn't the following work as an array formula? =SUM(IF(ISERROR(VLOOKUP("Clark",INDIRECT(B1:B10),5,FALSE)),0,VLOOKUP ("Clark",INDIRECT(B1:B10),5,FALSE))) where B1:B10 is a list of named ranges. Furthermore, when I try and 'Evaluate Formula', Excel crashes. Thanks, Andrew Tag: linking workbooks Tag: 57223
  - 4
    - Sort data by formatting Is there any way to sort rows of data depending on their background color? Like I have around 1000 mixed up rows of 5 colors (e.g. yellow, red, green, violet, blue), and they are arranged in no specific order i.e first 2 yellow rows, then 1 red, 4 blue, then again 3 yellow, and 3 blue ...so on. I just want to arrange them in block of Colors like All Blue Rows, All Yellow Rows etc. Could it arrange using VBA or Excel? Tag: linking workbooks Tag: 57221
  - 5
    - Link VBA - DLL (in C): how to send an array as an argument? Hi everyone, I am working on an VBA application that needs to send an array as an argument to an external libray written in C. The library uses the array as a vector of parameters, and then returns a certain value. The link is working well with a single argument (a double, an integer, etc), by reference or by value. But when I want to send an array (a vector of double for instance), it fails. Does anyone know how to do this? First, is it possible? Many thanks, Sylvain Tag: linking workbooks Tag: 57220
  - 6
    - Hide Cells from printing I have the need for a user to be able to enter a start date, but I don't want the start date to print when the spread sheet is printed. How can I do this? -- Thanks Wayne Sepega Jacksonville, Fl "When a man sits with a pretty girl for an hour, it seems like a minute. But let him sit on a hot stove for a minute and it's longer than any hour. That's relativity." - Albert Einstein Tag: linking workbooks Tag: 57215
  - 7
    - Excel 97 - HTML Tables I am trying to open a 4000 row html table in Excel 97. I've read somewhere that Excel 97 has problems opening larhe html tables. Could anyone point me to a knowledge base document that details this. TIA MattC Tag: linking workbooks Tag: 57210
  - 8
    - Linking graphics between worksheets? How can I do this and is it even possible? I just tried but no luck. I've made a great workbook which prints out daily planner type pages over 31 tabs for 31 days. What's neat is that all I have to do is type in the date in one cell in the first worksheet and the remaining 30 worksheets then adjust to the rest of the month automatically due to a formula which I created through linking from one worksheet to another and then adding 1. Pretty simple stuff for most folks but this is the first time I've used the link feature so I was pretty pleased with the result. I now need to create the second type of sheet that shows a little calendar box on each page. I have a calendar-making program so that's neat but I'd like to use the same principle - create the little calendar box (approx. 1x1.25" in size) and then paste it into the first worksheet only and have it replicated in the 30 remaining worksheets. It didn't work this morning but thought I'd ask before giving up and having to paste the box into 28 to 31 worksheets in future <sigh>! <g> Thanks. Tag: linking workbooks Tag: 57209
  - 9
    - Book Recommendation? Hi, I am an Access developer with some experience writing macros in Excel. I wonder if someone would be able to recommend a good developer level book for excel programming. I have the Access Developers Handbook set and VBA Developers Handbook by Ken Getz & Mike Gilbert. Looking for something that details the Excel object model and how to make best use of the power of Excel formula's and functions (especially from a financial point of view). Any guidance would be much appreciated. Barry-Jon Tag: linking workbooks Tag: 57207
  - 10
    - ExcelReport 2.0 Released! Dear all, ExcelReport 2.0 Released! Please check http://www.ljzsoft.com ExcelReport is an Excel report generator that outputs reports in Microsoft Excel spreadsheet format. If you know how to use Microsoft Excel and write SQL statements, you can use ExcelReport to create all kinds of Excel reports as you need. Main Changes in ExcelReport 2.0 * Design an ExcelReport file with the extension ".xrf". * Add a editor of ".xrf" file. You can create, open a XRF file using ExcelReport. * Change the user interface * Change the syntax of functions. * Can put data of each record into multi-rows. * Support "group" in a report. * Support pagebreak in a report. * Support multi-databases in one report. Tag: linking workbooks Tag: 57192
  - 11
    - HELP!!!!! Hi there... Is there any way to make the following formula shorter??? This is ridiculous, and I need the formula to evaluate such as it does... Sorry for the crosspost, but I am desperate!!!! =IF(F7>=27000,(19200/$G$4),IF(F7>=26500,(F7-100)*($G$4)/($G$4),IF(F7>=25000,(F7-200)*($G$4)/($G$4),IF(F6=6500,(24100)-(P3+P4)/($G$4)*($G$4),IF(F6=6000,(24100)-(P3+P4)/($G$4)*($G$4),IF(F6=5500,(24100)-(P3+P4)/($G$4)*($G$4),IF(F6=5000,(24100)-(P3+P4)/($G$4)*($G$4),IF(F7>=17000,(12000/$G$4),(F7-200)*($G$4)/($G$4))))))))) Thank you Doug Tag: linking workbooks Tag: 57191
  - 12
    - Macro cases for accounting/banking/financing Hi, I started learning Macro several weeks ago. But I am very confused while reading the book that I have. I am just wondering how I would be able to use these features. Would you please show me some of the cases that you would use Macro in accounting/banking/financing field. Thanks Tag: linking workbooks Tag: 57186
  - 13
    - Excel Pivot Tables Hi, Is it possible to stop a pivot table grouping the row headings so that some of the items in the row appear to have blank cells adjacent to them? This is annoying if you want to run another pivot table on the results of your first table. It means you have to copy and paste the row headings into all the blank cells which can be frustrating if you have many lines of data. What I would like is for the pivot table to show the row headings for all the values regardless if it's the same as the cell above. Or, is there another way round this (such as running a pivot table straight over the top of the other for instance?) Thanks in advance for any advice, Greg Tag: linking workbooks Tag: 57183
  - 14
    - Keeping multiple sheets consistent in a workbook I dont know if this is possible. Basically, I keep track of test cases using Excel. I have multiple sheets that have the same exact test case names (for alpha, beta, etc). The problem is that if I add a new test case to one sheet, I have to add it to all sheets. This is painful. What I would like is for the other sheets to update automagically. Is this possible? In other words, I am adding test case Z to sheet 1. Can test case Z now show up on sheets 2, 3, 4, and 5? Thanks. -dmp Tag: linking workbooks Tag: 57177
  - 15
    - How to open Lotus 123 files Everything that I read says that Excel 2003 doesnt need a converter ... but I cant open a .123 file... Any ideas would be greatly appreciated... jason Tag: linking workbooks Tag: 57168
  - 16
    - Command Button Hi All, I have made a command button on Sheet 1 and assigned a macro , Now I want to delete that button but however I am unable to do. Regards Dushyant Tag: linking workbooks Tag: 57158
  - 17
    - A - b <> C ????? Problems with subtraction of cells... I have a problem with some calculations in a spreadsheet. I have some numbers that have functions tied to them to figure out the value I want to show... Example.... Cell B30 SUM(ROUND(B28,3)*B29 I now have other cells H20 = B30 H19 = H15 H23 = h20 - h19. All cells are showing a currency format. But when you do the subtraction the H23 shows something different (Looks like a rounding issue).... It is simple I want to calculate what is shown in the cell. What do I need to do to do this? Thanks, Rog Tag: linking workbooks Tag: 57152
  - 18
    - Sheet lookup Hello, I have values that I would like to look up on different sheets rather than the same one, so I can't use vlooup(). So far I have been defining named ranges, but my formula is getting too long. Here is what I do: SUM(IF(ISERROR(VLOOKUP($A3,mar_03_batting,COLUMN(C$1)-1,FALSE)),0,VLOOKUP ($A3,mar_03_batting,COLUMN(C$1)-1,FALSE)),... Basically, see if the name can be found on the sheet, and if it can, add the vlookup'ed value in. On another note, why is vlookup() designed to return an error rather than a number?? That's my number 1 hated "feature" of excel. Thanks, Andrew Tag: linking workbooks Tag: 57150
  - 19
    - Formatting pasted cells Hi, I have pasted data from a webpage into a worksheet. In order to calculate with it, I need to reformat. I reformat it to "Number" and try to make a formula, but it does not calculate it. I get a zero as result (not an error message). I also tried other formats such as general. Any idea what is wrong? Thorbjorn Tag: linking workbooks Tag: 57148
  - 20
    - Comparing values and showing % I have a pivot table 2004 values ... .. 2005 values ascending which I refresh monthly I vish to have at the bottom table showing % 2005/2004, but it is quite difficult as pivot fields in 2005 keep on changing every month, can I create a pivot table to show % between two years ? Tag: linking workbooks Tag: 57141
  - 21
    - Converting Text Field to Time Is this possible? Me Tag: linking workbooks Tag: 57135
  - 22
    - Copy data from one worksheet to another Dear All, I've a worksheet contains records belong to "complete" and "incomplete" status. And I need to seperate these records manually into two seperated worksheets "complete" and "incomplete". I just wonder is there any formula to show only records which are "complete" status in a worksheet and "incomplete" in another worksheet ? It's quite clumsy to do the sorting and cut & paste to another worksheet everytime. Any idea? Thanks Best Rdgs Ellis Tag: linking workbooks Tag: 57134
  - 23
    - Keep custom format in new worksheet Hi all, I created a new custom format in "Format Cells", after using this custom format I save the file and quit, when I open the old file the custom format still in this file, but when I try to create a new file the custom format is lost. Is it possible to keep the custom format forever in the Excel so that I don't need to create it again when open new workbook? Many Thanks. Buddy Tag: linking workbooks Tag: 57133
  - 24
    - annoying voice Hi, im new to excel... How do you get rid of the annoying voice whenever you enter something into a cell. The voice reads back what i write in that cell, it drives me crazy. thanks Tag: linking workbooks Tag: 57131
  - 25
    - Customguide.com's Exercise files Anyone has got ALL of CustomGuide.com's exercise files for download? -- Tag: linking workbooks Tag: 57129
- Next
  - 1
    - sum returning 0 result totalling up a bunch of non-contiguous, but columnar cells. cells contain totals of the cells above them. the final total is returning a zero result. What am I missing here - against my deadline?! -- Claudia __________________________________ "Age is...wisdom, if one has lived one's life properly." --Miriam Makeba, singer Tag: linking workbooks Tag: 57127
  - 2
    - Excel>Data>Import External Data>New Web query Hi I am trying to use Excel 2003 to import data from http://bigcharts.marketwatch.com/quotes/default.asp?refresh=on&rand=8519 I use new web query on the above url. I select the data in the block under 'My Favourite Quotes' The wizard behaves as expected but only returns 1 line not the 3 that have been selected. Can someone please give me some pointers on how I can get the 3 lines. Thanks Bruce Tag: linking workbooks Tag: 57117
  - 3
    - Excel>Data>Import External Data>New Web query Hi I am trying to use Excel 2003 to import data from http://bigcharts.marketwatch.com/quotes/default.asp?refresh=on&rand=8519 I use new web query on the above url. I select the data in the block under 'My Favourite Quotes' The wizard behaves as expected but only returns 1 line not the 3 that have been selected. Can someone please give me some pointers on how I can get the 3 lines. Thanks Bruce Tag: linking workbooks Tag: 57116
  - 4
    - VLookup to Hide Columns Hi everyone - I'm still trying to figure out how to perform this one. Within my Timesheet tool, I use a VLookup table, on a data entry page, that contains employee names, departments, etc...... Also on the data entry page, are a number of columns (designated with specific housing programs) where the employee enters their daily hours depending on which program they work in. The thing is that certain employees only work in certain programs where it would be easier if the program columns that the employee does not deal with will "hide" once the employee chooses their names from the VLookup drop-down box. THIS IS WHAT I CAN'T FIGURE OUT HOW TO DO. I've tried a number of different VB codes and nothing seems to work. I was hoping someone could take a look at what I've developed and shoot me in the right direction. ANY help would really be appreciated. Thanks again for the help. Frank Tag: linking workbooks Tag: 57110
  - 5
    - can't open excel From this morning, I can't open any .xml (and excel.exe too) files !! Every time I try to do this, a fatal error (blue screen) 016F:BFF744FE appears to me! I try to re-boot my os, but it don't works. Why? Any solutions? Please help me... Pentium II, 256MB RAM, Win98, Office 2000, 12GB free on hard disk. Thanks. ps: answers only here, not e-mail. Tag: linking workbooks Tag: 57108
  - 6
    - VB code to insert/get data Hi where can I find information and examples about inserting data to databse and getting from DB to excell ? As far I know I need to use VBA code ? regards Peter Tag: linking workbooks Tag: 57102
  - 7
    - Copying a range to different worksheets/workbooks I have a spreadsheet which contains a list as follows Sorted by Col A then G. A G H I J Abbot 27-Oct-2003 London 24 13 Abbot 20-Feb-2002 Norwich 22 08 Abbot 29-Apr-2001 Hull 20 02 Abbot 04-Jun-2000 Grantham 19 12 Brown 20-May-2004 Newark 35 14 Brown 06-Jul-2002 Sheffield 35 06 Brown 23-Mar-2002 London 33 12 Brown 18-Sep-1960 Woodford 33 10 Davis 16-Jun-2004 Chigwell 29 02 Davis 23-Dec-2003 Loughton 26 11 Davis 05-May-2002 Glasgow 25 04 Davis 14-Aug-2001 Cardiff 23 01 Davis 28-Jul-2001 Debden 23 00 Davis 02-Feb-2000 Woodford 19 01 The list changes regularly and I need to copy data from this list to spreadsheets in different workbooks based on certain criteria. For example. Where Col A = Brown. And Col G is less than 01-Jan-2004. I wish to copy to Cols B,C,D,E and F in row 3,4 & 5 respectively in another workbook the first 3 rows in this list where these criteria are matched. Where there is less that 3 rows that match the criteria copy only the available matches. For each workbook I copy to the criteria for Col A and Col G will be different so I need a formula that I can adapt to place in each worksheet to extract the information. Any help you can give would be greatfully appreciated -- John Delete extra @ to reply Tag: linking workbooks Tag: 57087
  - 8
    - Loan Ammortization Forumlas? I'm trying to build a worksheet that will allow me to analyze properties when considering one for a purchase (RE Investing). Given the number of years, original principle amount and APR: * I need one formula that will give me the monthly payment (P & I). * I need one formula that will give me the interest portion of the first payment. However when I enter the info using the financial functions provided in Excel (Pmt, IPmt and I think a couple others), they all return either $150 too low or a few $1000 too high. Can someone help me with this? Assume the Original Principal is in B6, the APR is in D6 (as a whole number--i.e. 7.00% is displayed as 7.00), the number of years is in G6. Thx. -- Don I Tag: linking workbooks Tag: 57083
  - 9
    - 3-D Address References and Names It seems that 3-D cell addresses transfer to other workbooks (not worksheets) only as constants, such as "(specific cell value)". The record macro that results from that will have a paste information as "(specific cell value)", and not a variable. Does one have to go to Excel Visual Basic to express a variable, so the macro is reusable for other workbooks with different cell values? Thanks, Tom Tag: linking workbooks Tag: 57080
  - 10
    - how do we achive the default view settings? Hi, I know this is simple but... Somehow I managed to change the default view settings of my worksheets. Now when I right click on sheets tabs I see that View Code option is inactive. How can I make it active by default as before? Thanks J_J Tag: linking workbooks Tag: 57067
  - 11
    - Problems with Google INTENTIONALLY CROSSPOSTED! Just found out that VBA code in the beta Google Groups archive can be fubar. The article http://makeashorterlink.com/?R1EA128AA, which is a link to http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/msg/e249f6c074a3adfd includes the statement Set xlapp = CreateObject("Excel.Application") which includes an embedded HTML hyphen (decimal char code 173) between the o and n. Copy this line and paste into an Excel cell to see it. The article in original format (http://makeashorterlink.com/?E1FA328AA, which is a link to http://groups-beta.google.com/group/microsoft.public.excel.worksheet.functions/msg/e249f6c074a3adfd?dmode=source doesn't include this unwanted character. So, if you're going to paste code (or maybe formulas as well) from the beta Google Groups archive, you'd better do so from original format articles rather than from HTML formatted versions. Tag: linking workbooks Tag: 57065
  - 12
    - weekly time calculation I am want to calculate how many hrs have been worked over a fornight basics i.e. A1 14:50 A2 13:30 A3 10:45 A4 12:50 A5 10:25 A6 15:00 A7 13:50 A8 12:10 A9 9:50 A10 10:55 A11 8:40 A12 13:00 A13 12:00 A14 10:40 I am a HGV driver and need to keep an account on my hours Also I need to know how to get a average of my weekly hours work over a 17 wks period A1 69 hrs A2 74 hrs and so on up to 17 weeks Their is a new law coming out, for HGV drivers which means we cant work more than 48 hours a week. This can be averaged out over a 17 wk period. does anybody know if there is a calculation I can use to work out the average over the 17 wks I am thinking of working my normal hrs then taking a week or what ever I need to take Tag: linking workbooks Tag: 57058
  - 13
    - How to Merge Date from 3 columns to 1 I have a spreadsheet where the date is spread over 3 columns I,J & K and I wish to merge them to Column B in the format dd-mmm-yyyy as shown below. B I J K 02-Feb-2003 02 Feb 2003 27-Mar-1999 27 Mar 1999 01-Apr-1978 Apr 1978 01-Jan-1998 1998 14-Jun-2002 14 Jun 2002 Where there is a blank for the day in 'Column I' I need it to copy as 01 and where there is a blank for the month in 'Column J' I need it to copy as Jan. Where all 3 columns 'I' 'J' and 'K' are blank I need it to leave 'Column B' blank. Is there a way to do this with a formula I can enter in 'Column B' and copy down the column. I have been puzzling over this all day. Thank you. -- John Delete extra @ to reply Tag: linking workbooks Tag: 57054
  - 14
    - Array lookup Hi all I have an array of data, i want to find the 1st to 5th largest numbers in each line but if there are 2 values of the same size i want the first that occurs to be returned as highest and the second instance to be returned as 2nd highest. so far when i try this it returns the same value for both 1st and 2nd highest using hlookup my table looks like so; ______________________________________________________________ A B C D E F G H I J K L 1. 1 2 3 4 5 0-0 1-0 0-1 2-0 1-1 0-2 3-0 2. 0.5 0.4 0.5 0.3 0.4 0.1 0.2 3. 0.5 0.3 0.2 0.4 0.6 0.1 0.0 4. 0-0 1-0 0-1 2-0 1-1 0-2 3-0 ______________________________________________________________ I want; A2 to return 0-0 (in reference to F2), B2 to return 0-1 (in reference to H2), C2 to return 1-0 (in reference to G2), D2 to return 1-1 (in reference to J2), E2 to return 2-0 (in reference to I2) So far i have tried using HLOOKUP to say; =HLOOKUP(LARGE(F2:L2,1),F2:L4,3,FALSE in A2 =HLOOKUP(LARGE(F2:L2,2),F2:L4,3,FALSE in B2 =HLOOKUP(LARGE(F2:L2,3),F2:L4,3,FALSE in C2 =HLOOKUP(LARGE(F2:L2,4),F2:L4,3,FALSE in D2 =HLOOKUP(LARGE(F2:L2,5),F2:L4,3,FALSE in E2 But this returns; 0-0 0-0 1-0 1-0 2-0 When what i actually want is; 0-0 0-1 1-0 1-1 2-0 Please help, if this makes sense Ouija Tag: linking workbooks Tag: 57053
  - 15
    - Vlookup Problem Hi all, 15: 30 16: 23 15: 35 17: 20 In the VlookUp function, if the table_array index is not unique, as the example above, how can I get the value of "35" ? Thanks in advance. Best Rgds, Rick Lillian Tag: linking workbooks Tag: 57050
  - 16
    - Dynamic link to Visio object? I am posting this here because Excel users seem to do more linking. I'm having trouble getting this answered in the Word NGs. I am looking for a way to embed individual Visio graphic objects in a Word document in such a way that only a link is actually stored in Word -- not the entire graphic object. I am writing a large tutorial that includes hundreds of graphics -- as many as 7-8/page. Some pages are 90% graphic images with just a few lines of text. I am creating the graphics in Visio. I started out just using cut and paste to paste the actual graphic objects into the Word document. This causes the Word document to get very large (8MB and growing). It takes forever to load and save. It also is a pain to fix all of thse images if they need to be changed. I started looking around for another way. I wanted a way to just ink the images, rather than storing the actual image. This should be much smaller and I could update the images in Visio and have them automatically updated in Word. I rememebered Paste Special from some Excel work I did awhile ago. So I tried it. I opened Visio, selected an object, and pressed Ctrl+C to copy it to the clipboard. I then opened the Word document and clicked on Edit | Paste Special | Paste Link. It apeared to work. The image appeared in the Word document. If I changed it in Visio, it was automatically changed in Word. Perfect. Or so I thought. When I went to save the document, it took longer than I thought it should, so I checked the size. It was almost .5MB and it only had a few images. It appears that Word is storing both the link and the actual image. What's up with this? So, my question remains: how can I embed just a link to a single Visio object in a Word document without including the actual object. Thanks, and sorry for bothering you all with a Word problem. I was just hoping that someone might have solved this for Excel and the same approach would work for Word. -- Running MS Office 2K Pro PC: HP Omnibook 6000 OS: Win 2K SP-4 (5.00.2195) Email: Usenet-20031220 at spamex.com (11/03/04) Tag: linking workbooks Tag: 57049
  - 17
    - comparing data I was wondering is there a way to compare data from 2 columns in a side by side comparison. I have a large list of numbers and what I want to do is copy another list of numbers into the spreadsheet. But I want the numbers in cell A1 and B1 to be equal if they are is not a match then leave cell b1 empty. I want that to continue all the way through the entire worksheet. Tag: linking workbooks Tag: 57047
  - 18
    - margin calc Can anybody tell me the best formula to use to calculate the profit margin between two number when this maybe plus or minus Tag: linking workbooks Tag: 57041
  - 19
    - Changing Toolbar Icon Size Is it possible to change the size of the Icons in the toolbars from VBA Subroutine? Thank you. Tag: linking workbooks Tag: 57036
  - 20
    - Date Formula I need help with a formula that goes form cell to cell returning the next month's date... For example, in cell A10, I have current date "3/12/05" ... in cell A11, I'd like to input a formula that will return "4/12/05" and so forth... What formula can I use? ... TIA!!! LavaDude Tag: linking workbooks Tag: 57029
  - 21
    - Spreadsheet only links to others when they are open Hi All, I lost my earleir thread on this q (damn outlook express) before getting a reply, so apologies for re - posting. I have a spreadsheet (calcs) linked to two others that feed it data. If the two 'data feeders' are not open, calcs displays #value errors for all linked cells. This is after I have selected 'automatically update during opening of calcs. Can anyone help identify why this is and how I might change it ? Thanks, Neil Tag: linking workbooks Tag: 57027
  - 22
    - Macro Help Dear Experts I hope someone could help me with a macro. I have to reconcile the fuel stock I have in the depot on a daily basis. This includes fuel amount at start of day and end of day, fuel issues to vehicles, receipts into the tanks, density and temperature of the fuel etc. I use an Excel 2000 worksheet for this work. I would like a macro button that would copy a summary of the relevant data to a second worksheet on a daily basis as I just overwrite the data on my reconcile worksheet (Dip) from the previous day. For the first of the month it should copy the date in cell A1 and the data in Cells D2:D9 in the "Dip" worksheet to the "Summary" worksheet starting in cell A2. This would occupy Cell A1 to Cell A9. For the second day of the month it would copy the same cells again and paste the data in the Summary worksheet under the previous entry, this should be in cell A11, as I would like an empty cell between each days issue. This would give me a monthly Summary of each day's reconciliation. Any help would be greatly appreciated. Regards Hans Tag: linking workbooks Tag: 57025
  - 23
    - Creating a chart to convert hundredths to minutes My company is using a manual hundredths to minutes chart to change decimals to minutes. Example if the hours worked shows as 1.83, the .83 is converted to :50 minutes. I am using a formula to calculate hours worked for the AM and PM routes with a sign on and sign off time for each. The formula looks like this =(D11-C11)*24 Sign on time is 5:20-C11, sign off time is 9:25 D11, hours =4.08 The .08 in hundredths =05 minutes. At one point I use this formula to display 4.08 in h:mm format, =TEXT(D11-C11,"h:mm") This returns 4:05. Is there a way to create a lookup table that contains the hundredths to minutes data then the cell with the value in hundredths look up and return the corresponding value? Tag: linking workbooks Tag: 57021
  - 24
    - automatically pasting cell into different sheets? Hi! I am trying to get Excel to copy content of some cells to next sheets, depending on the number I put in last cell. IE A1:A3 have some text. Now, if I put number (2,3,4 or 5) in A4, I wanted to copy A1:A4 to Sheets 2,3,4 or5, depending which number I put in A4 (if 2, then to Sheet s, if 3 to Sheets 2 and 3 and so on). Is this doable in Excel or should I use Visual Basic or some other program? Thank You for help Tag: linking workbooks Tag: 57020
  - 25
    - last number in a column Can I have excel take the last number in a column of 31 rows, only if it's not a zero. And return that number to a given cell? Thank You Tag: linking workbooks Tag: 57019

Hi,
how can i link a cellA in workbookA to a cellB in workbookB? Whereby when
cellA is updated, cellB will get the same value as well.
thanks

Re: linking workbooks by Jordon

Jordon
Tue Mar 15 09:48:59 CST 2005

"Lynn" wrote
> how can i link a cellA in workbookA to a cellB in workbookB? Whereby when
> cellA is updated, cellB will get the same value as well.

Copy, Paste Special, Link

Re: linking workbooks by RagDyeR

RagDyeR
Tue Mar 15 09:48:22 CST 2005

Open both WBs.

Select cellB in WB B.
Enter equal sign ( = )
Navigate to WB A, and click in cell A, and hit <Enter>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Lynn" <MarryLynn@yah00.c0m> wrote in message
news:eR0ciIXKFHA.2748@TK2MSFTNGP09.phx.gbl...
Hi,
how can i link a cellA in workbookA to a cellB in workbookB? Whereby when
cellA is updated, cellB will get the same value as well.
thanks

Re: linking workbooks by Lynn

Lynn
Tue Mar 15 20:59:50 CST 2005

thanks

Re: linking workbooks by RagDyeR

RagDyeR
Wed Mar 16 09:23:26 CST 2005

You're welcome!
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"Lynn" <moley_cruz@yahoo.com.au> wrote in message
news:1110941990.172842.231150@l41g2000cwc.googlegroups.com...
thanks