sheet change

Hello, For a project I actually use a macro to export data from one unopen workbook sheet to the actual xlsm workbook sheet. I recently found a problem on the export sheet, this sheet has to be updated every single week but probel the change the name of the sheet changes every week. But on my...

I have inherited a process which has a template workbook with Macro buttons so users can move to specific sheets. The template has been used to create approx 700 files. I have been making some amendments to the template, which has included changing one of the worksheet names - this means one...

Hi all, I'm trying to set up "protection" on my sheets, and so far sheet.protect doesn't do the job, because I have tables and I don't want my users to be able to add columns to the tables but AllowInsertingColumns = False still allows table columns to be added. So I think I have a solution...

Hi, how do I write macro code to use information on current sheet, to enter information in specific cell in another sheet. click button on sheet 1 use information in [sheet 1 A8] ("DAVE") to find row in [sheet 2]("row 3") use information in [sheet 1 B8] ("MONDAY") to find column in [sheet...

I am new to VBA and need some help getting started so bear with me here. I have names and information in sheet2 and a user interface in sheet1. I am trying to edit names and their corresponding information in sheet1 by picking the name to edit through a userform listbox and having their...

folks, trouble with inherited workbooks is that while the original macro author is around, things tend to have to be run their way. the workbook i am currently adding to is a consolidation of different financial systems. it ultimately creates the "one source of truth". The analyst that created...

Hello, I have a problem that I though I overcame but seems it is not the case. The original problem originated there: http://www.mrexcel.com/forum/excel-questions/681429-how-get-worksheet_selection-change-work.html Thanks to the above thread I adjusted my macro: Private Sub...

hello, I need a help with the following task: when a cell from H column is changed then I need a formula in I cell column to be written. Obviously I do not want to use Excel formulas like: =if(H1="","",weeknum(H1)) or any other variation of any formula as the file needs to be used by various...

I need to do data manipulation based on a particular cell being changed, I can try to work it on sheet change , but cell change would be a lot easier, if it is possible , please advise correct syntax also best location to put the code

I am unable to shift to a lower sheet number when i am on sheet 4