forginganewone
Board Regular
- Joined
- Mar 14, 2018
- Messages
- 64
What i want is to be able to use VBA or excel in a new sheet which will take following criterias : sheet name from H2 column( sheet 1), site from A2 column (99), discription from G2 column (cable) and number of rows from F2 column (3).
The trick here is number of rows, as the site id and description will be same for each row in that sheet but other data will be different so i want it to populate 3 rows without repeating any row.
Result : The result going in a new sheet.
Criteria : only two criteria from A2 and G2. H2 is sheet name from which data will be searched and F2 is number of rows which should be picked.
Searching : I will be searching in a sheet with multiple columns.
The column of A2 and G2 will be same in that sheet but other coulmns data will be different, so i want a script of formula to search and pick number of rows(F2) on criteria A2 and G2 but do not duplicate the rows.For example value in F2 is 3, the script/forumla will pick 3 unique rows from sheet(H2) on criteria A2 and G2
Please find sample data here : https://expirebox.com/download/edf2c...b03667b11.html
Breakup sheet : from where formula will take criteria from
Cables sheet : from where it will search data
Results sheet : Where output should be given
Please note that i want the script to populate all the results of data in breakup sheet.
The trick here is number of rows, as the site id and description will be same for each row in that sheet but other data will be different so i want it to populate 3 rows without repeating any row.
Result : The result going in a new sheet.
Criteria : only two criteria from A2 and G2. H2 is sheet name from which data will be searched and F2 is number of rows which should be picked.
Searching : I will be searching in a sheet with multiple columns.
The column of A2 and G2 will be same in that sheet but other coulmns data will be different, so i want a script of formula to search and pick number of rows(F2) on criteria A2 and G2 but do not duplicate the rows.For example value in F2 is 3, the script/forumla will pick 3 unique rows from sheet(H2) on criteria A2 and G2
Please find sample data here : https://expirebox.com/download/edf2c...b03667b11.html
Breakup sheet : from where formula will take criteria from
Cables sheet : from where it will search data
Results sheet : Where output should be given
Please note that i want the script to populate all the results of data in breakup sheet.
Last edited: