Populating values from one sheet to other sheet with VBA code with a created link.

**mansh34** · 10-02-2023, 04:06 AM

Please help with populating values from one sheet to other sheet with VBA code with a created link. I have data in Home(sheet name) range A2:B4. What i wish to achieve is this, with a VBA code if Home(sheet name) cell A2 is not empty then an hyperlink or link whichever is created in Home(sheet name) cell C2 with a name "Click", when you Click on it will take you to View(sheet name) and populate the values in Home(sheet name) cell A2 and cell B2 in View(sheet name) cell A2 and Cell B2 respectively but if Home(sheet name) cell A2 is empty then Cell C2 home(Sheet Name) is empty and no link created. Same applies to other range not empty from range A2:B4. thanks in advance.

**dangelor** · 10-02-2023, 08:54 AM

Not quite sure what it is you're trying to accomplish, but possibly...

Place this code in a standard code module...

Please Login or Register  to view this content.

...and place this code in the HOME worksheet code module...

Please Login or Register  to view this content.

**mansh34** · 10-02-2023, 09:36 AM

I have uploaded the VBA file and my effort but can't get the result. I want to populate the value in Worksheets("HOME") cell A2 and B2 in Worksheets("VIEW") cell A2 and B2 when you click on a link in Worksheets("HOME") cell C2 also populate the value in Worksheets("HOME") cell A3 and B3 in Worksheets("VIEW") cell A3 and B3 when you click on a link in Worksheets("HOME") cell C3 etc..

The Code is in the module and below as well

Sub Hyperlink_stats_1()

Worksheets("HOME").Select
Range("C2").Select

If Range("A2").Value = "" Then
Range("C2").Value = ""
Else

ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:="'VIEW'!A1", TextToDisplay:="CLICK"

Worksheets("VIEW").Range("A2").Value = Worksheets("HOME").Range("A2").Value
Worksheets("VIEW").Range("B2").Value = Worksheets("HOME").Range("B2").Value

End If

Call Hyperlink_stats_2

End Sub

Sub Hyperlink_stats_2()

Worksheets("HOME").Select
Range("C3").Select

If Range("A3").Value = "" Then
Range("C3").Value = ""
Else

ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:="'VIEW'!A1", TextToDisplay:="CLICK"

Worksheets("VIEW").Range("A2").Value = Worksheets("HOME").Range("A3").Value
Worksheets("VIEW").Range("B2").Value = Worksheets("HOME").Range("B3").Value

End If

End Sub

**dangelor** · 10-09-2023, 07:36 AM

Attached is a file with the code from above.

If it doesn't do what you want, then please submit a file without code, showing the data before any code runs and the results you expect after the code runs.

**jindon** · 10-09-2023, 08:39 AM

mansh34,

Here's my interpretation of your question.
It will create/delete hyperlink if you change any cells(2) in A2:B4.
1) to ThisWorkbook code modue

Please Login or Register  to view this content.

2) to HOME sheet code module

Please Login or Register  to view this content.

**mansh34** · 10-11-2023, 08:33 AM

Almost close, that was great. But they are populating in different rows in view(sheet), I want it to populate in same row in view(sheet) when you click on any of the links created in home(sheet). Again how can I modify the data in home(sheet) from single column A to double columns A and B, and get any of the links click populate in the same cell let’s say cell A2 and B2 Thank you in advance

**jindon** · 10-11-2023, 08:41 AM

Then change one line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**mansh34** · 10-20-2023, 06:45 AM

Yes, I have it now, how can I modify to have more rows and columns on the home(sheet)?

**jindon** · 10-20-2023, 07:38 AM

What do you mean?

Upload a workbook, and I may see what you are trying to say.

**mansh34** · 10-20-2023, 11:43 PM

i have uploaded a file.

**jindon** · 10-21-2023, 12:11 AM

Delete all the codes you tried to modify, I guess, in HOME sheet module and replace with

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

**mansh34** · 12-24-2023, 03:54 PM

Yes friend, so sorry for late reply. This is what i really want, you nailed it yeah. i was trying to substitute from start of cell A2 & B2(Home) to either cell C10 & G10 (Home) and get it populate in G7 & J7 (View). Also i want the "Click" created to be empty each time the corresponding cells are empty, i couldn't figure it out. Please don't leave me here. thanks in advance.

Populating values from one sheet to other sheet with VBA code with a created link.

LinkBack

Thread Tools

Rate This Thread

Display

Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Re: Populating values from one sheet to other sheet with VBA code with a created link.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Data from different sheet populating into Summary sheet when new sheets are created

Update Values to an Existing Sheet from every new Sheet created by Macro

Link cells of automatically created sheet to already existing sheet

Populating sheet 2 with combobox values after sheet 1 full

Attach code to each sheet and if a new sheet is created add the code to this automatically

How Do I save a Camera Icon Dynamic Picture Link created in the Sheet itself?

Populating a report sheet based on imported values on another sheet

Bookmarks

Bookmarks

Posting Permissions