How to select columns from a-f in the excel do the formula ->name manger
- I’ve to select the A-F column regarding the range in the column A
- select A-F and go to formulas in excel and click on the name manager
Can someone suggest how can this be done
How to select columns from a-f in the excel do the formula ->name manger
Can someone suggest how can this be done
Can you share some screenshot for better understanding?
Also add some more info to your issue
Thanks,
Srini
Thankyou for the reply
My query is
I’ve an excel file where
and then do the formula
Why don’t you use ReadRange activity and store that into an datatable variable
Now use Filter Datatable activity to specify you condition
Then you can write your results to another excel sheet using write range activity
Hope this may help you
Thanks,
Srini
i shouldn’t write it into the different excel ,i need to do this activity while excel is open perform the if condition regarding age and if the got selected then need seleall the columns data that comes under age , click on formula tab and do the name manager
i tried this , it did filter out the age but didn’t select the data like
@sreelakshmivella2012
In Output Columns you have to give the required columns to output excel
I hope it helps!!