Search results for query: copy to another workbook based on cell value

Hello! I'm trying to figure out where I'm going wrong with my code. Basically I want my code to decide what protections to initiate and how to proceed based on the data in column C on the 'LOA' tab. My table starts at A8 (headers) and is dynamic. My code should be allowing user entry from C9 to...

I'm so close. I'm trying to hide and/or PW protect the ClientReport_XLS! in the source workbook. The source workbook filename is dynamic, so I'm not sure how to go back to it at the end of the process. My attempt below tries to hide the ClientReport_XLS! in the new workbook. Besides that issue...

Hello all! I'm relatively new to writing macros, mostly just recording or taking things from searches and modifying to (try to) fit my needs. I'm using the code I found here at the link below, and have modified it and it almost does what I want...

I have the following vba code, it is not working. though it converts the excel to text but not the way i need. Essentially i am trying First Copy the selected sheet from the workbook and create a new sheet with the selected as workbook copy and value paste all the cells starting from cell A1...

To create a macro in Excel to list all data above the average rate by 40%, you can use VBA (Visual Basic for Applications). Follow these steps:press Alt + F11 to open the Visual Basic for Applications (VBA) editor.Insert a new module by right-clicking on any item in the Project Explorer...

Open your Excel workbook and press Alt+F11 to access the Visual Basic Editor. Inside the editor, click on "Insert" and choose "Module" to create a new module. Copy and paste the following code into the module window: vbaCopy code >>> use code - tags <<< Function FormatGanttCell(startDate As...

Hello I have 4 worksheets in one workbook with title timetable, MON, TUE, WED I have one dropdown list in h4 cell of timetable worksheet with values MON, TUE and WED. timetable sheet contains empty table with same format as MON, TUE and WED sheet. I want to copy table values from B8:T15 and...

Hi, I have a macro workbook. There are normal modules written in this book and some are written for cell change event. Cell change event codes are written in the particular worksheet and these are running fine. Issue is, I need to create multiple copies of this worksheet as per the user...

Hi @bijicha try this code, new files are created in the same folder as the Excel workbook Sub test20230402() 'https://chandoo.org/forum/threads/macro-to-create-multiple-xlsx-file-based-on-a-column-value.52165/ Dim rng As Range, cell As Range, joinedCells As Range Dim i...

Hello, Please help to copy data from my Sheet (Sheet Name: WrkingSheet) and Paste to TablebyMonth in another sheet (Sheet Name: Diff) (Book12.zip attached here). Month name will provide in Inputbox, and acording to month provided, data of that particular month will go in the Table of that...

Respected Sirs, There are two worksheets in the attached workbook, one is "Entry" and the other is "Final". There is input data in worksheet "Entry" from range C86 to D161 and this range can vary based on selection in the other data fields marked in grey and has not been shown. There are two...

Kevin S Few questions: # Find each instance of text within a row range > Do You mean 2nd rows values? ... only from one row, now based row two? # Once I find a cell with text, I want to copy the cell and a 5x5 block of information, which is two rows below that cell, to another workbook > Your...

I'd like to create a macro that (on a button click or other event) will copy the formulaic contents of a cell(s) down a column (or across a row) until a condition is met (generally based on the contents of a neighboring cell). The attached workbook illustrates what I am seeking.

Hi All, can help me with a macro to duplicate rows based on specific cell value in column A? For example, i have data in 10 rows, then I need the line to be duplicated so it appears 7 times. per number so total row will be 70. Enclosed file for reference worked code pasted below >>> You...

I have read in your posts about self documenting approach when it comes to writing functions and I don't really disagree with the approach in full. In fact, I had employed the simplest of table and self documenting formula approach for simple interest calculation as a test but the response left...

Simpler, or just more familiar? If you look at the SUMPRODUCT solution, the question is why SUMPRODUCT and not SUM? Where is the function performing a product? Both formulations create a 2D mask from two 1D Boolean arrays. The mechanism for removing unwanted values is slightly different...

Hey Guys, I want to open excel file from Cell B2 then copy Column C from that document and return back to current worksheet & open workbook referenced in cell D2 & paste that column W, this process will continue till the end. It will be well & good this loop takes consideration if Condition...

Hello experts: I am working with 2 excel files/workbooks (using Excel 2007), both files are open. Workbook A, where I run/click the macro button. Opens a text file into excel and copy data then close excel/text file. Now it process this data in excel sheet. It works fine. 1. One of the Sheet...

Hi, Thanks for checking it for helping me.. Ignore my first post..here i have explained clearly I have macro in the attached workbook , it will copy data based on the unique records in column 6 and paste it to the near by sheets, How to modify the code according to the below...

Hi All, I want to make a macro which will paste data from specific column and then using Data validation will filter the data, post which email will be sent to specific employee for pending work. Sheet "RAW" have all data avaialble, however I do not need all the data. I only need Columns...

I don't know VBA and asking for help on learning VBA to write a formula in column C if the cell in column A is not empty. I have attached a workbook with the formula and the way I am using now is to put the formula in more cells than the user will use. The user may add comments to explain what...

Hello, I am trying to put together a VBA code to search all of the workbooks in a specific folder (combine) based on user text criteria from an input box (Net Income). When the code finds it, I would like to copy the whole row into a new sheet. My current issue is that I cannot figure out how...

Use ISREF worksheet function like in this sample : https://chandoo.org/forum/threads/renaming-tab-names-for-multiple-workseets-based-on-a-cell-reference.29802/post-178108 Another one ...

Dear Team, Please refer the attached origin & destination files for further clarity. There are multiple data ranges, which include testing results. When click particular "Add a Sample" button set of Rows to be insert add additional sample test results: For fabric count test; Row 111:112 to be...

As your code has nothing to do with the advanced filter method how can we guess you know it ?! Among many samples from this forum : Filtering out required data Loop on All files of folder ,But Process Only specifically Listed (Partial Named)Files VBA to copy row automatically to another sheet...