update a value in another worksheet

M

marcusb

hi i have a worksheet "scform" that pulls values from another worksheet
"individual static". Which values is selected by a pulldown list which
chooses one of the rows in "individual static" based on candidate name.


pendant on a process being performed i want to then update those
values.

eg

stockpile1 stockpile2 stockpile3
399 267 0


after processing the new values are

stockpile1 stockpile2 stockpile3
244 399 267

is there a way to build a macro using the vb function and Range.select
whilst pulling the values to "select" from my open sheet?

i.e somethign like

Range("AM<USE ROW NUMBER FROM MATCH FUNCTION>").Select
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to update a value from a linked worksheet back to the master worksheet? 0
What is the best way to lookup from another worksheet? 0
Conditional Format Won't Update Cell 8
How to Find Data in another Worksheet without activating it? 2
Pulling a cell reference--clickable cells? 1
Excel formulas pulling from another worksheet changes when sorted 1
Formulas within list fail to update after sorting/filtering 0
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3

Top