formatting

Hello, I’m very new to excel macro's What I am trying to do is take Info from a BOM with Reference, Value and Part numbers from sheet1 and move the data into sheet2 that I can then use to print a sticker. when I run my macro it opens a search box, I search for a unique part value then it...

I have an excel file that is exported weekly that I need to convert certain cell colors into other colors. To accomplish this I found a User Defined Function =identifycolor (seen below) that I wrote into the conditional formatting to change the color of a cell if it met one of the color codes...

Hi This has flummoxed me. I have attached two images showing how the address details are displayed in the cells, and how they are displayed in the drop down preview section. As you can see there is the odd square symbol representing a line break in the main cell section and the line break in...

Need help regarding how I can copy the data from different columns having some cells with no data into a single column ignoring the empty cells...

I am trying to find a way to identify unique numbers in the rate column for each ID number if it has Units. For example: In this instance, I would not need to identify anything for the first ID because even though there are units all of the rates are the same but the second ID has one rate...

Hi, I'm using conditional formatting and for all of the ones I have used (equal to and contains) when i removed the text it leaves behind a half border like so: It stays there unless I go into the formula line and press enter. I would like it if it doesn't do that. Does anyone have any tips...

Hi All I really need your help. I have an inventory in and out log. It logs date an asset was issued and date it was returned. I have everything in a drop down menu and i need the following. these assets are loaned out on a daily basis and returned on a daily basis. (Or supposed to be) there...

Good afternoon all, thanks in advance if anyone is able to help me out. I have a problem at work. I have a set of distributions; the distro's are made up of 10 columns. One of them being 'UPC' which is a 12 or 13 digit number. Basically, I have a master file with all the distro's that can go...

I can't find the answer anywhere. I have an automated E-mail template. In one of my cells there is text that is wrapped. I want it to display that way in my E-mail. This is my current code. Its cell C4 I want displayed properly. Sub Email1() ' Working in Office 2000-2016 Dim OutApp As...

I would like to box parts of text within a cell. I know it is possible to format the font of partial cell contents but is it possible to box it. I have attached a picture of what i would like but in just one cell. using Office 365

Hi, I am using xlookup to pull some information from another sheet in the same workbook. The 'return array' is formatted as currency (not sure if this matters), but its not pulling as currency. Its pulling as a general number, but when attempting to format the destination cell to currency it...

I have pieced together some code using excel as a file picker to add images to embed within subject body. Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting Outlook seems not to have a huge support...

Hello I have 7 columns of data spanning 3077 rows and I have concenated it to one column to read as an address with phone number and website..each of these having a title in the concenate formula. I need to transfer this data to a CVS form to upload into a map however when I try it reads data as...

Hi all, I have this VBA code to write an email body text: eBody = "Dear person," & "<BR><BR>" eBody = eBody & " 1Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text Text text (Text text...

AXIS values I'm hoping someone can assist. I have a bar chart and want the horizontal access lines to represent first day of each month. When I right click horizontal axis to format axis, I don't have the option to change min & max bounds to dates/months as in start 01/10/21, and end 30/06/22...

I need some VBA to do the formatting auto 5 Sheets 1st sheet formatting template other 4 Q1 / Q2 / Q3 / Q4 Button needs to be on each of the Q's, need to copy formatting from formatting template and paste it from A2 down to last row with data Formatting on formatting template Q1 is from B2...

Hey again guys, I've got some really good help in another thread but there are unfortunately a few more questions I have regarding excel. I'm getting a little stressed because I've only 2 weeks to finish a school project and in times like this I just wish I picked up Excel and learned it...

Hey everyone, I wrote this bit of vba quite some time ago (2017) to run a little bingo caller for a social team where I was - keeping excel up to date wasn't something they were good at - so the version at the time worked. They have now updated to O365 and the reformatting of the text in the...

Hello! I have a simple pivot chart collating some totals for figures in each month of the year. I would like this to display in the month order (Jan-Feb) but I am unable to manipulate the source data so it reflects this. Is there another way to do so? I do not have an option to use the custom...

I'm looking for a best way, most likely via Conditional Formatting, to highlight 3 reoccurring from B within 3 days time frame from A I've managed so far to get 3 reoccurring but for just 1 day So, all those 4 rows with PC should be highlighted, not just 3 of them Hope you can help