center

Hi, I'm relatively new to VBA. I have the below code to insert a new sheet and some other formatting that I need. What I am trying to do is merge and center cells A1:C1 after inserting the new sheet. And then insert a phrase in the merged cells. Sub GenerateConf() Dim ws As Worksheet Dim...

Dears, kindly I want to fill Column sub Category 1 & 2 from another sheet with the Following Condition Sub Category 1 will be : if (Activity coloumn = 211 or 212) : COGS if (Activity coloumn= 111 or 231) : G&A if (Activity coloumn= 111 or 231 & Cost center = 312 & 341 ) : S&M i think i need...

Hi simple ? need to center first row from A1 to G1 .Columns("A1:G1").HorizontalAlignment = xlCenter don't work .Columns("A:G").HorizontalAlignment = xlCenter works but centers everything from A to G Thanks

Trying to get a formula to calculate chord when angle and radius are known and would like to be able to calculate distance from chord to center of radius as well. Please......

Hello everyone! I have a list of clients who visit different locations on different days. I need to count the number of unique clients that are visiting each center on the various days. The client data is sensitive so I am unable to share the details however below is how the data is put...

Hi All, I'm hoping for some ideas on a problem that has puzzled me for years. I have a number of cost centers that need to have sales summarized by different time frames (lease years). For example, cost center 00010 may have a lease year of February - January; the sales for each month are...

I have many rows of data that I need to break-up by customer and move to another worksheet so that each customer has their own sheet. I've figured out how to create the new sheets and move the data, but I'm lost as to how to copy rows of data for just one customer at a time. Here's an example...

Hello everyone. I would like to Merge & Center cell B7 with cells B6 + B5 + B4, but i don't want that the copied data from the upper table to the lower table will be damaged. What should I change at the formula? Thanks a lot...

Sorry I am not sure if I describe my question accurate enough in the title, but what I want is like below: For example: I have below table <tbody> Team NW F7.1 F5.2 F8.1 F3.2.2 Team Head F5.2 F5.2.3 Team Center F8.1 F5.2 F5.2.3 </tbody> 2. I like to have table like this: <tbody>...

Hi So I currently have two sets of data, per below (unique ID and cost center). Where I need to get to is to have a separate row of data for each unique ID and cost center (e.g. 4 unique ID's x 4 cost centers = 16 rows of data). I feel like I'm missing something really simple here - and I...

I'm trying to build a filter in Power Query to filter rows based on the values in 2 columns (Revenue Center and Expense Center). I need to filter the table as follows: Include rows where: [Revenue Center] <> Revenue Center A and [Expense Center] <> Expense Center A...

is there a way I can freeze a cell and row that's in the middle of my page. if i have box that is e2-36 to f2-f6 is there a way I can freeze that area? so when i scroll down that area i want to freeze stays in the center <tbody> a b c d e f g h 1 2 freeze freeze 3 freeze...

I have a number of cells that I want to concatenate into one cell (merge multiple records into one record). However, I would like to exclude cells that start with the words State or Service Center since these have to be placed into a separate field in the record. Column A has all the member...

I have a a small spreadsheet that I copy into an email and send out. I use a macro to accomplish this, however some of the cells unformat when it's pasted into the email, so it makes it look funky. Within this spreadsheet I email, I have a range of cells that are aligned "Center Across...

hi guys I am struggling to get the data from one source WB to another destination new WB based on selection criteria with VBA. the source WB is as follows col1 col2 col3 col4 desc center receipt payment AA 12 1 3 BB...

I want to create an excel test for persons wanting to apply for an excel position. I want the test question to require the person to perform some given task in an actual excel spreadsheet (the programming will open excel with the sheet in question available) What I want to know is... 1. Can...

Hello, I am trying to create an odometer chart which I've successfully done using one of several online posts on this topic (combining a doughnut and pie chart). However, I'd like two have two 'needles' on my chart. I've added a second pie graph to do this but the problem is, my needles won't...

Hi I am trying to have a command button open as a splash screen when I open excel. I am using the 2007 version. I have cleared all old files per issues with active-x from Dec 2014. Problem 1: I would like the commandbutton centered both vertically and horizontal so that it does not matter...

I have a function but can't seem to figure out how to get the result to be centered within the cell. Is it possible to get the output of this example function to be centered within the cell? Function Add(a, b) Add = a + b With Selection.VerticalAlignment = xlCenter End With End Function

Hi guys, I am generating several checkboxes onto a workbook I have via VBA, but the issue I'm having is that the checkboxes are not aligning to the centre of the cells. I was hoping someone could point me in the right direction with this. I have included a simple version of the code I am...