Clear a Target File from the Master File and Write Back the New Data to the Cleared Field?

Help Studio
1

Hi team,
Here are the questions that I need help with - I have a process that needs to clear values under certain column from the master sheet (having about 8000 rows)

  1. I want to clear all values under column B2 to L2 (B2:L8001) leaving the names of the columns intact.
  2. On the same sheet I want to clear all values under column Q2:R8001 and leave the column names intact.
  3. On the same sheet again, I want to clear all values under column T2:X8001 and leave the column names intact.

The remainders of the columns (M ~ P, and S) are formula driven and I do not want to touch them -

Then the next step is reading from another file (SAP File) for the range of (B to L) with the header remaining the same to and writing back to the master file read from B2 to L2 (B2:L8001) AND reading M2 to N2 from the same file and writing back to Q2:R8001 AND reading from O2:S2 and writing back to T2:W8001

I am attaching sample file with this text.

Master File.xlsx (2.2 MB)
SAP_Clearing_5.16_6.15.XLSX (10.7 KB)

Thank you,
Sisay

2

@Sisay_Dinku

Better would be to create a blank template with formula in the places you need in only the first row

Then write the data to column where you need to write and then use auto fill range to fill the formulae to all the rows

This way everytime it would be fresh template ready and you can write the data and drag formulae

Cheers

3

Hi @Anil_G

For this step of my process - your option is much faster than the steps I had in place. However, I am still experiencing a long loading issue - I believe it is due to the fact that the file is too big. I’ll get back to you with more info

Thanks,
Sisay

1 Like
4

@Sisay_Dinku

A quick tip use excel process scope and set the properties there like not to open, automation etc

Cheers

5

Thank you @Anil_G - Just to clarify what I did, instead of clearing the previous data in the file, I created a template with a formula worked better (saved one more step). I still see performance issue. Let me close this INC for now since I was able to handle Q1 via 3 in my initial post. Thanks!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.