Help editing the cells a vba references..

[strud]

Yesterday someone kindly gave me a bit of coding that performed a calculation and action.

It works when the data starts in B4 & C4 and proceeds down the rows.

However, I now need it start in G6 & H6 and I am at a loss with how to alter it accordingly...

Please Login or Register  to view this content.

any ideas??

Thanks in advance

[Norie]

Change to this.

Please Login or Register  to view this content.

[jindon]

http://www.excelforum.com/excel-prog...in-colour.html

Please Login or Register  to view this content.

[strud]

Thanks again jindon you're a life saver.

One final question if I may (sorry!)

How do I paste the the copied rows into a different column - i.e. they just paste into column g & H whereas ideally I would like to paste them into column A.

Thanks again

[strud]

Norie that worked as well thank you

Change to this.

Please Login or Register  to view this content.

[jindon]

Then need to see your file with desired result, since your previous file hasn't got such data range.

[strud]

So currently because it is copying the whole row it copies the data into the upload sheet starting at column.

Whereas, I would like to copy to column A if this is somehow possible...?

[jindon]

What is "Location"?

Please Login or Register  to view this content.

[strud]

What is "Location"?

That is unrelated, just something to be added later.

Thanks jindon! that's brilliant. I am going to spend some time trying to get my head round how it works now lol.

Whilst you're here and have the file the second part of the large sub in module isn't working properly you wouldn't know why would you ?

[jindon]

No idea what you are trying to do with the code but

Please Login or Register  to view this content.

You don't have sheet called "Linn"

[strud]

yeah sorry I have changed that, it should have been 'pre-check', but even so it is just the pasting of the values again that won't work even when that is changed to 'Pre-Check'

[strud]

this part I mean...

Please Login or Register  to view this content.

[strud]

never mind I've worked it out, thanks again for all your time and help though jindon, much appreciated

[nilem]

Steve, try it

Please Login or Register  to view this content.

[jindon]

my guess

Please Login or Register  to view this content.

[strud]

Steve, try it

Who's steve?

I used:

Please Login or Register  to view this content.

...and that seemed to work.

[nilem]

Who's steve?

sorry, I mistook with another user srteub

[strud]

sorry, I mistook with another user srteub

No worries.

Your code did work as well by the way so thanks for that