excel 10 vba code

Hello Everyone, I recently started working in a workbook that I had made quite a few months ago. I had made my macros private because I didn't want users to be able to run them in any way except for through buttons that I had inserted. Now, I want to get back into my macros and work on the...

All of the following are separate columns. Every code is separated within parentheses and by spaces. I need all codes underneath the ID#'s in ONE column. I have bolded the ID's, so that it's easier to distinguish them...

Hi Guys, Very new to macros. The issue i am facing is that, i have developed a report for around 50 products. the products are in a drop down list. when a product is selected from the list, the report is refreshed with the details about that product. What i am wanting to do is that, I want to...

I am trying to get some help with a excel macro for exporting data from a closed file and importing into a summery file. I envision the summary file looking something like the below Structure with Folder and File Name listed and then cell reference names (from the "Name Manager") in the column...

I know you can pretty easily export/import SharePoint 2010 list data to/from Excel using "Export to Excel" ribbon interface. If there's a need to do it for a large number of files, I need to automate this process using vba code in Excel 2010. I have seen this work according to the link...