View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] newpizzaco@gmail.com is offline
external usenet poster
 
Posts: 8
Default Copy Row Above, with a Twist Q

I have several Blank rows above each is a row of data (covering columns A-D), what I want to do is populate each blank row with the following:-

Col A - Copy the Text from Row Above
Col B - Insert fixed Text "ABC"
Col C - I wish to remain blank
Col D - Copy the value that is in Col C in Row above to this column

Do above until last Row in sheet (as sheet can have a variable length)

Basically above are Debit and Credit lines,