Hi,
Currently I have a project that needs to read and transfer specified criteria met from the text file as my source. Then after filtering, I need to tranfer it to excel template. I already made to transfer my data to excel but with specific cell where the data must be place. Let say data ABC will be imported to excel in cell A1, DEF in cell B1 and so on.....
My problem with my other project is I need to list all the specified criteria met and the cell will automatically adjust upon the availability of the data. Let say....
Data A is in cell A1, B in cell B1, C in cell C1
Data D is in cell A2, E in cell B2, F in cell C2
Data G is in cell A3, H in cell B3, I in cell C3
but if data D,E, and F is not available, data G, H and I will automatically move in cell A2,B2,C2.
Need ur expertise. Thanks in advance.
Currently I have a project that needs to read and transfer specified criteria met from the text file as my source. Then after filtering, I need to tranfer it to excel template. I already made to transfer my data to excel but with specific cell where the data must be place. Let say data ABC will be imported to excel in cell A1, DEF in cell B1 and so on.....
My problem with my other project is I need to list all the specified criteria met and the cell will automatically adjust upon the availability of the data. Let say....
Data A is in cell A1, B in cell B1, C in cell C1
Data D is in cell A2, E in cell B2, F in cell C2
Data G is in cell A3, H in cell B3, I in cell C3
but if data D,E, and F is not available, data G, H and I will automatically move in cell A2,B2,C2.
Need ur expertise. Thanks in advance.