• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help copying data from a specific range in VBA excel

Venky1234

New Member
Example The requirement is as below to get the alerts data of each date and add a row before each date as Monitoring. please find the attached my excel sheets
01-Feb-2020MonitoringNagiosRemedyMail
01-Feb-2020AlertL2AlertName1AlertDescription1
01-Feb-2020AlertL2AlertName2AlertDescription2
02-Feb-2020MonitoringNagiosRemedyMail
02-Feb-2020AlertL2AlertName5AlertDescription5
02-Feb-2020AlertL2AlertName6AlertDescription6
02-Feb-2020AlertL2AlertName6AlertDescription6

Currently it is adding before all the alerts as below
01-Feb-2020AlertL2AlertName1AlertDescription1
01-Feb-2020MonitoringNagiosRemedyMail
01-Feb-2020AlertL2AlertName2AlertDescription2
01-Feb-2020MonitoringNagiosRemedyMail
02-Feb-2020AlertL2AlertName5AlertDescription5
02-Feb-2020MonitoringNagiosRemedyMail
02-Feb-2020AlertL2AlertName6AlertDescription6

Can any one please help me with the necessary correction
 

Attachments

  • week1.xlsx
    10.7 KB · Views: 3
  • pgt-Master-Data-1 (1).xlsm
    20 KB · Views: 3
Venky1234
Did You notice that Your above writing ... example and Your files should someway match?
Could You one more time try to write - what? where? how do You do it manually?
... situations before and after 'something'.

... continue ...
Venky1234
You replied with some lines,
but where are answers to my four questions?
 
Last edited:
i have a EXCEL work books of 4 weeks
each week work book contains 2 work sheets 1)Alerts 2)tasks
i have to prepare a monthly report from the four weeks . usually i go to each work sheet in week1 and copy the data of ex: 01-feb-2020 , 02-feb-2020 and then i add the following line before each date of the alert as below

01-Feb-2020MonitoringNagiosRemedyMail

hope i am clear
 
Last edited by a moderator:
i want to fetch the data from workbook1 to other sheet in order of date and add a row before each date
 
Last edited by a moderator:
Back
Top