Hi there,
I am reading a range and writing it to another sheet. However I wan the colour in the cells to be written as well. How do i do it?
1 Like
While reading the data in the read range enable the Preserve format and then try again
Regards
Sudharsan
Hi @Sudharsan_Ka that will help to write the same colour as well
Hopefully yes that also will considered as format right , lets try once @Mark_Rajkumar
Hi @Mark_Rajkumar ,
Maybe a Copy Range operation is what you require.
Additionally Duplicating Sheet and renaming it could be a Option as well.
Let us know if you are facing issues in using this.
Hi @supermanPunch i am not sure whether this is possible as i am trying read range and use for each row to filter and write the range. Let me try if that works as well.
A More detailed Explanation of what you want to perform, maybe providing us with screenshots/files of Sample Input data and it’s Expected Output would help us analyse the situation faster and provide better suggestions.
@Sudharsan_Ka unable to get the cell colour
As mentioned we would need to understand the requirement, so the Screenshots/Files were asked of the Data (Samples) and not the workflows.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.