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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bobbythefish

  1. bobbythefish

    dynamic range selection

    ***New wrinkle accounts past column DX are not being read. When I tried to modify code in BF-auto-options (to remind you cell b7= : =INDEX('[ALL-OPTS.XLS]SHEET4'!$A$5:$DX$30,CELL("ROW",b7)-6,$G$1) -DON'T WORRY ABOUT CASE BECAUSE I JUST CUT AND PASTED YOUR CODE-- Anyway I tried...
  2. bobbythefish

    dynamic range selection

    that sounds interesting--it also leads me to think that you know a why to dynamically (variably) lookup a workbook. For example, if i had each account in a self-contained workbook, rather than all account in one big table, could it call up the appropriate client file on the fly (enter account...
  3. bobbythefish

    dynamic range selection

    Eureka! How can I thank you---I still had row 1 designated from your old code where row 4 should have been (from before I defined the starting row for you. Seriously, If you are in the NY City area, I'd like to buy you a beer or something--at the very least! Thanks again a huge time-save for...
  4. bobbythefish

    dynamic range selection

    Thanks--I feel bad that you are putting so much time into this. I'm not sure what you just told me can ehlp me with current issue though.. my Strikes sheet looks like this (partial view for example): column (A or C or E...) column (B or D or F...) 278-12345 Strike ibm...
  5. bobbythefish

    dynamic range selection

    Zathras, I'm sorry but may I prevail upon you one more time? Almost there! Tried running macro and returns error - not able to find account number in sheet---I look through your code to try to understand what you did-- First thing is, I don't need to capture the ticker symbol because they...
  6. bobbythefish

    dynamic range selection

    okay I guess I'm not clear on the syntax then (no typo) I thought you were defining constants and assigning new names. So now I need to give you the fuller picture so you can help me sort out what substitutions to make. The names I gve you were not exact, I shortened or changed them just to...
  7. bobbythefish

    dynamic range selection

    okay I guess I'm not clear on the syntax then (no typo) I thought you were defining constants and assigning new names. So now I need to give you the fuller picture so you can help me sort out what substitutions to make. The names I gve you were not exact, I shortened or changed them just to...
  8. bobbythefish

    dynamic range selection

    ok---new snag-- when coding (think I'll cut and paste instead) your Constant declaration : Const SHEET_BFOPTIONS ="Sheet1" creates a small problem The Book is, as you know-BF-Options, the actual name of the Sheet that performs the look up etc. is names "OPT-Sheet" VB doesn't...
  9. bobbythefish

    dynamic range selection

    Thanks for the info---I did think you worked for Tek-tips. I think it's great what you are doing and I hope to return the favor to you or someone else one day soon. Well, we are getting closer---now the value is cell G1 is returning "4" which is correct and the stocks in b7 thru b32...
  10. bobbythefish

    dynamic range selection

    Actually your assumption was correct, sorry for not mentioing that---in all cases, we are only dealing with text---(except of course price value which are not part of this issue). Reading through your code again, I also can't reconcile the instruction for cell F1: 'Column:' Does this have any...
  11. bobbythefish

    dynamic range selection

    okay---tried suggestion--doesnt seem to work--first problem seems that in Cell G1 match criteria returns n/a--I rechecked all variables etc, so everything was entered correctly according to your spec. Also in the index statement I'm not sure why CELL("row",B7) what does the B7...
  12. bobbythefish

    dynamic range selection

    Sounds great, thanks---actually you do grasp what I'm doing, however I simplified it for example-sake. in Workbook 'BF-options' user enter account number in cell E1. (actually the account # suffix is typed in and gets concatonated with prefix ultimately stored in cell Y42). HLOOKUP from sheet...
  13. bobbythefish

    dynamic range selection

    okay --thanks again--I'll try to be more specific. Consider 2 workbooks, A and B Workbook B has 2 sheets full of Table data with each column heading an Account number. Workbook A Request the user to input 1 account number. When the user responds, an Hlookup is done and 26 consecutive rows of...
  14. bobbythefish

    dynamic range selection

    Thanks to Zathras for a prompt reply. The full scenario is as follows. A variable (account number) is enter via user input in sheet one of workbook A. This variable retrieves a range of data via lookup from Sheet 1 of workbook B, and fills in data in sheet 1 workbook A (for example, Column A...
  15. bobbythefish

    dynamic range selection

    I am trying to copy/paste special (to overwrite embedded conditional) a range of cell in one worksheet, based upon a variable in a sheet from another book. Any suggestions? thanks bobby
See more

Part and Inventory Search

Back
Top