excel macro

I need to copy column from one file to another file.I tried most of the online available code but it's not working for me.

Hi Friends , I am trying to unprotect and worksheet from another worksheet of same file when user selects a value from dropdown combobox. System gives runtime error 5 "invalid procedure or argument " Part of my code is : Sub ChangeSellDataSource() With...

Hi all, I am new to VBA and I tried to write a macro to append data from Book 1 (active workbook where will have the macro) which is updated daily, to Book 2 ( close Archiving excel) which is only used for queries. Book 1 and Book 2 have the same column headers in row 1, with dates in column A...

The code below runs/loops just fine and pastes the cells(7,9) to the other sheet. It also pops up and stops the msg box on meeting a blank cell. However, other than that first cell there is no other cell on the target sheet that is being populated. I've tried assigning values directly through...

I have code to close the blank workbook that is automatically opened when Excel 2003 is launched. I need help with the procedure to save it ( I think as "Personal.xls" to the xlstart folder ). Any help is greatly appreciated. G. Bueckner

I have a userform in macro which gets the source from another workbook(test.xlsm). So I used this code below to open that workbook without showing it. picture : https://ibb.co/krd66R <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight...

I have a macros that auto inserts rows based on values. I have 30+ Sheets on one spreadsheet, and if I use what I have, I can't get the rows to insert where I need them. Sheet 1 is set to insert rows at "3:3", Sheet 2 at "4:4", but if I use the macro for Sheet 1 then Sheet 2 inserts the rows out...

Hello all, I'm new to the forum and to VBA in general, I was hoping to get some assistance as I'm a complete novice. I have a folder on a Network drive that we house multiple .xlsm files in. The files itself are all the same and very basic. B2:B4 have title fields and C2:C19 have data fields...

I have 2 Excel workbooks open that both have macros. When I use the shortcut key to run a macro while in workbook 2, the macro from workbook 1 (the 1st workbook that I opened) runs. Why is this happening and how can I ensure that Excel runs the macro from the workbook that I'm in? Thanks, in...

Need help for the below I am having the data in the excel with the columns as below 1. Event Name 2. Frequency of notification ( Daily or for specific days) 3. Dates from 1 to 31 ( in which date notification required I will fill that cell with "Y") 4. Time to be notified As per this data...

I've been using a VBA macro to copy cells from one sheet to another, but I now to make a slight modification which I'm struggling with. My sheets look as follows: Sheet 1 <tbody> Code Description Unit Price AB Item 1 KG 10 CD Item 2 Litre 20 EF Item 3 KG 30 </tbody>...

Hello I have this macro and it works fine, except... The only issue I am having is my data is not consistent. In column "O" some of the rows have the client name and some don't. I need to update my macro so that when it runs all rows in column "O" are completed with the client name. The value...

I have the following which is referring to a cell within filtered data and applying a vlookup to that cell, this works great. Now the hard part is getting the last two lines to work, which autofill the FILTERED DATA with the same vlookup formula. This is where I'm messing up and need help...

Hello, I'm currently trying to write a macro which will accept user input for a range, where if only a single cell is selected, then the entire corresponding row to that cell is considered as the user input range, but I keep getting a 424 error with the following code: Sub Calculations() Dim...

Hello, I'm new to the forum and need your help. I have a spreadsheet coming where I need to validate the data columns on a monthly basis. Im thinking of maybe write a macro to do such. Column data validation includes checking to see if the date Is within requested range, whether the column date...

Can you please help me with this? I would like to have a vba code that selects all tabs in the workbook, except for example "tab abc" and "tab def" and "tab ghi", then save to one single PDF. Thanks in advance!

If IsNumeric(ThisWorkbook.Sheets("sheet1").Cells(RowCounter, "A")) = True Then Call Method End If InitialRow = InitialRow + 1 Next MsgBox ("The End") End Sub Hi All, Above is the Code if the Column A has a Character go to Next line Works Perfect. BUT it Exits...

Hi, I have a shared excel. Could you please provide me macro to make each worksheet password protected ? Kindly note that I require separate password for each worksheet and many users open that excel at one time. Many Thanks, shaikhstonevilla

I hope explain myself clearly first time. I have inherited a macro over 3000 lines long with 17 sub routines in it. I have a small scale project to understand how it works. At the moment I am working through hitting F8 repeatedly, until I get to a clear loop where I am putting a Stop and then...

Hi, Thank you for reading this thread. I need your help creating a macro. I have two excel spreadsheets. .i.e 1) Pivot table 2) Reports. (Report file is shared). The data in the both spreadsheets is as under. Column A) Client names Column B) Outstanding balance. I want to create a macro...