Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MSealy

    Excel - Two dropdown lists, two columns, two cells

    Thanks. Through that I've managed to make both parts of this work - but only separately. I can get the results of the Department dropdown (Sheet1) from A1 in A2 using: =INDEX(Sheet2!B1:B3,MATCH(A1,Sheet2!A1:A3,0)) I can get the results of the Code dropdown (Sheet1) from B1 in B2 using...
  2. MSealy

    Excel - Two dropdown lists, two columns, two cells

    Ok, this is as far as I've got: In Sheet2, I've named the range A1:B3 as 'Costc' In Sheet1, in cell A1 I've created a Data Validation as List, with the source "=Sheet2!A1:A3" i.e. the first column of 'Costc' in Sheet2. Still in Sheet1, in cell B1 I have the formula "=IF(A1="", "", VLOOKUP(A1...
  3. MSealy

    Excel - Two dropdown lists, two columns, two cells

    I've given that a go too, but after hitting my head against a brick wall for a few days on this, I think I'll just merge the two columns and make do with a Data Validation lookup on the single column. Thanks anyway.
  4. MSealy

    Excel - Two dropdown lists, two columns, two cells

    Hi, I've been searching the net for an example of my problem, but alas I can't find it. Basically I need to select a department name and related code number on a dropdown on a main page (Sheet1). To do this I need to be able to either select the name, or the code, on the two lists located in...
  5. MSealy

    MS Excel 2007 - Search between list of two ranges on rows

    ...I did this method. On Sheet2 I put both formulas in separate cells. I modified each as follows: In box A1: =IF(ISNA(MATCH(Sheet1!D1,Sheet1!B:B,1)*1),0,(INDEX(Sheet1!A:B,MATCH(Sheet1!D1,Sheet1!B:B,1),1))) This gave me the result of the first column (1-50) on the search in D1. In box A2...
  6. MSealy

    MS Excel 2007 - Search between list of two ranges on rows

    Thanks, after changing the first bit, it worked perfectly! =INDEX(A:B,Match(D1,B:B,1),1) Now if I wanted to have another column, using the same rows, i.e: E F G 1 11 514 590 2 12 591 634 3 13 635 720 4 14 721 800 Then I should be able to do...
  7. MSealy

    MS Excel 2007 - Search between list of two ranges on rows

    Hi, I'm trying to search between two sets of data across multiple lines. (That's not very decriptive, so I'll give an example) A B C 1 1 1 259 2 2 260 322 3 3 323 460 4 4 461 513 In D1 I have a search box. The idea being, if I put say 280 in D1, I'll get...
  8. MSealy

    Excel 2007 checkbox on row to print to label sheet

    I've cracked it - I was confused until I realised the references were pointing to the original set. It works now - great. Rather than place the formulas into the labels, I've put them on a separate sheet and linked the labels to them - in case I need to change one for whatever reason - in which...
  9. MSealy

    Excel 2007 checkbox on row to print to label sheet

    I think I'm going to have to, as the 400 textboxes will be a nightmare especailly as I just can't understand how to relate the file fields to the fields in my labels. Whereever I put the formula I get one result which is either "NA" or "0" I think I'm going to have to push for the case of...
  10. MSealy

    Excel 2007 checkbox on row to print to label sheet

    Ok. I've amended your code to reflect the data on my sheet. There is a frozen pane area above where this starts which contains data that is static on the Labels sheet. This is why it starts at A16. I did that to avoid repetition of data. A D G JKLM N Q T...
  11. MSealy

    Excel 2007 checkbox on row to print to label sheet

    Thanks for that, I've put the (modified to my positions) formula into cells, and told the labels to refer to those cells but I get "#NA". Is there a specific place I need to place them? Thanks.
  12. MSealy

    Excel 2007 checkbox on row to print to label sheet

    That is spot on. The ticks determine the position of the labels - this way I can reduce wastage. I'll never need more than 4 labels at a time (L7171 sheets only have 4) The data will never need sorting as there'll never be more than 100 files per year. Each year I'll simply copy the sheet and...
  13. MSealy

    Excel 2007 checkbox on row to print to label sheet

    The descriptions of the first 2 are spot on - only the labels aren't numbered as such - the number is determined by what's selected on the 2nd sheet. The 3rd sheet has just 4 rows, where the labels take their data from. The idea being that whatever 4 boxes are ticked on the 2nd sheet will copy...
  14. MSealy

    Excel 2007 checkbox on row to print to label sheet

    Thanks for that. I'd perhaps explain better what I'm trying to do as it's a bit fiddly. Unfortunately I can't copy a row because I'm using two separate colums of data on the page one is 1-50, the other is 51-100. These represent box files. A couple of row examples from 'Data' File TransFrom...
  15. MSealy

    Excel 2007 checkbox on row to print to label sheet

    Hi, I have a database sheet 'Data', where I wish to add 4 buttons/checkboxes to each row of data. The idea being that I can check only 1 of the 4 per row, up to any 4 rows and this data is then passed to my other sheet, 'Labels'. The label sheet contains four spine labels based on L7171 Avery...
  16. MSealy

    Calculated fields in a Query based on fields in Table

    Now if I was to put the names in a separate table, called Employees, then link it to a field called NameID in the Loans table, presumably I would need an INNER JOIN for this query, yes ?
  17. MSealy

    Calculated fields in a Query based on fields in Table

    Thank You - once I'd put all the fields in (instead of the .*) it worked !
  18. MSealy

    Calculated fields in a Query based on fields in Table

    ...and Other Payment fields are caluclated based on the No. of repayments. The formula of which is... First Repayment: =AmtofLoan-((NoOfRepayments-1)*OtherPaym OtherPaym: =ROUNDDOWN(AmtofLoan/NoOfRepayments,2) This works fine for a spreadsheet, but recreating it in Access produces problems...
  19. MSealy

    Label report & form using variable font to fit

    Thanks. Unfortunately, I've been unable to find a working example that I can apply to my database. Regards,
  20. MSealy

    Label report & form using variable font to fit

    Hi, I was wondering if anyone can help please. I'm using a report based on Avery 7171 labels. I have 12 text boxes on the report, each set at Arial 30 Bold, which basically allows for 8 characters width. My form is also set this way for consistency and is based on a table with the 12 fields...

Part and Inventory Search

Back
Top