copying between documents

I've built a dashboard on an excel sheet, cell Z11 is a drop down validated list which contains the 5 different splits of my data, and changes the appearance of the dash when changed. My overall aim is to convert the 5 different views into a single PDF with 5 pages. I don't / can't have adobe...

Hi all, I have been reading many of the posts on this board that have helped me immensely in learning VBA, however the macro that I’m working to create now hasn’t had a discussion that I’ve been able to find. I have about 15 files with different financial data in a folder; each file has...

Hello, I can't seem to get my module 8 to paste the values of Sheet1 (workbook where the VBA code is) onto another workbook's cells, I will briefly explain my code: I have three workbooks, one workbook (with Sheet1 being the "Operator" sheet) where the VBA code is written in, and another two...

Hey everyone, this is my first post here since I'm new to VBA. I'm not good at coding but I will provide you with all the information I have right now. Summary: My goal --> Macro Step 2: Trying to create a macro to consolidate data from multiple workbooks / Suppliers into one Master-File...

Hi All I have a piece of code which simply copies data from all cells in one workbook and pastes it into a table in another. However I am finding that one column (Column N) which is in a "MMM-YY" format keeps changing the Year part from 17 to 18 when it paste values over. On the raw file all of...

Hello, I posted a thread earlier on this particular project I'm working on. Most issues have been solved and the program is sort of working. It's not encountering errors that stop the macro like before. The macro runs but i think the issue now is with the If-Then-ElseIf-Then-Else statement (see...

Hello Excel people, I have made following code the code is very simple, the script copying certain columns from one place to another file. I open the SourceFile.xls and import my.bas file to. when you run the script you get a windowdialog you can selecta folder the script open the file...