#macro code

Hello, I have a daily report on Excel which follows production figures and i need to make a macro to save time each day, the workbook represents a whole month and comprises of different worksheets each work sheet represents a day in the month starting from day 1 to day 31 Sheet 1...

Hi guys I want to transpose one column into different 13 columns but I don't know how to write the code. Can you help me? It should be like this: A B ----> A B C D .... C D . . .

Hi, I am using a Macro-recorder to help copy names from our software system to an Excel sheet. The number of rows is often not equal, sometimes 1 name/ 1 row, sometimes 6 names/ 6 rows. I would like to continually keep pasting names under eachother without empty rows, to do this I want to...

I have a VBA code that extracts table data from outlook emails but from a particular subfolder. I want to generalize my code and instead of searching in a particular subfolder under "Inbox", I want the code to filter the emails directly from the "Inbox" folder and then extract the tables from...

I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found...

Hi I am trying to write a macro that would "click" a command button that is in another tab contained within the workbook. Would that be possible? Without changing any of the code within the other tabs? I don't have access to the other macro as it was developed by another software person. I...

Hi I am trying to write a macro that would "click" a command button that is in another tab contained within the workbook. Would that be possible? Without changing any of the code within the other tabs? I don't have access to the other macro as it was developed by another software person. I...