+ Reply to Thread
Results 1 to 13 of 13

look into various spreadsheets

  1. 07-07-2012, 06:14 AM #1
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    look into various spreadsheets

    Hi.

    I need to find a value between the minimum and maximum. where it is given in column 'A' and column 'B' of each worksheet 'REGUA110' 'REGUA115' and 'REGUA270'

    the value should be returned from the worksheet 'CARTEIRA' column 'F'
    Column 'G' worksheet is the worksheet to search and column 'E' worksheet 'CARTEIRA' has the value that is to look between the minimum and maximum.

    can anyone help me?

    Thank you!
    Attached Files Attached Files
    Last edited by marreco; 07-09-2012 at 06:27 AM.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
    Reply With QuoteRegister To Reply
  2. 07-07-2012, 06:23 AM #2
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: look into various spreadsheets

    Marreco, I don't follow? What is the criteria to lookup in sheets 'REGUA110' 'REGUA115' and 'REGUA270'?
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files
    Reply With QuoteRegister To Reply
  3. 07-07-2012, 06:27 AM #3
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: look into various spreadsheets

    See if this is what you're up to.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  4. 07-07-2012, 06:27 AM #4
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: look into various spreadsheets

    Hi.

    See an example
    look between the minimum and maximum value that is in cell "E3" on the worksheet that is in cell 'G3'

    Thank you!!
    Reply With QuoteRegister To Reply
  5. 07-07-2012, 12:42 PM #5
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: look into various spreadsheets

    Hi.
    Any idea?
    thank you!
    Reply With QuoteRegister To Reply
  6. 07-07-2012, 01:41 PM #6
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: look into various spreadsheets

    See my reply in #3.

    Please reply if this is what your up to.
    Reply With QuoteRegister To Reply
  7. 07-07-2012, 02:55 PM #7
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: look into various spreadsheets

    Hi.

    I'm sorry but my intention was to VBA!
    Thank you!
    Reply With QuoteRegister To Reply
  8. 07-07-2012, 03:00 PM #8
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: look into various spreadsheets

    And so you don't look at my post?
    Reply With QuoteRegister To Reply
  9. 07-07-2012, 03:13 PM #9
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: look into various spreadsheets

    Hi.
    yes and I still click on the star!
    because you published again?
    Reply With QuoteRegister To Reply
  10. 07-08-2012, 06:50 AM #10
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: look into various spreadsheets

    Hi.
    Any idea?..
    Thank you!!
    Reply With QuoteRegister To Reply
  11. 07-08-2012, 03:58 PM #11
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: look into various spreadsheets

    Hi.
    someone could help me, to-do via VBA?
    Thank you!
    Reply With QuoteRegister To Reply
  12. 07-08-2012, 09:18 PM #12
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: look into various spreadsheets

    Try this Marreco.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  13. 07-09-2012, 06:26 AM #13
    marreco
    marreco is offline
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Re: look into various spreadsheets

    Hi.

    it' work Great!!!

    Thank you!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1