Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 16 March 2022
  0 Replies
  2.9K Visits
1
Votes
Undo
Hi,


I am looking VBA code for below activity, anyone can help me to share the VBA code for below activity.

Conditions:


I have 3 Excel file in 3 different locations in my PC. (1st excel file sheet name is "Dashboard", 2nd excel file sheet name is "Raw data" & 3rd excel file sheet name is "Template")
All different location saved excel file will not keep open during this VBA running, only “Dashboard” sheet will be kept open, VBA code should take care this condition.


Activity to perform through VBA:


I have 3 search option in 1st Excel sheet "Dash board" (location A1, B1 & C1)
But I will search any one (A1 or B1 or C1) based on the available information with us.

It has to search the number in 2nd excel sheet "Raw data" (if A1 value entered it should search A column, if B1 value entered it should search B column, if C1 value enter it should search C Column in "Raw data" sheet).

If data found it should copy all multiple rows data's (from E to G) & paste in "Template" file location E10 to G10. if data not found show display "the search content not available in Raw data". (Note: A1, B1 & C1 values are interlinked, so if I search A1 or B1 corresponding C1 data only should past to “Template file”) Leave first row in “Raw data” since it’s heading.

"Template" file is the standard format we can paste only 20 rows data in E10 : E29 & G10 : G 29, if search result data rows is beyond 20 rows it should start pasting 21st row data in next sheet of Template plate. (Kindly note Template contains top & bottom standard content test, so if row increase to 21 then below E29: G29 should completely shift all contents to next page) with auto cell alignment.

After data copied to “Template” it should convert the “Template page” to PDF file & save the file in different location of PC (File name must be C1 location of dashboard with current date & time).

Once PDF converted open the saved folder location in PC as well as PDF file.

For next search existing “Template” pasted data must be cleared for new data entry.
There are no replies made for this post yet.