I have three columns of data:

A Category
B Sub-category
C Data

It looks like this:

A B C
1 Telephone IT 40.00
2 Finance 15.00
3 HR 20.00
4 Postage IT 0.00
5 finance 10.00

I need to copy A1 to A2 and A3 and A4 to A5. How do I do this without
having to copy and paste?

Thank you

Am,anda

first active Auto Filter (Data-Filter Autofilter)
filter Column A "Blank"
cell A3 - =A2
select entire column (from A3 to till down) and press Ctrl+D
then remove filter.
Copy entire column A and paste as a value

"Amanda" wrote:

I have three columns of data:

A Category
B Sub-category
C Data

It looks like this:

A B C
1 Telephone IT 40.00
2 Finance 15.00
3 HR 20.00
4 Postage IT 0.00
5 finance 10.00

I need to copy A1 to A2 and A3 and A4 to A5. How do I do this without
having to copy and paste?

Thank you

Am,anda

Nice trick Rafeek, it worked fine with me.


thanks
shail


Muhammed Rafeek M wrote:
first active Auto Filter (Data-Filter Autofilter)
filter Column A "Blank"
cell A3 - =A2
select entire column (from A3 to till down) and press Ctrl+D
then remove filter.
Copy entire column A and paste as a value

"Amanda" wrote:

I have three columns of data:

A Category
B Sub-category
C Data

It looks like this:

A B C
1 Telephone IT 40.00
2 Finance 15.00
3 HR 20.00
4 Postage IT 0.00
5 finance 10.00

I need to copy A1 to A2 and A3 and A4 to A5. How do I do this without
having to copy and paste?

Thank you

Am,anda

Thanks.

I didn't make myself clear.

I need A1 to go to A2 and A3
and need A4 to go to A5

I think this is a slightly different question??

Regards

Amanda

"Muhammed Rafeek M" wrote:

first active Auto Filter (Data-Filter Autofilter)
filter Column A "Blank"
cell A3 - =A2
select entire column (from A3 to till down) and press Ctrl+D
then remove filter.
Copy entire column A and paste as a value

"Amanda" wrote:

I have three columns of data:

A Category
B Sub-category
C Data

It looks like this:

A B C
1 Telephone IT 40.00
2 Finance 15.00
3 HR 20.00
4 Postage IT 0.00
5 finance 10.00

I need to copy A1 to A2 and A3 and A4 to A5. How do I do this without
having to copy and paste?

Thank you

Am,anda

1. Go to Column-D

2. Type "=A1" in D1

3. Type following in D2
=IF(A2="",D1,A2)

4. Select D2 to D100 (or up to last cell) and click Ctrl-D
OR
copy and past it to D3, D4, etc.,



Advance thanks for rating my post.

"Amanda" wrote:

I have three columns of data:

A Category
B Sub-category
C Data

It looks like this:

A B C
1 Telephone IT 40.00
2 Finance 15.00
3 HR 20.00
4 Postage IT 0.00
5 finance 10.00

I need to copy A1 to A2 and A3 and A4 to A5. How do I do this without
having to copy and paste?

Thank you

Am,anda

Hi Amanda,

Select the range in A column that you need to copy the previous items, Press
F5 and select SPECIAL, check the blank or empty cells (as I'm working in a
Brazilian portuguese excel, I am no sure if its blank or empty).

excel should select the cells A2, A3 and A5 and the A2 should the active
cell, in A2 type =a1 and press CTRL and Enter

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Amanda" escreveu:

Thanks.

I didn't make myself clear.

I need A1 to go to A2 and A3
and need A4 to go to A5

I think this is a slightly different question??

Regards

Amanda

"Muhammed Rafeek M" wrote:

first active Auto Filter (Data-Filter Autofilter)
filter Column A "Blank"
cell A3 - =A2
select entire column (from A3 to till down) and press Ctrl+D
then remove filter.
Copy entire column A and paste as a value

"Amanda" wrote:

I have three columns of data:

A Category
B Sub-category
C Data

It looks like this:

A B C
1 Telephone IT 40.00
2 Finance 15.00
3 HR 20.00
4 Postage IT 0.00
5 finance 10.00

I need to copy A1 to A2 and A3 and A4 to A5. How do I do this without
having to copy and paste?

Thank you

Am,anda

Rafeek, Marcelo and Naveen all have the tricks with the same results.
but i guess Amanda wants the A1 to moved to A2 and A3, and A4 to be
moved to A5. Moved means cut and pasted.

Am I correct Amanda?

Anyway the tricks are really great and I will use them to my projects.



Amanda wrote:
Thanks.

I didn't make myself clear.

I need A1 to go to A2 and A3
and need A4 to go to A5

I think this is a slightly different question??

Regards

Amanda

"Muhammed Rafeek M" wrote:

first active Auto Filter (Data-Filter Autofilter)
filter Column A "Blank"
cell A3 - =A2
select entire column (from A3 to till down) and press Ctrl+D
then remove filter.
Copy entire column A and paste as a value

"Amanda" wrote:

I have three columns of data:

A Category
B Sub-category
C Data

It looks like this:

A B C
1 Telephone IT 40.00
2 Finance 15.00
3 HR 20.00
4 Postage IT 0.00
5 finance 10.00

I need to copy A1 to A2 and A3 and A4 to A5. How do I do this without
having to copy and paste?

Thank you

Am,anda