Haven't got a clue!!!

[DarrenG]

Here is a cut down sample of a spreadsheet i'm working on.

Sheet 1 and 2 are updated daily, and i need sheet 3 to update automatically taking the required data from the other 2 sheets, depending on whether or not the approval column is Y or N.

This should be fairly straightforward but I haven't coded in a while and have never used VBA.

Any help would be appreciated.

Thanks

- DarrenG

[WLMPilot]

Not sure you need VBA in your spreadsheet. It sounds like you just need some
IF statements in specific cells on sheet 3 that look at the approval column
in sheets 1 & 2, then produces values in sheet3. Can you be more specific of
what you are trying to do.

"DarrenG" wrote:

>
> Here is a cut down sample of a spreadsheet i'm working on.
>
> Sheet 1 and 2 are updated daily, and i need sheet 3 to update
> automatically taking the required data from the other 2 sheets,
> depending on whether or not the approval column is Y or N.
>
> This should be fairly straightforward but I haven't coded in a while
> and have never used VBA.
>
> Any help would be appreciated.
>
> Thanks
>
> - DarrenG
>
>
> +-------------------------------------------------------------------+
> |Filename: test.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=5079 |
> +-------------------------------------------------------------------+
>
> --
> DarrenG
> ------------------------------------------------------------------------
> DarrenG's Profile: http://www.excelforum.com/member.php...o&userid=36529
> View this thread: http://www.excelforum.com/showthread...hreadid=564220
>
>

[DarrenG]

The IF statements work fine for just one sheet.

Like I mentioned, this is only a sample. The actual spreadsheet records alot more information from 2 different sources (Sheet 1 & 2). Sheet 3 takes only some of the data.

I posted the actual spreadsheet last week, search down the list somewhere.

I moved onto this smaller sample to try and get the basic code required.

- DarrenG