-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
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
- 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
- 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
- Replies: 11
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Unprotecting a sheet once a text box is selected
- Started by dpaton05
- Replies: 49
Can you unprotect a sheet once a text box is selected and then reprotect it again when it is unselected? I do not want to use active x text... -
OFFSET function with multiple table
- Started by xdenama
- Replies: 43
I have 100++ sheet (table) with same format with difference high (total row not fix, will change). How to combine all table (sheet) in one sheet... -
Question about Data Validation.
- Started by omairhe
- Replies: 24
Hello all, I find data validation to be a useful tool in excel 2019. In cell A2 if the value = A then allow both positive and negative integers... -
VLookup Or Other To Match Data.
- Started by fintail99
- Replies: 23
Hi there, I have data, as follows: Sheet1 A1: Name B1: 0.5 (this relates to total time, see Sheet2 below) C1: £25.00 (this relates to the total... -
Split a year range into one row per year
- Started by rameez788
- Replies: 21
Hi all, I am new on this forum. I have attached sample data, i need someone to help me convert the left side to how the data looks on the right... -
Combine 2 var into 1 string with & in between
- Started by bumbum2812
- Replies: 21
Hi Experts Please help me combine 2 var into 1 string with & in between. My data is from A1:A2 & i have below code to put in MsgBox...