expand data

Hi! I would like to request the help of VBA experts on a tedious & time consuming problem I have facing. Currently I have a daily data summary in a compressed / summarized format that I need to expand vertically which later will be incorporated in a database of future analysis and forecasting...

What is the best way to expand data found in a cell by creating new rows? In my example I have a row of data that contains 3 values (row Kind) In Sheet2 the data is expanded into 3 different rows keeping all the other values Sheet1 Color Date1 Date2 Date3 Kind Owner Red 8/10/2022 15:35...

Hello everyone. I have an Excel-sheet with a table, in which, I weekly insert new data and thereby expand the table. A minor issue has annoyed me however; I have some prewritten formulas in many of the columns in the table and once I insert new data in empty columns within the table...

Hello everyone, I'm going to complete my simple application relating to creating new workbook, copying data sets from the workbook where I run my macro, pasting the set to the new one with possibility to point out a path. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As...

Hello everyone! I'm creating a report using a pivot table that when users double click their name and dollar value, a separate sheet will be created with data only pertaining to their name. This part is done. However, I also want one of the columns, dubbed "Action List", to have a pull-down...

Hi All, I'm not sure this is possible to do but here is definitely the best place to ask. I currently use a bit of vba code to expand two pieces of data for example: Cell 1 value: 1 Cell 2 Value: 4 With the vba code this is expanded into further cells to become: Cell 3 Value: 1 Cell 4...