,Hello Again

Could i get some help with this.
How does one get an activecell , that has a value of 1, that is copied from
sheet1 to sheet2 so that the value changes from 1 to a 2 and so on depending
on how many times I copy a sheet.

I hope this makes sense

Thanks in Advance
Allan

=sheet1!(a1).

I think you are asking for this formula. It will change the value of current
cell (doesn't matter on which sheet you are currently working) to value of
Sheet 1's A1 cell. Means if Sheet 1 A1 = 100 and you are currently working on
Sheet 2 F1, then this formula will show the F1 value to 100 and if you will
change the value of A1 from Sheet 1 then it will automatically changed on
Sheet 2 as well.

Hope this will help, let us know!
"A.R.J Allan Jefferys" wrote:

> ,Hello Again
>
> Could i get some help with this.
> How does one get an activecell , that has a value of 1, that is copied from
> sheet1 to sheet2 so that the value changes from 1 to a 2 and so on depending
> on how many times I copy a sheet.
>
> I hope this makes sense
>
> Thanks in Advance
> Allan
>
>

Hi rajkohli

Thanks for the reply.
Sorry it did'nt, because I failed to mention that the activecell is is an
entirerow, so when it pastes to the new sheet it removes the formula. Is
there a way to turn a 1 into a 2 after it has been copied to the newsheet.

"rajkohli" wrote:

> =sheet1!(a1).
>
> I think you are asking for this formula. It will change the value of current
> cell (doesn't matter on which sheet you are currently working) to value of
> Sheet 1's A1 cell. Means if Sheet 1 A1 = 100 and you are currently working on
> Sheet 2 F1, then this formula will show the F1 value to 100 and if you will
> change the value of A1 from Sheet 1 then it will automatically changed on
> Sheet 2 as well.
>
> Hope this will help, let us know!
> "A.R.J Allan Jefferys" wrote:
>
> > ,Hello Again
> >
> > Could i get some help with this.
> > How does one get an activecell , that has a value of 1, that is copied from
> > sheet1 to sheet2 so that the value changes from 1 to a 2 and so on depending
> > on how many times I copy a sheet.
> >
> > I hope this makes sense
> >
> > Thanks in Advance
> > Allan
> >
> >

Sorry but I think I didn't get your point but I have tried somethin'. Let us
know, if this one helps you.

I have sheet 1 with:

A1 = 1, B1 = 2, C1 = 3, D1 = 4, E1 = 5

I would like to copy these values to Sheet 2 while increasing value with +1.
So, on sheet second I use a formula.

Sheet 2

=sheet1!a1+1

Then I copy that formula to entire row. it work fine. Hope it does the same
for you.

"A.R.J Allan Jefferys" wrote:

> Hi rajkohli
>
> Thanks for the reply.
> Sorry it did'nt, because I failed to mention that the activecell is is an
> entirerow, so when it pastes to the new sheet it removes the formula. Is
> there a way to turn a 1 into a 2 after it has been copied to the newsheet.
>
> "rajkohli" wrote:
>
> > =sheet1!(a1).
> >
> > I think you are asking for this formula. It will change the value of current
> > cell (doesn't matter on which sheet you are currently working) to value of
> > Sheet 1's A1 cell. Means if Sheet 1 A1 = 100 and you are currently working on
> > Sheet 2 F1, then this formula will show the F1 value to 100 and if you will
> > change the value of A1 from Sheet 1 then it will automatically changed on
> > Sheet 2 as well.
> >
> > Hope this will help, let us know!
> > "A.R.J Allan Jefferys" wrote:
> >
> > > ,Hello Again
> > >
> > > Could i get some help with this.
> > > How does one get an activecell , that has a value of 1, that is copied from
> > > sheet1 to sheet2 so that the value changes from 1 to a 2 and so on depending
> > > on how many times I copy a sheet.
> > >
> > > I hope this makes sense
> > >
> > > Thanks in Advance
> > > Allan
> > >
> > >

Thanks Papabear
It was food for thought with your suggestion, and have now sorted it out.

Thanks Allan

"PapaBear56" wrote:

>
> A method for doing what I think you want to do is pretty simple. I've
> seen it done using a macro (Someone else will need to help you with the
> macro coding. I'm not good enough yet to do it off the top of my head.)
>
> What you want the macro to do is when the user clicks the button, the
> value of the active cell is read, 1 is added to it, and the results are
> placed back in the activecell location. One thing I've messed with and
> it may just be overkill is I keep a running total somewhere away from
> where the user is working and use it to help validate the information
> the user sees.
>
> I hope this helps.
>
> A.R.J Allan Jefferys Wrote:
> > ,Hello Again
> >
> > Could i get some help with this.
> > How does one get an activecell , that has a value of 1, that is copied
> > from
> > sheet1 to sheet2 so that the value changes from 1 to a 2 and so on
> > depending
> > on how many times I copy a sheet.
> >
> > I hope this makes sense
> >
> > Thanks in Advance
> > Allan
>
>
> --
> PapaBear56
>

Thankyou

Its does, but that is not what i was looking for, however i do have it
sorted now using vb.
regards Allan

"rajkohli" wrote:

> Sorry but I think I didn't get your point but I have tried somethin'. Let us
> know, if this one helps you.
>
> I have sheet 1 with:
>
> A1 = 1, B1 = 2, C1 = 3, D1 = 4, E1 = 5
>
> I would like to copy these values to Sheet 2 while increasing value with +1.
> So, on sheet second I use a formula.
>
> Sheet 2
>
> =sheet1!a1+1
>
> Then I copy that formula to entire row. it work fine. Hope it does the same
> for you.
>
> "A.R.J Allan Jefferys" wrote:
>
> > Hi rajkohli
> >
> > Thanks for the reply.
> > Sorry it did'nt, because I failed to mention that the activecell is is an
> > entirerow, so when it pastes to the new sheet it removes the formula. Is
> > there a way to turn a 1 into a 2 after it has been copied to the newsheet.
> >
> > "rajkohli" wrote:
> >
> > > =sheet1!(a1).
> > >
> > > I think you are asking for this formula. It will change the value of current
> > > cell (doesn't matter on which sheet you are currently working) to value of
> > > Sheet 1's A1 cell. Means if Sheet 1 A1 = 100 and you are currently working on
> > > Sheet 2 F1, then this formula will show the F1 value to 100 and if you will
> > > change the value of A1 from Sheet 1 then it will automatically changed on
> > > Sheet 2 as well.
> > >
> > > Hope this will help, let us know!
> > > "A.R.J Allan Jefferys" wrote:
> > >
> > > > ,Hello Again
> > > >
> > > > Could i get some help with this.
> > > > How does one get an activecell , that has a value of 1, that is copied from
> > > > sheet1 to sheet2 so that the value changes from 1 to a 2 and so on depending
> > > > on how many times I copy a sheet.
> > > >
> > > > I hope this makes sense
> > > >
> > > > Thanks in Advance
> > > > Allan
> > > >
> > > >