Coping formulas within Excel
Hello, I have the attached Excel spreadsheet. The column formulas are limited to line 74.
When I've tried to copy the formatting and formulas down to row 25,000 for some reason the formulas copy, but they stop working after line 74.
Are you ale to help?
Real-Time-Inventory-in-Excel.xlsx
When I've tried to copy the formatting and formulas down to row 25,000 for some reason the formulas copy, but they stop working after line 74.
Are you ale to help?
Real-Time-Inventory-in-Excel.xlsx
Last Comment
ASKER
Hello, thanks for your reply.
I've opened your file and it is the same as mine in the original post.
I'm not sure you understand my question. After the 74 line, the formulas stop working after you try to copy them down.
I've opened your file and it is the same as mine in the original post.
I'm not sure you understand my question. After the 74 line, the formulas stop working after you try to copy them down.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I've opened your file and it is the same as mine in the original post.It is not the same, it is a table. Add a new line and you will see the whole line is populated
Pleased to help
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Real-Time-Inventory-in-Excel.xlsx