I have an average knowledge of Excel. I am looking for a formula so I can
copy the values in column "a" into column "b". As I enter the value in the
first column I want excel to automatically copy it into the second.
I have an average knowledge of Excel. I am looking for a formula so I can
copy the values in column "a" into column "b". As I enter the value in the
first column I want excel to automatically copy it into the second.
=if(a1="","",a1)
and drag down as far as you need.
Bman wrote:
>
> I have an average knowledge of Excel. I am looking for a formula so I can
> copy the values in column "a" into column "b". As I enter the value in the
> first column I want excel to automatically copy it into the second.
--
Dave Peterson
In cell B1, put the following formula and copy it down column B as far as you
wish....
=IF(A1="","",A1)
Vaya con Dios,
Chuck, CABGx3
"Bman" wrote:
> I have an average knowledge of Excel. I am looking for a formula so I can
> copy the values in column "a" into column "b". As I enter the value in the
> first column I want excel to automatically copy it into the second.
Assuming that you want the cells in column B to remain blank until something
is added to the cells in column A, in Cell B1 enter =IF(A1="","", A1) and
copy down through your range.
"Bman" wrote:
> I have an average knowledge of Excel. I am looking for a formula so I can
> copy the values in column "a" into column "b". As I enter the value in the
> first column I want excel to automatically copy it into the second.
thanks very much, one more question along the same topic....how would I copy
a cell from one worksheet to another worksheet within the same workbook. The
same thing, where excel automatically would update the cell.
Thanks
"Dave Peterson" wrote:
> =if(a1="","",a1)
>
> and drag down as far as you need.
>
> Bman wrote:
> >
> > I have an average knowledge of Excel. I am looking for a formula so I can
> > copy the values in column "a" into column "b". As I enter the value in the
> > first column I want excel to automatically copy it into the second.
>
> --
>
> Dave Peterson
>
I think you just need to typ the sheet name in front of the cell references followed by an exclamation mark.
So - =IF(Sheet1!A1="","", Sheet1!A1)
But one of the more experienced members may want to clarify, as I'm still on the learning curve with some way to go.
HTH
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks