newsheet

Hello! I have one excel sheet with one combined data and aditional information and sheets who are added frequently. I need to add column in combined sheet where data is recovering as new sheet added. I'm the beginer in excel for now I needed only standart solution. But here is new job and new...

Hi, I have a macro that copies data into a separate sheet (after converting a matrix to string for three columns - date, time and value). It works fine apart from the fact it takes too long (approximately 5 minutes) to copy across. Although there is a large amount of data is there a way of...

Hi, I'm struggling to work this out despite me thinking it really cannot be hard (still very much a newbie). I want to select a cell in an existing worksheet then run a macro that inserts a new sheet (at the end) and names it the contents of the active cell. An added bonus would be to Paste...

have sheet that contains data that constantly updates. need to do the following; when sheet opens, create new sheet with Date as sheet name, then copy values only from original sheet in A1 copied to newsheet A2. then if A1>A2 copy value only of A1 to newsheet A3, if A1<A2, copy values only...

excel 2016 I have 40+ columns of data in 100s of rows. At a specified time each day I need to copy each row sequentially to a single row in a new worksheet. As an example: DataSheet is the sheet from which data should be copied. NewSheet is the receiving sheet. Process would be as follows...