excel - Auto-filling a column with data once one cell has been updated -


how can auto-fill column 0's once 1 cell in column has been filled?

example:

original table

original table

once enter number cell in april column... enter image description here

i want column auto-fill rest of cells 0's, this... enter image description here

my first idea use worksheet_change event so...

private sub worksheet_change(byval target range) dim keycells range set keycells = range("h6:h16") 'h6 h16 range of april column, repeat each column in loop  if not application.intersect(keycells, range(target.address)) nothing     range("h6:h16").value = 0  end if end sub

but overwrites entire column, while want keep original value.

is there way excel return cell changed can change value of cells in column except one? or there easier way this?

with apr in h6:h16, data range seem in e6:p16.

private sub worksheet_change(byval target range)     if not intersect(target, range("e6:p16")) nothing         on error goto bm_safe_exit         application.enableevents = false         dim tgt range, var variant         each tgt in intersect(target, range("e6:p16"))             cells(6, tgt.column).resize(11, 1)                 if application.count(.cells) = 1                     var = tgt.value                     .cells = 0                     tgt = var                 end if             end         next tgt     end if bm_safe_exit:     application.enableevents = true end sub

always disable event handling before writing values worksheet or trigger worksheet_change event macro runs on top of original possibly triggering cascade of events.


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more