excel - Copy certain values dependent on date -

-

i have 2 workbooks : monthly.xlsm , annual.xlsm . starting row 4 , column a, in annual.xlsm dates of year. in monthly.xlsm dates of current month starting column e (the next date in column g) . now, if date correspond , want copy monthly.xlsm cell column date annual.xlsm corespondent row.

ex:

monthly.xlsm has in e1 date 27.01.2016, in cell e4 value mike. in annual.xlsm, in a8 date 27.01.2016. if true, copy e4 monthly.xlsm dr8 in annual.xlsm.

monthly.xlsm has in g1 date 28.01.2016, in cell g4 value mary. in annual.xlsm, in a9 date 28.01.2016. if true, copy g4 monthly.xlsm dr9 in annual.xlsm.

i have tried formulas can't figure formula leap cells.

in annual.xlsm, in cell dr8 put in formula

hlookup(a8,monthly.xlsm!$e$1:$g$4,4,false).

change range , drag formula


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5); ...
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:...
Read more