Excel VBA to Select Data from Other Worksheets - VBA Quickie 1

This Excel VBA Quickie shows you how to reference cells on separate worksheets and put their values onto other worksheets.

This is a reference tutorial that focuses specifically on showing you how to make cross-worksheet references in your macros. Once you learn this technique, referencing multiple worksheets in your macros will become much easier.

Enjoy!

#excel #vba #tutorial

[wayneedmondson]

Nice tip! Thanks for sharing your knowledge. Thumbs up!!

[darrylmorgan]

Really Cool Simple VBA Magic...Thank You Sir :)

[ruthescobedo]

Thank you so much! I've been looking through a gazzillion tutorials and forums and everyone kept saying it couldn't be done, but my logic/stubborness (can't tell which at this point) kept telling me had to be possible. THANKS FOR SHARING!

just quick question, when the data on the "Data" cell (where you're extracting the info) changes, it should, in theory, also update itself in the Master, right? in my case, the change will be often, so I REAAALLLY need it to update.

hope someone sees this :)

[adityajha]

Sir I followed your code to get value from next sheet but is there any way that formula will be visible in cell so auditor can check the linking

[musicbot]

Just to make sure this syntax is can allow manipulation on worksheets the user may or may not be looking at right?

[Jojosmith]

Hi Kevin, i tried to register but the system said I already registered. I dont bellieve that I registered to your site. I then tried to log in, the error message says incorrect pw. I tried to click the reset password but it required me to answer the security question which I do not know. Could you please test to see if you have the same issue? thanks a lot

[ludodegroote]

It jumps to a cell not a name. If you need to sort the data in de wroksheet "data" (extra lines etc.), it misses the point. So if for example, if asc-2 is moved to a place, the macro will still refers to cell A3 not to the new cell where you have "asc-2" in it, like when after new sort was moved to A6 for example.

[qamruddinmohammedi]

Want transfer data from one workbook to another.
Workbook - A
1. Receipt No.
2. Date
3. Name
4. Amount
To Workbook - B in two different Sheets
can you please help to write correct VBA code.

[anthonykishun]

How do u do total time of a specific item and input it into another worksheet

[JaguarLandRoverFan]

Hi TeachExcel,

Many thanks for your Video 👌.

How can I set and use "Data" as a variable?
I would like to copy out the data from the Worksheet "Data1", "Data2", ... as needed.
Here is my idea, which does not work:


Sub Read_Data()

Dim Variable_Worksheet_Name As Worksheet

Set Variable_Worksheet_Name =

=

End Sub

Here I want to enter the variable worksheet name:



Could you please help me?

Thanks in advance for your help.

Best regards
Chris