-
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.
macros.. formatting
-
W
copying an entire row to another sheet based on a date range criteria.
Hello all, I am creating a master tracker for my finance company and I am having a bit of trouble. I have a "master list" that i am imputing all my information into. From that master list, I have a couple other sheets that are extracting data from it to create new spread sheets depending on the...- workallday
- Thread
- criteria formulas macros macros.. formatting
- Replies: 1
- Forum: Excel Questions
-
G
Preparing Roster for my Teams
Dear Friends, I've just a Tast of Excel and not much of an Advance user. I've a Problem I wanna ask you guys. Theres this weekly Roster which is shared to our team by the Roster making team. The Roster follows certain pattern that is there are like for example 5 Teams working in a Unit...- goodman94
- Thread
- macros macros.. formatting roster
- Replies: 0
- Forum: Excel Questions
-
R
Formatting Sheet Using Macros
On a Weekly basis, and for some reports on a daily basis, I pull data from crystal reports in Excel format. Everyday I have to format the data to look just like the previous report. This take much of my time. I am not great at macros and have made a code to format my sheet but since the numbers...- redmanx03
- Thread
- macros.. formatting
- Replies: 11
- 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: 27
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 '-'...
