Update Multiple Field values based on selections

[paulm]

Hi,

I am currently creating adocument to allow the user to forecast future revenuebased on price changes. Currently a user can edit anindividual price through an editable table, but Iwould like to be able to edit a group of pricesin one go based on the current selections.

Would anyone have asuggestion for how you could write a macro to do this, or if you have a different suggestion? Any help would be much appreciated.

Thanks,

Paul

[Anonymous]

Hi Paul,

Think of using variables and/or set analysis.  You question is too open to give a more specific answer.  It doesn't look like you need a macro for this, although it may be used as a paert of the solution.

Regards,
Michael

[paulm]

Hi Michael,

Thank you for taking the time to reply.  I have attached an example doc I have been playing around with.

Basically we have a few hundred customers which we group.  I would like to have an input box where I could enter a Rate then it updates every customer who is currently selected. 

e.g. if I have selected customer A in my example I would like on the click of the button to only update records 1 2 and 3.

Hopefully I am missing something simple to do this.

Many thanks,

Paul

[Anonymous · Accepted solution]

Hi paulm

     Hope the attached macro qv file will be helpful for you...

Regards

Ashok

[qliksus]

Hi try this macro

sub updateRate

set Cnt = ActiveDocument.Fields("ID").getpossiblevalues

for i = 1 to Cnt.count

set obj = ActiveDocument.GetSheetObject("CH01")
obj.SetInputFieldCell i,1, Activedocument.variables("vRate").getcontent.string    

next

end sub

let me know if there are any issues

[paulm]

Hi Guys,

This looks to be exactly what I am after! Great work! Thanks!

Paul