RyanChampniss
New Member
- Joined
- Apr 8, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
Hi,
I have a fairly complicated Excel file using lots of Index and Match formula to grab data from another file and format it to how I need it. There are 63 cells per row, with 41 containing formulas (22 without formulas). I need to copy all formulas and data from all 63 cells, except column A which contains my lookup value. A few of the cells have array formulas in as well.
I can use VBA to copy all the formulas down, then embed all the formulas, but when I run it, it locks up. There are 1000 rows in total. This is why I want to do it row by row, to hopefully speed it up.
Any idea how I can set specific columns to copy the formula down to the row below, then embed the data, then move on to the next row, until every row with data in column A has been processed? I'd also like the VBA script to be a button to update values should anything change on the source doc. A progress bar would also be amazing so I know it hasn't just frozen up!
Please help
I have a fairly complicated Excel file using lots of Index and Match formula to grab data from another file and format it to how I need it. There are 63 cells per row, with 41 containing formulas (22 without formulas). I need to copy all formulas and data from all 63 cells, except column A which contains my lookup value. A few of the cells have array formulas in as well.
I can use VBA to copy all the formulas down, then embed all the formulas, but when I run it, it locks up. There are 1000 rows in total. This is why I want to do it row by row, to hopefully speed it up.
Any idea how I can set specific columns to copy the formula down to the row below, then embed the data, then move on to the next row, until every row with data in column A has been processed? I'd also like the VBA script to be a button to update values should anything change on the source doc. A progress bar would also be amazing so I know it hasn't just frozen up!
Please help