Transfer data to column "A" from column "C"

**elinkonlineservices** · 01-19-2013, 07:18 PM

Hi Every one,
If someone can help me with following.
I have two columns "A"&"C"
I want to paste data from column "c" to "A" but in specified cells (cells containing * sign as shown below).
Required data example also given in the end of this query.
A B
aaaa gfh126534
bbbb gfh764358
gggg gfh876454
* gfh35534

aaaa
bbbb
gggg
*

aaaa
bbbb
gggg
*

aaaa
bbbb
gggg
*

aaaa
bbbb
gggg
*
required is :

aaaa
bbbb
gggg
gfh126534

aaaa
bbbb
gggg
gfh764358

aaaa
bbbb
gggg
gfh876454

aaaa
bbbb
gggg
gfh35534

aaaa
bbbb
gggg
gfh83769
Waiting for someone kind enough to reply for help.
Thank you.

**zbor** · 01-19-2013, 07:22 PM

Forgot to attach example

**jeffreybrown** · 01-19-2013, 07:30 PM

You posted this question in the Formulas sub forum, but pretty sure you might require a macro...

Based on the little sample posted, maybe...

Please Login or Register  to view this content.

**elinkonlineservices** · 01-21-2013, 11:21 AM

Query.xlsx

Thank you for your reply i hope this attachment will result more better answers.

**jeffreybrown** · 01-21-2013, 11:45 AM

Look at the code in post #3. Does it do for you what you require?

**elinkonlineservices** · 01-22-2013, 06:19 AM

I am not able try this one as i am not familiar with "macro"
can you help me other than macros?

**jeffreybrown** · 01-22-2013, 08:42 AM

No sorry I do not know of a formula that will do this for you.

Place in normal module

Where to paste code
Highlight macro to copy >> Ctrl + C >> Open your workbook
Alt + F11 >> opens the Visual Basic Editor (VBE)
Ctrl + R >>opens the Project Explorer (if not already open on left side of screen)
Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
Paste code >> Ctrl + V (right side of screen)
Alt + Q >> exits VBE and returns to Excel
Back in Excel >> Alt + F8 >> Macro Dialog Box >> Highlight macro >> Run