Search : in
By :

If a1= active, copy a2-a6 to a1-a5 on sheet2

Last answer on Nov 9, 2009 2:21:31 am GMT batman28x, on Nov 8, 2009 8:47:37 pm GMT 
 Report this message to moderators

Hello,

I am new to macros and would like to know if it is possible to create something to do the following:

I have a list of jobs that are either active or inactive (sheet1,column A) and if the job is active, i would like copy the information in that row (sheet1, a2-a6) onto a second sheet (sheet2,a1-a5) I would like it to then move to the next row and do the same for approximately 30 rows.

Is this possible?


Thanks in advance,

Batman

Configuration: Windows XP Internet Explorer 8.0

Best answers for « if a1= active, copy a2 a6 to a1 a5 on sheet2 » in :
Excel – Comparing cell A1 to entire A column in Sheet 2 ShowExcel – Comparing cell A1 to entire A column in Sheet 2 Issue Solution Note Issue I have been trying to compare sheet1 A2 to sheet2 A2 through A500 and if it exists somewhere in sheet2's a col then copy that entire row to a new sheet....
Copy an entire partition on Vista ShowCopy an entire partition on Vista Issue Solution Issue It is possible to copy the entire partition on your hard drive with the DVD of vista. It is very useful if you want to change your hard drive in order to restore all data....
Activate Windows XP ShowActivate Windows XP To determine if your version of Windows is activated or windows reminds you to activate the system (normally windows must be activate 30 days after installation). So to activate Windows manually just click on...
Download CopyTrans Suite ShowCopyTrans Suite is a set of practical tools for your Ipod or Iphone. It contains: · CopyTrans v2.37 · CopyTrans Photo v2.21 · iLibs v1.13 · iCloner v1.07 · CopyTrans Doctor v1.015 · CopyTrans Manager v0.720 · SyncGuardian...
Download Shadow Copy ShowNormally, the administrators of files as the explorer Windows do not allow the copy of opened or blocked files. For instance if you are treating a document Word, you have no possibility of copying it in another file during its edition. Shadow Copy is...
Download Active Desktop Calendar ShowActive Desktop Calendar is a calendar which integrates into Windows’ desktop. It is completely customizable and integrates into: - the calendar of Google, - ICS file web, - Outlook to display your meetings and tasks on the desktop. It...

1

 venkat1926, on Nov 9, 2009 2:21:31 am GMT

Can be done but some clarification is required

suppose A1 has column heading "job activity"

A2 down have entries"active" or "non active".
suppose A2 has entry "active" what are entries in A3,A4,A5,A6,A7. do you want A2:A6 to be copied or A3 to A7.
can you post the first 10 entries of column A and say exactly what you want

Reply to venkat1926