Read ( FRONT ) page data then transfer that data to the main data Sheet (OPEN)

Hi all and those game to take on this simple task



To start this thread I have a request in the software to start off doing an error check by checking " Front sheet " cells " S4 to U4 ", to ensure they have figures in them, it is possible that the race organisers may only run " 1" Leg due to weather or track conditions, but the typical day is 2 legs totaling " 80 " kms split across the 2 legs. then " Front sheet " ( Sheet 3 ) Cells " X3 to Z3 " if there are No 3rd Leg kms then " Z4 " must read " No Ckpts ".

The normal procedure is that the 80km, before the Ride starts it is possible that a Rider may withdraw their Horse before the ride starts so we need to enter a “ V or W “ into “ Open or Training “ Column “ C “.
Runners leave the ride base at 05:00 in my example I have set it up for 2 x 40 km legs with checkpoints 1,2,3, & 4 in the first leg on the completion of this leg all riders return to the RIDE BASE, ( a Time stamp is entered into the “Base “ following the last checkpoint on record, in our sample case it will be after Ckpts 4 & 8), for compulsory VET checks of the Horses, if at this check it is possible for any mount to be " Vetted Out " which is when " V" is entered against that
rider into " CELL L6 " on the " Front sheet " ( Sheet 3 ) , also a Rider may wish to " WITHDRAW" the mount that too can be entered into L6.

For your info " Front sheet "(Sheet 3) Cell N6 " will return a warning if a rider's number is entered in D6 and that Rider has been issued a " V or W " and cannot participate any further.

This where the work starts, when a rider's number is entered into Cell D6, then in Cell H6 they enter a Checkpoint number or “RIDE/BASE”, in " Front sheet "(Sheet 3) " Cell F6 " it automatically pulls up it indicates which leg that checkpoint is.

As in the sample file " Leg 1" has ckpts ( 1 to 4 ), the next step is to enter the time recorded for that chkpt when a time is entered say 0530 Cell J6 is formatted to show as " 05:30 ", as are all the cells in the OPEN sheet unless there is a " V or W " in " Cell L6 " what we need is to scan the " Open Sheet " ( Sheet 1 ), in this case for Rider number 2 scan across to checkpoint ( 2 ) and enter the time / or contents of Cell " L6 " if Cell " N6 " is flashing ( RED V or W ) then no entry can be made for the rider, because there is already an entry for that rider If they enter a " V or W " in " Front sheet " ( Sheet 3 ) " Cell L6 " this cell will take precedence over the TIME in cell J6 so the contents of Cell L6 will get placed into the cell for " 1st Leg Checkpoint 2 " NOTE: ( when there is a V or W in Cell L6 the cell J6 is cond formatted to go RED so NO TIME can be entered in J6, once all these conditions are met then copy the data over to the " Open Sheet " ( Sheet 1 ), when there is a time entered in " Front sheet " ( Sheet 3 ) " Cell Q6 " This time takes precedence over Cell J6, this time is entered in the next " Open Sheet " ( Sheet 1 ), " Time Out " cell in this case it will be cell " Open Sheet " ( Sheet 1 ), Cell J9, this will change depending on how many checkpoints are in the first leg .

The final instruction is to run the " MACRO Sub ClearCells() " so as to clear all the cells on the Front Page.

Any clarifications please call on me



Peter

I am closing this thread and rework the text to less complicate it all.

Peter

Hi all And anyone who will look here.

Please ignore all of my Post 1 here.

I have made this as brief as possible.
What I have is a range of cells on the (Front / Sheet 3), these cells Are D6, H6, J6, L6.
The data in these cells are to be copied over to the ( Open / Sheet 1), Search for the
Rider number/( Subject as to what is in Cell H6 is where J6 or L6 is placed ).

See Book2 attachment

After the data has been entered into the OPEN sheet Cells, return to “ Front/D6”

Then final instruction is to run the " MACRO Sub ClearOpen() " so as to clear all the cells on the Front Page.

Any clarifications please call on me

Hi all after some soul searching I have looked at what is expected of the coding.

What my aim is to convey the data from the " Front sheet 3 " to " Open Sheet 1

I need the VBA to process the data below

On " Sheet 3 " If Q6="",and L6="" select( D2, F2, J6,) vlookup "Sheet 1" (Cells A1:Z107 ) paste data from ( D2, F2, J6,) then run clear open macro select "Sheet 3 " D6 OR
On " Sheet 3 " If Q6="",and L6," V or W " select( D2, F2, L6,)(in this scenario ignore J6) vlookup "Sheet 1" (Cells A1:Z107 ) paste data from ( D2, F2, L6,) then run clear open macro select "Sheet 3 " D6 OR
On " Sheet 3 " If Q6>"", select D6 & Q6, for pasting (Timeout column on sheet 1)" (refer structure on "Sheet 7" L8-L30) then on "Sheet 1 "(In this case Column "J",(Cells A1:Z107 Paste Q6),then run clear open macro select "Sheet 3 " D6

Finally all the inputted data is stored on the Open Sheet and the cursor back to Sheet 3 D6


I trust this is a help



Thanks in advance

Peter

That looks more straightforward - let's hope it does the trick.

KISS - one step at a time!!!

Did you see my solution in your Base/Ride thread?

Att Steven ( Sintek )

Hoping the new entry makes better sense to you.

Peter

Peter Peter Peter...

Most of your threads have proven difficult to understand and this is one of the reasons...

On " Sheet 3 " If Q6="",and L6="" select( D2, F2, J6,) vlookup "Sheet 1" (Cells A1:Z107 ) paste data from ( D2, F2, J6,)

On Sheet3 D2 & F2 referred to in your explanations are part of a merged cell range C2:K2...
So I am assuming that should be D6 & F6
What are we supposed to lookup...and where do you want the range D6 | F6 | J6 to be pasted...

I suggest you upload a sample file ( Before | After ) with a few scenarios as mentioned and manually post the expected results...That way any member wanting to assist will easily understand your expected outcome...

Good morning to all and anyone to look at my project


I have 2 files attached the before and after, ( Enduro_3_Before and Enduro_3 ) for after

Both files have some cells already filled in the Enduro_3 shows on the open sheet the next cell wanting
attention. A series of <<< points to the cell on the OPEN sheet.
On the Front sheet I have prefilled in the data that needs sent to the Open sheet.

I have added a Book2 showing a coloured representation of Before and after

A question sought elsewhere without any files attached.

HTML Code: 

Peter

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Good Morning Alansidman

At this stage I have only asked if there is someone that is fluent with VBA I have NOT posted any files
on their site, several people here have looked at my request here and said pass.

In all fairness to any site I am aware of posting any cross link data.

Peter

Nonetheless, having reached out elsewhere for help, the rules, as you clearly understand, require you to provide a link or links here. Please do so now. Thanks.

Good morning Ali

I was hoping to have NOT go off site But I just cannot get my head around the start for the VBA.

I have provided the link on my post Sheet 8

Pete

Nonetheless, you should have provided that link without prompting as a courtesy to those of us here who try to help and guide you.

Having invested so much time in you, I feel personally let down that once again you have acted in contravention of the rules that you admit you know and understand.

For better visibility, here is the link that Pete has just provided in post #8: https://www.msofficeforums.com/excel...lp-please.html

What has worried me is that readers on get to see my original post Sheet 1 and go No-way-jose, and don't bother looking any further.

P

Why do you always think that there is a reason for you not to abide by the rules, Pete? You are no different to any other member. It really doesn't matter what you think: if you want help here, then you play by the rules. End of.

If I may in my defence I only posted if someone is fluent in VBA on a site That I AM NOT going back
to and before I got the chance to paste the link here I got the message from the Mod it was a matter
of minutes in the crossover.

I REALLY DO appreciate all the assistance from this forum and was reluctant to look elsewhere.

The post on the other site looks far more than that, and there is no indication in it that you've asked the same question here. Do their rules not require the same courtesy?

Ali here is the link

HTML Code: 

The original Site that I looked at was OZGRID that is the site I am refering to as not looking at again.

Peter

So there's another link that needs posting here, then - doesn't matter in the slightest whether or not you intend going back there.

The rule really is dead simple, Pete: you cross-post anywhere else, you provide a courtesy link here.

Att all Moderators on this Forum

Please be advised That I will NOT be going any further with this thread, as there has been no
usable help (Most likely MY FAULT ) I have decided to use a lot of If statements etc.
Those functions I know well.

And NO I am NOT spitting the dummy.

Thank you to all those that have helped so far you work will not go astray.

All other site will be closed off as well.

Peter

You won't be able to write to the log sheet without VBA. IF statements will never get you to where you want to be with this.

You were asked to provide the other link - you have not done so. For the benefit of others, it is here: https://www.ozgrid.com/forum/forum/h...database-sheet

I have cancelled that site, the Mod has ack as such

Att all Moderators on EF

It appears as if you are not allowed to defend any actions that you all see fit to say this person does not
follow the rules, NOT ONE of you have asked me for an explanation as to what has happened to warrant
these sanctions.
If anyone purposely broke rules fair enough, but please have the courtesy to hear them out before you crucify
them.

With that said I have marked thread (1286282) as Unsolved, in order that I can post elsewhere.

Once I have established contact there I will within 2 hours Cross post here if allowed to.

To those that have helped in the past I offer a BIG BIG thank you.

Regards

POTHOLES.

Originally Posted by Potholes

With that said I have marked thread (1286282) as Unsolved, in order that I can post elsewhere.

You don't need to mark anything as unsolved - you just need to post a cross-post link or links if you post the same query elsewhere.

Once I have established contact there I will within 2 hours Cross post here if allowed to.

As always, you are over-complicating the issue. It is very simple:

1. If you have asked a question elsewhere, you must post a link to it here straight away, whether you have had a response there or not.
2. You will also need to post a link back here on the other forum(s) as a courtesy to them.

NOT ONE of you have asked me for an explanation as to what has happened to warrant
these sanctions.

We don't need to ask you anything. There has been a whole series of indiscretions over a protracted period, as well you know: quite honestly, you have got away with more than most. Please stop complaining.

Please be advise for these cross links on this topic


https://www.ozgrid.com/forum/forum/h...ells-on-sheet1

https://www.msofficeforums.com/excel...ls-sheet1.html

Potholes