clone

Hello, please forgive my ignorance with this one. I have a situation where I have multiple tables (lets say Table 1 and Table 2 for this scenario) where I need table 2 to act like a clone of table 1. To go deeper, Table 2 must match down to the color and text as in Table 1. All I know is that I...

Hello everyone. I have some custom defined VBA classes and no idea why they keep causing Excel to crash. My classes define objects. I use instances of those objects in dynamic arrays. I can't use collections because I need to edit the objects in the arrays and swap out the entries in the...

Can someone help me with this one please :confused: I have a spreadsheet with 2 tabs (worksheets) Tab 1 and Tab 2 I would like which ever cell I have selected in Tab 1 to be the same in Tab 2. So as I move around to different cells in Tab 1 the same thing happens in Tab 2 Is this possible? Many...

Hi All, Is there a way to clone your document, where if the user is working with your file and they accidently delete it that it can be restored in using its clone? Thank you, Pinaceous

Hi, I have several sheets in Workbook ("Avalia"), like sheets("CP1"), sheets("CP2"), sheets("CP3"),.... sheets("STC1"), sheets("STC2"), sheets("STC3"),... sheets("CLC1"), sheets("CLC2"),... all with data. I have also a form_Export with commandbuttons one for each sheet in Workbook ("Avalia")...

Hi, I have a problem that is really bugging me. It sounds really simple but I can't get it how I want it: I have a project with 2 sheets: "sheet1" and "sheet2" If I change anything in a specific cell, lets say cell A1 in "sheet1", I want a specific cell in "sheet2", lets say B4, to be an...

My co-worker experienced this issue a few weeks ago and now I have experienced the issue in one of my spreadsheets. Background: - My excel file has numerous worksheet tabs containing weekly data. There are formulas and values in each of the tabs. - I have one tab that contains summary data and...