(Last Updated On: December 22, 2021)

Macros ExcelSearch and PrintData

MS Excel 2019 में Macros के द्वारा किसी दुसरे शीट के डाटा को Search और Print कैसे करे

Step By Step फॉलो करें

Open MS Excel

Make 3 Sheets Named By “Database”, “Sheet2” and “Log”

Macros ExcelSearch and PrintData by VedantSri Varanasi

Design “Database” Sheet As Given Below Image

Macros ExcelSearch and PrintData by VedantSri Varanasi

Now Design 2nd Sheet Called “Sheet2” as Given Below Picture

Macros ExcelSearch and PrintData by VedantSri Varanasi

For Making SEARCH and PRINT Button:-

Go To Developer Menu > Click on Insert Button in Controls Toolbox > Now Click on Button (Form Control) > Draw SEARCH and PRINT Button where You Want

For Enable Developer Menu:-

Go to File Menu > Click on Options Button > Click on Customize Ribbon >Now Add Developer Menu

Macros ExcelSearch and PrintData by VedantSri Varanasi

Now Design 3rd Sheet Called “Log” as Given Below As Picture

Macros ExcelSearch and PrintData by VedantSri Varanasi

Now Record Marco For Data Entry, For Recording Please Follow The Steps

A-Right Click on Row No-6 in “Sheet2”

B- Left Click on Copy Option

C- Left Click on “Database” Tab

D- Right Click on Row No-2 in the “Database” Sheet

E- Left Click on “Insert Copied Cell” Option

F- Left Click on “Sheet2” Tab

G- Now Press Enter Button to Stop Selection

H- Now Click on Stop Recording Button

Now we Type Coding in Visual Basic Page So Follow the Step Carefully

Go To Developer Menu

Now Click on Visual Basic Button

Now Go To Insert Menu and Click on Module Button In Visual Basic Page

Now Type Given Below Coding on Module-2 Page

Sub searchdata()
Dim erow As Long
Dim ws As Worksheet
Dim lastrow As Long
Dim count As Integer


lastrow = Sheets("Database").Cells(Rows.count, 1).End(xlUp).Row
count = 0
For x = 2 To lastrow

If Sheets("Database").Cells(x, 1) = Sheet2.Range("B3") Then
Sheet2.Range("A11") = Sheets("Database").Cells(x, 1)
Sheet2.Range("B11") = Sheets("Database").Cells(x, 2)
Sheet2.Range("C11") = Sheets("Database").Cells(x, 3)
Sheet2.Range("D11") = Sheets("Database").Cells(x, 4)
Sheet2.Range("E11") = Sheets("Database").Cells(x, 5)
Sheet2.Range("F11") = Sheets("Database").Cells(x, 6)
count = count + 1
End If


Next x
If count = 0 Then
Set ws = Worksheets("Log")
erow = ws.Cells(Rows.count, 1).End(xlUp).Offset(1, 0).Row
ws.Cells(erow, 1) = Date
ws.Cells(erow, 2) = Time
ws.Cells(erow, 3) = Sheet2.Range("B3")
Sheet2.Range("A11:F11").ClearContents
End If
End Sub

Sub printdata()
Sheet2.Range("A11:F11").PrintPreview
Sheet2.Range("A11:F11").PrintOut
End Sub

Now save the Page As Excel Macro-Enabled Workbook Format

Macros ExcelSearch and PrintData by VedantSri Varanasi

now Close “Visual Basic Page”

and Right Click on the “SEARCH” Button and Click on the “Assign Macro” Option Then Select searchdata From Macro List

Macros ExcelSearch and PrintData by VedantSri Varanasi
Macros ExcelSearch and PrintData by VedantSri Varanasi

Again Now Right Click on the “PRINT” Button and Click on the “Assign Macro” Option and Select “printdata” From Macro List

And Finally, Hip-Hip Hurry Because Your Project is Completed Bro( Macros ExcelSearch and PrintData )

Part – 1 Video

Watch Excel Project Related Video Link Below

Video For Excel Data Entry Userform 2021: Excel UserForm Buttons Macros Project-1

Video For Excel Data Entry Userform 2021: Excel Userform Buttons Macros Project-2

Video For Excel Macros Search & Print: Excel Macros Search & Print Project

Video for Student Excel Entry Form: Excel Students Entry Form Macros Project-1

Video for Student Excel Entry Form: Excel Student Entry Form Macros Project-2

Video for Data Transfer in Excel: Excel Transfer Data Macros Project

VedantSri Computer Institute Varanasi

Macros ExcelSearch and PrintData

provides the best Computer CoursesClasses, and Training in Varanasi. There is NIELIT Courses CCC, BCC, O’level, Certificates, and Diploma Computer Courses available with the best training materials. Also Available Top 100 Best Computer Courses, For Example, OMDCAADCADTPDFAADAMADTP, ADFA, DCEMS Office.

VedantSri Computer Coaching update CCC Online Test 2020 in vedantsri.net. There are some important computer Courses for jobs CCC ClassTyping, Internship, And Spoken English Available Free of cost with Offer. More than 50 Computer Courses are available with a 50% Fee Discount in VedantSri Varanasi.

You can get the Best Digital Marketing Course at Varanasi Institute VedantSri. There is Latest Computer Course Offer in ADCA Computer Course, DCA Computer Course, CCC Computer Course & English Spoken.

(Macros ExcelSearch and PrintData)

About VedantSri Computer Institute Varanasi

VedantSri Computer Institute in Varanasi is the Government recognized and ISO Certified Computer Institute in Varanasi running since 2011. It Provides Computer Courses, Classes, Training by different own branches all over Varanasi. There is Computer Scholarship Courses DCE Scholarship (Diploma in Computer Engineering), DIT most trusted computer course Available under Scholarship Test Scheme.

Varanasi Computer Institute vedantsri works at different places to ensure students to get better computer education. VedantSri Computer Classes has Diploma courses and advance diploma courses on the computerVedantSri Institute provides the latest version of computer application training in computer courses.

वेदांतश्री कम्प्यूटर इंस्टिट्यूट’ वाराणसी में पिछले 10 वर्षो से बेहतर व न्यूनतम शुल्क में कम्प्यूटर शिक्षा प्रदान करने वाली एक कम्प्यूटर ट्रेनिंग इंस्टिट्यूट है | यह संस्था कम्प्यूटर व इंग्लिश स्पीकिंग कोर्स की ट्रेनिंग प्रदान करती है | वाराणसी में कम्प्यूटर शिक्षा को बेहतर व न्यूनतम शुल्क में छात्रो तक पहुचाने में वेदांतश्री पिछले 10 वर्षो से प्रयासरत है |

Free To Learn In VedantSri Computer Institute in Varanasi

इस वेबसाइट का यूज़ वेदांतश्री में पढ़ रहे छात्रो को कोर्स से सम्बंधित ऑनलाइन सपोर्ट करने से सम्बंधित है | इस वेबसाइट पर उपलब्ध विडियो, टेस्ट शीट, Questions & Answer सेशन, ट्रिक्स, टिप्स वेदांतश्री में सिख रहे कोर्सेज से सम्बंधित है |

उपलब्ध कंटेंट संस्था में सिख रहे छात्रो के डिमांड पर अपडेट किया जाता है | उपलब्ध कंटेंट वेदांतश्री में पढ़ रहे छात्रो व सम्बंधित छात्रो को निशुल्क प्रदान किया जाता है जिसका कोई अलग से शुल्क नही लिया जाता है | इस वेबसाइट पर उपलब्ध कंटेंट कम्प्यूटर कोर्सेज व इंग्लिश स्पीकिंग कोर्सेज से सम्बंधित अपडेट किया जाता है | 

(Macros ExcelSearch and PrintData)

About CCC Online Test 2022

CCC Online Test 2022:- This is the CCC Online Test Website Page. If You are preparing for CCC Exam or any competitive exam then you should visit this www.vedantsri.net website.

you can also download this app from the play store and you find Just like many more Online Test Series Related For Example MS Word, MS Excel, MS PowerPoint, Internet-related.

This is Provided By VedantSri Computer Institute Varanasi. The VedantSri Provides Best Computer Classes, Courses, Coachings, and Computer Training in Varanasi Uttar Pradesh India.

(Macros ExcelSearch and PrintData)

1-VedantSri Official Website:- https://vedantsri.com

2-Student Support Website:- https://vedantsri.net

(Macros ExcelSearch and PrintData)

6 thoughts on “Macros ExcelSearch and PrintData Project-14

Leave a Reply

error: VedantSri Content is protected !!