Protecting Special column when importing

flevasseur71406 · 12/06/18

Hi, I've got a sheet in which I import from an Excel spreadsheet data on a daily base. In that sheet I have a column (RYG balls) with a formula to calculate overdue estimates. But every time that I import the new data, that column is crushed. I even added it at the far end beyond the imported data parameter. Is there a way to protect that column from being crushed?

Thanks

Andrée Starå · 12/06/18

Hi,

How do you import the information?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday · 12/06/18

Have you tried just copying and pasting the data - minus the columns that have formulas?

Andrée Starå · 12/06/18

Another way could be to import and then move the rows to the main sheet.

Would that work?

Best,

Andrée

Jason · 12/06/18

Can you elaborate on what you mean by "column is crushed" ?

Protecting Special column when importing

Comments

Categories