
0
i have created a sheet that will track inventory for a given property. I am having to cut and paste information from an excel spreadsheet (from our supplier). I have some formulas built in to the sheet that will calculate if a given line item is checked off as completed.
If the information pasted into the sheet extends beyond the copied formuals, obviously the formulas dont apply the informaiton below the formulas.
Is there a way to apply the formulas to the entire column, so no matter how rows are copied into the sheet, the formulas will be applied.
I have attached a few screenshots to show how im using the formulas.
Thanks for your help.
SGF



Functionality
Comments
[email protected]…
June 4, 2019 8:41 pm
Andrée Starå
June 5, 2019 1:42 am
[email protected]…
June 5, 2019 4:48 am
In reply to Hi Steve, Unfortunately, it… by Andrée Starå
Andrée Starå
June 5, 2019 4:52 am
In reply to Andre, That's kinda what i… by [email protected]…
Paul Newcome
June 5, 2019 5:52 am
In reply to Happy to help! Pro tip. Add… by Andrée Starå
[email protected]…
June 5, 2019 5:09 am
In reply to Hi Steve, Unfortunately, it… by Andrée Starå
Andrée Starå
June 5, 2019 5:14 am
In reply to Thanks for correcting Andrée… by [email protected]…