VBA Code to read value input on one sheet and update with that value on different sheet

**MaD267** · 08-27-2018, 02:09 AM

Absolute novice with Excel VBA.

If I type in a value of "8" in a cell on a worksheet named "hours" and want that value (of 8) to update a specific cell on a worksheet named "updates" (and I have the row number and column number of the cell to be updated on the worksheet "updates"), what is the VBA code to accomplish this? Believe I need to pass three variables to a "routine" which are the target row number, column number and value.

Would very much appreciate specific guidance on this.

Thanks in advance!

**BadlySpelledBuoy** · 08-27-2018, 02:21 AM

Hi and welcome.

It's often easier for us to help if we can see the requirement in context. This is one of those times.

Could you attach a sample workbook and demonstrate what you want your expected outcome to be?

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

BSB

**ImranBhatti** · 08-27-2018, 02:44 AM

The syntax would be like bellow but as BSB said, a sample workbook is neccessary to see the context.

Please Login or Register  to view this content.

This will update your specific cell on sheet "Update" with the value of any cell of sheet "Hours" that is changed. Now you may want to control / limit this action if a specific if a cell of "Hours" is within a given address , like if target.row = some rownumber and target.column = some column number etc.

**MaD267** · 08-27-2018, 12:34 PM

Have attached a Workbook - please look at the first Tab called: Hours. Trying to update the Tab called: Actuals_Table. Tried to annotate in the Hours tab.

Thank you in advance!

**ImranBhatti** · 08-27-2018, 02:33 PM

Like this?

PHP Code:


Sub UpdateColumns()
    Dim shMain As Worksheet
    Dim shToUpdate As Worksheet
    Dim i As Long
    
    Set shMain = Sheets("Hours")
    Set shToUpdate = Sheets("Actuals_Table")
    
        With shMain
            For i = 6 To .Range("F17").End(xlToRight).Column
                shToUpdate.Cells(.Cells(17, i).Value, .Cells(18, i).Value).Value = .Cells(19, i).Value
            Next i
        End With
End Sub

**MaD267** · 08-27-2018, 03:21 PM

Thank you. As mentioned, am really a novice. So, now that you've graciously written out the code for me...how to invoke?

Assuming this gets copied into the "View Code" on the tabs...after that???????????

**ImranBhatti** · 08-28-2018, 12:55 AM

Please see the attached.

**MaD267** · 08-28-2018, 04:56 PM

Thank you very much for all of your assistance!!!!!!! Very greatly appreciated.....

**ImranBhatti** · 08-29-2018, 12:27 AM

If it helps you and fully answers your question , please do the following

1: Mark your thread as "Solved" (On top right of your first post in the current thread click on "Thread Tools>Mark as Solved"
2: Give some rep to the post the post that helped you. (At bottom left side of the post that helped click on * button)

**ImranBhatti** · 08-29-2018, 07:04 AM

Thanks for the rep+

VBA Code to read value input on one sheet and update with that value on different sheet

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code to read value input on one sheet and update with that value on different sheet

Re: VBA Code to read value input on one sheet and update with that value on different shee

Re: VBA Code to read value input on one sheet and update with that value on different shee

Re: VBA Code to read value input on one sheet and update with that value on different shee

Re: VBA Code to read value input on one sheet and update with that value on different shee

Re: VBA Code to read value input on one sheet and update with that value on different shee

Re: VBA Code to read value input on one sheet and update with that value on different shee

Re: VBA Code to read value input on one sheet and update with that value on different shee

Re: VBA Code to read value input on one sheet and update with that value on different shee

Re: VBA Code to read value input on one sheet and update with that value on different shee

Thread Information

Users Browsing this Thread

Similar Threads

Want to update stock sheet as and when i enter product code in invoice sheet

[SOLVED] Vba code to copy unique email id data from input sheet to output sheet

VBA Code to find range from Input sheet and hide respective columns in sheet 2.

[SOLVED] Update a date on Sheet 1 with radio buttons/input from Sheet 2

Update cell Values or Read Values in other sheet (change colour of autoshape with VBA code

Excel 2007 : taking values from sheet 1 to read sheet 2 and input data on sheet 3 in that order

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions