workbook copy range

Hello All! I need some help with creating a workbook based on unique values in Column C. For every unique value in Column C, I would want a new workbook created and saved as with that unique value's name. Thank you so much for your help in advance!:) Example of what the workbook looks like...

I always get either automation error or run-time error. I will appreciate anyone's help. I can't figure out how to solve the line, wb.Worksheets("Sheet1").Range("A" & i).Value = wb2.Worksheets("tc1").Range("A" & i).Value The whole code can be seen below: Option Explicit Public Sub...

Hi All, I want to copy cells A1:A5 from "book1" into "book2", but if "book2" isn't open, i want the macro to open it, copy the cells into it, then save "book2". I have the below, but it doesn't work because I don't think i'm referencing the workbooks correctly? Both are saved on my desktop...

hi i have a workbook with several lines on each page a need to add up some maybe zero some maybe negative or positve numbers for example if we are 6 hours ahead i need to show we are that thought the easiest way would be +6 same if we are behind 6 hours -6 on time 0 thought this would be...

Hello everyone, Let me just start out by saying that I love these forums and they have proved to be very useful over my college/intern career in the Finance world, so thank you guys for helping me out. This is my first post, I have decided that I will start giving back to those that need help...

Hello to one in this wonderful forum! I need some help on a Macro. I have a folder with many Excel WorkBooks in it. All the WBs are encrypted by the same password. The data in these WBs are in Sheet1, in the Column C5:C10. The Macro should open each WB in the Folder and copy the data from...

A brief overview of the problem at hand: There are two workbooks 'ACP.xlsm' and 'Reference.xlsm'. The code must compare a value (from 3rd row) in column A of ACP.xlsm workbook to a value (rows from A2 of) in column A of Reference.xlsm work book or column B, C in that order. If a match is found...

I can copy ranges from one workbook to another by going back and forth between them. However, I'm getting the syntax wrong when I would like to cut down on the number of lines. See below: THIS WORKS: Dim wrk As Workbook Dim ws As Worksheet Set wrk = ActiveWorkbook Worksheets("ALL Spec...