need help vba

I created a workbook with multiple time cards (1 for each employee on different sheets). I need a vba code to copy and paste from each sheet into a compiled master sheet ("Data") The first line of data in each timecard sheet is in B8:H8. Some timecards could have a variable amount of lines from...

Hello Everyone, Need your help to close an open pdf file using excel VBA. Appreciate your help on this. Best Regards,

Hello everyone, I have come across the following vba code which exports a specific sheet in pdf format and email it as an attachment. I want to export the same sheet in excel format as well and attach to the same email along with the pdf file. Kindly help me on this. Sub...

Hello Everyone, I am looking for a solution to export my pivot table as pdf format which is located on sheet1 & export the source data of the pivot table which is located on Sheet2 as a new excel sheet and email both the file with the help of VBA code. I am using outlook Office 365. Hope I...

Hello Everyone, Need your help to copy data from one sheet to another based on cell value. For example, I have the following source data set and I am looking for a VBA solution which would copy the row value to a separate sheet as mentioned under the Target Sheet Name example. i= Source...

Hi All, I'm hoping for some help please? Ive been trying to create a button in excel that saves the file for the current workbook with the name as cell value and a path (Sharepoint). below is what i have so far, but doesn't work. HELP PLEASE Private Sub CommandButton1_Click() Dim path As...

Hello Everyone, Need help to save excel sheet data in xml format. For example, i need to save the data from Sheet1 of my workbook in xml format seperate file. From the following range, i can only copy "Column A" data but i need to expand the range of the column. Range("A1:A" &...

Hello members, As a lot of new members such as myself, I am quite green in my macros abilities. To cut to the chase... I have linked some live updates from the web in my excel spreadsheet. However, I would like to archive the data every 15 minutes and list it in each subsequent column. The...

Hello everyone, I am working on a VBA code which changes positive figures to negative figures and vice versa. The code works fine if i select more than 1 cells but if i select only one cell to change the figure from positive to negative or negative to positive then all other numbers get changed...

Hi! I have this extremely big list of material that contains 10000-30000 positions -(COLUMN A) next to it is quantity in pieces (COLUMN B) values vary between 0 and hundred of thousands (these are also MAX VALUES). I need to automatically distribute each position of MATERIAL QUANTITIES over...