Any ideas as to why it doesn't update automatically, what can be done to make it update automatically, or perhaps a hot key command to make the formulas update?
I currently have a workbook that has about 100 sheets.
The production sheet I'm using is complex enough I don't want to try and test the . forces a full calculation of all data, not only in a single Worksheet or Workbook, but in all open workbooks!
This could be major overkill, especially since the user could have several unrelated, potentially complicated, workbooks open.
Text) If Len(s Name) The macro essentially grabs each cell in your selection, creates a new worksheet, and then renames that worksheet according to whatever was in the cell.
Then drag the higlighted cells down to copy the formula to all the desired cells.
Then do the same on sheet 3 but starting at the point you want to split sheet 1.
I have a excel workbook with 3 sheets, sheet1 contains all the data which is split into remanning 2 sheets.
sheet1 data is updated on daily bases therefore i need to split sheet1 and update the reming two sheets, so at the moment i copy a each row from sheet1 and replace corresponding row in sheet2 or sheet3 with new data , each sheet contains the same columns: customer_id, customer_name, customer_surname, customer_deposit, total_deposits.