cell data

Apologies for the noobiness, I'm a CAD technician who's been roped into helping with some excel stuff. I'm trying to accomplish this using functions as I haven't used VBA before (although I'm open to trying it out). Problem: I have a 'master' workbook that contains hundreds of sheets, each...

Hi All! I've been scouring the web trying to figure this out and I'm sure it's relatively simple but for the life of me I can't figure it out which is probably due to my lack of understanding of the coding hierarchy and scope needed. I've tired numerous different things and I wouldn't be able to...

Hi, Can anyone please help me with the following request? I want to retrieve cell value of the corresponding second column of an array, regardless of which cell is selected. (Same row as selected cell, but second column). for instance, if cell X10 is selected, I need the value of "B10" to be...

I would like a unique header for each worksheet in my workbook based on cell data in the worksheets. I compiled the VBA below, but it cycles through my workbook and updates all headers based on the Active Sheet cell data such that all headers end up the same. For clarification about the VBA...

Hello, I am trying to insert a comment on data-validated cells in a column through VBA. There are multiple possible values in the range and each has their own conditional comment. Eg,, if cell value = X, insert comment X. If cell value = Y, insert comment Y. I've been searching the boards and...

I am trying to find out how I can enter a number on a form and search a column "A1" for that number, if a match is found I would like to know the row number so I can pull data from that rown to form. If the number is not found I would like to know it was not found. This seems like it should...

Hi, I am currently importing information from outlook into a single excel cell. The content of the email looks like the following - -------------------------------------------- REGISTRATION INFO -------------------------------------------- John Doe 123 Excel St. New York, NY USA 12345 123...

I have 8 columns and 3644 rows. Data starting on the fourth row. I have used conditional formatting to highlight the data in column E cells if condition exists, If the column contains "N" or "F" i want it to highlight the entire row but it only highlights the "N" or "F". What is the best...

I will be importing data in Column A:AF. This is what I am trying to do: Each time new formation is entered in a row ex A3:Af3 A3 will be a hyperlink that references all cells A3:AF3 I found this but it creates a hyperlink to each cell in row 3 intead of creating one link to range A3:AF3...