[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More
Experts Exchange Solution brought to you by
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.
this small part of my process I want to create 53 Sheet like "LT"
every day one line added to every 53 sheet (row 34 to row 500)
it performed task of calculation 1 row at time so I need new way like after pressing button it just update data in respective sheet & for calculation there is new button. which process - copy data from data sheet & past to rebuild sheet - done calculation & copy data of calculation & then past to their respective sheet.& delete from whole data from sheet rebuild. Then go for next sheet data.
Here also you may have sheets that does not exist can I assume that they will be similar to the 2 ones you created
like the first couple of rows has like a table but I see no formulas there is this normal and should be like this ??
Pls see attached file and activate button Update in sheet Data and see if this is what you want.
After each & every time data is updated all sheets should be in A to Z sorting. And only to those sheets which is not hidden & which is after "data" sheet.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.