Results 1 to 15 of 15

if exists find last values in variable rows

Threaded View

ABBOV if exists find last values in... 09-02-2010, 07:57 AM
StephenR Re: if exists find last... 09-02-2010, 08:09 AM
ABBOV Re: if exists find last... 09-02-2010, 12:47 PM
MarvinP Re: if exists find last... 09-02-2010, 09:02 AM
ABBOV Re: if exists find last... 09-02-2010, 12:48 PM
MarvinP Re: if exists find last... 09-02-2010, 03:38 PM
ABBOV Re: if exists find last... 09-02-2010, 04:56 PM
ABBOV Re: if exists find last... 09-03-2010, 04:26 AM
StephenR Re: if exists find last... 09-03-2010, 06:25 AM
snb Re: if exists find last... 09-03-2010, 08:11 AM
ABBOV Re: if exists find last... 09-03-2010, 09:55 AM
ABBOV Re: if exists find last... 09-03-2010, 09:33 AM
StephenR Re: if exists find last... 09-03-2010, 10:11 AM
ABBOV Re: if exists find last... 09-03-2010, 10:48 AM
snb Re: if exists find last... 09-03-2010, 11:03 AM
  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    NL
    MS-Off Ver
    Excel 2016
    Posts
    74

    if exists find last values in variable rows

    Hello,

    I'm new to VBA, managed to convert some script to my one but I need some help with the following:

    There an input sheet called " Invoer", this sheet shows all the sales of an department. I would like to make a summary of all the names en their sales. The problem is that the totals of every name are in different rows and columns.

    Example:
    Name 1 finds it totals at 3 rows down and 5 colums left.
    name 2 finds it totals at 5 rows down and 4 columns left.
    Name 3 finds it totals at 3 rows down and 7 coloms left.

    I know how to use the find function but not when it's so variable.

    I included the an example (with an extra problem ;-))

    Thanks in advance

    ABBOV
    Attached Files Attached Files
    Last edited by ABBOV; 09-03-2010 at 10:49 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1