I have to create a record which requires typing same NAME and D.O.Birth in 3 other columns.
Is there any function I can you so that the text I enter in COLUMN C automatically copies into COLUMN P & COLUMN AE ?
(I have no experience in using VBA)
I have to create a record which requires typing same NAME and D.O.Birth in 3 other columns.
Is there any function I can you so that the text I enter in COLUMN C automatically copies into COLUMN P & COLUMN AE ?
(I have no experience in using VBA)
Formula:Please Login or Register to view this content.
In P2 and copy down. Same in AE2.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you @fotis1991 it worked.. but, i am getting a border and different font in the destination cell. Is there a way to keep the source formatting ?
Capture.PNG
Last edited by ymopuri; 04-24-2015 at 12:31 PM. Reason: Image Attached
format the whole sheet as you prefer it to be since the destination and the source are on the same sheet.
If I've helped U pls click on d *Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks