-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
sheetsall
-
S
Nested For Next Loop
I'm trying to use a "nested For Next loop" for the first time. I would appreciate your help for the following problem. Below is my code. I apologize for its length but, I thought it might be needed in its entirety to understand the issue. I'm getting a Compile Error - Next without For...- srdavisgb
- Thread
- essential job nested loop sheetsall
- Replies: 2
- Forum: Excel Questions
-
J
Code to look at open workbooks rather than in a location.
Hello all, I've got some code that opens a number of speadsheetsand copies and pastes the data to a master list. Currently the code needs the files in a specific folder. How do I change it so it doesn't matter where they're stored, but just needs the files to be open? Ceers, Jed Sub...- Jed Shields
- Thread
- data dim lrow partners sheetsall
- Replies: 2
- Forum: Excel Questions
-
T
Macro to filter by date in cell
Hi Everyone, Not sure what ive done wrong please help if you can. I want a macro to filter based on a data in cell M1 But my current code hides all the cells can someone help me or give me a new code that works please? thanks Tony my code Sub Get_Todays_Data() Application.ScreenUpdating...- tonywatsonhelp
- Thread
- code data.select lastrow sheetsall years
- Replies: 1
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
VBA to find values in several columns, based on common value in a different column, then copy paste to different sheet
- Started by mlepesant
- Replies: 26
Hello, New to the forum. Good excel skills but almost no VBA experience. I have a file that provides me with Bill of material for different... -
if cell has a value then copy and paste whats in that cell and to the right of it
- Started by drop05
- Replies: 25
Hello, a bit new to this. 1. Using VBA im trying to see if there is a way to check if a cell has a value, in my case cell G52, if it has a value... -
force drop-down list only when 1 of 6 possible answers in a different cell is met.
- Started by CaptainChaos
- Replies: 23
I have done some reading on dependent drop down lists, but everything I have found refers to when there are for example 2 or more choices in 1... -
Transfer table filtered data to new worksheet in respective column, 2nd tab data transferred under last row in respective columns.
- Started by Dave01
- Replies: 23
[URL unfurl="true"]https://www.dropbox.com/scl/fi/4mp0zl1gu1fiizp6dhse6/test-macro.xlsm?dl=0&rlkey=ejd7qgpi7mcg0cfjb6u6qkcdi[/URL] Hi The link... -
Error with Loop
- Started by Jeeremy7
- Replies: 22
Hello, I have a problem with one of the loop I'm trying to do and I think it's in the formula but could somoene help me ? Also I saw that some... -
VBA date in local format
- Started by opislak
- Replies: 21
Hello all, As a European, my keyboard layout is set by default to show dates with '-' as in 11-06-2021 or jun-21 I would like to modify the '-'...
