Help with Deciding how to go about




 Hello, 
  

  
Im very new to VBA programming 
  
have been having trouble getting a way out as how would i solve this 
  

  
I have different worksheets 
  
1st sheet --Some vendor information Priority(High,Med,Low) incl Start date and end date
  
2nd -Predictive High data on mon by month basis
  
3rd \_predctive Med data on mon by mon basis
  
4th predctive Low data on mon by mon basis
  

  
What i wanted to do is compare the cell value of High, med or low 
  
and then go to appropiate sheet pull out data in accordance with start date and end date
  
which are given in first sheet and then paste out that data on to a different sheet
  

  
Can someone please help me out pointing me in right direction
  
Im just everywhere now
  

  
 

 See more
you need a macro. a small extract of the four sheets may be uploaded to 
  
www.speedyshare.com without password.
You will probably need to write a VBA macro that does this. Formatting is not pushed down from the workbook that the user opened to the workbook that holds the source data. method for handling data structures where the first element is processed first and the newest element is processed last. hi [@jitse\_b](/u/jitse_b)

welcome to the community !

yes you can, there are various ways to do so.

the simplest:

you may want to create a table with 3 columns,

key\_column, type text, value “k000” (or whatever you want, it doesn’t matter if you stick to only one comparison)

“material1”, type ref, source tabl… 1) p(x) = 1/x2 + 1 if x ≤ 3 it is clear that x= 3 is included, so you have to use this function.2) loo k at table d, and compare the given information with the data written inside the table. [@najoua.abbaci](/u/najoua.abbaci)

mabye the flow can be adopted to following:

assign:

leftside: drresult (datatype: datarow)

right side:

dt\_datepv.asenumerable.orderby(function ( r ) datetime.parseexact(r(0).tostring.trim, “dd.mm.yyyy”, system.globalization.cultureinfo.currentuiculture.datetimeformat)).last()

so… [@camgarciarafael](/u/camgarciarafael) you cannot remove the first document in your associated documents list. i guess mn considers it a core document of some sort. basically each study requires you to have one document and mn just picks the first in the list as that one that is required.

you can work around it by reord… Thanks for your reply, I feared it would not be trivail, as I coudnt find any scripts. Idealy the text from the databse is place in a table witht the last column beeing the barcodes path, the images are to replace the text path and be place inside the cell, fitting within the cells width and/or height. worked around it with excel vba as uipath didnt work use sections. the first page should be section 1. you can assign the master page elements to that section only. then all other pages will be in section 2, with a different master page with different elements. each section can pick up page numbering from the last or start at a new number. [@whyyouandi](/u/whyyouandi)

[image] whyyouandi:

i want to append another column of data.

you can add a column with [add data column] activity.

<https://www.uipath.com/activities-guide/add-data-column>

[image] whyyouandi:

and then edit the scrap date per row.

and to add a value to a target column, ch…