columns

Is there a way to make this easier? Less wordy? Columns("B:C").EntireColumn.Hidden = True Columns("F:G").EntireColumn.Hidden = True Columns("J:O").EntireColumn.Hidden = True

I currently have a list of clients where in some cases, the clients have multiple client numbers which are in different columns. I need to move those with multiple client numbers to have the client number on it's own row. My dataset currently looks like this: CLIENT CODE 1 CODE 2 CODE 3 CODE...

Trying to see what the formula would be if I had two columns with values and needed to input them into the third column. In the third column I want the value of the first column, unless there is a value in the second column. What formula should I use? Thanks, MK

I have a report that has 2 columns in the Detail section. I would like for the columns to only be 3/4 down the page, so my report footer will show at the bottom of the page. Currently, the columns extend down to the bottom of the page, continue to the right side until all the data is displayed...

Hi, I have hit a wall trying to create a macro to set a range using the last column with data and column "C". Column "C" being the constant and the other column always changing. Thanks for any help, Tyler

Okay so I've been struggling with this for a while and I can't seem to formulate my question that great either, bear with me please. So, I have created an excel sheet that collects exercise data into columns extending for several weeks. In my data sheet I am trying to collect these data points...

Hello All I am trying to create a macro that will Compare data in two columns (on two sheets (sheet1 Column B, sheet2 Column A) and add any missing unique values from sheet 1 to sheet 2 Sheet1 column B Items#s Item 1 Item 2 Item 1 Item 4 Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Sheet2...

I have Excel 2013. I need a macro that will do the following. I have two rows that need to be copied to another sheet, say "XXXYYY" at the bottom of different columns, in the first unoccupied row, depending on the name in cells C7 and C8 Row one occupies A7:J7 Row two occupies A8:J8 If the row...

I am faced with an issue with my data and pivot table VBA. My data now adds a new blank column on the far left. I must delete this column so that my data fits in the correct range and the column all have a header as before. When I delete this column the range of the source data changes minus the...

I am trying to achieved the desired results on E4. I'm looking for a formula that will count a unique occurrence specific to a date, ignoring duplicates and blanks. In this case, 19NOV19 has 2 trucks. 20NOV19 has 3 trucks. 21NOV19 has 2 trucks.

I tried to open an old Excel sheet, and columns A through AM were hidden. I cannot open the hidden columns by using the Unhide action (highlighting the entire sheet). Any suggestions that would enable me to open these hidden columns would be appreciated. Thanks.

Dear Excel Experts, I have a Data in Sheet1, I want to copy some columns to Sheet2 as per below condition. In Sheet1 from cell AC15 Employees Date of Birth, I want to copy columns C, D, E, F, I and AB from 15th row and paste to Sheet2 of column B, C, D, E, G, And F respectively to 10th row if...

I noticed something odd today and I don't know if this is new or if I just never encountered this before. I have 3 files in a folder and imported from the folder into Power Query. 2 of the files have 2 columns, 1 file has 3 columns. Power Query imported just the first 2 columns from each...

Hi There, How can I check to see if all rows in columns A, B, and C have the same dates and spot the rows where the dates are different in these columns? Thanks.

Hello, I am working on a project and it has been a while since I've had to use any VBA, so I'm saving the time and asking. I have data on two separate worksheets. I want to compare column B on Sheet 1 with column N on Sheet 2. Any values that do not match between the two columns I would like to...

Hello! I am new to excel and have learned a lot from these messages boards and hope to keep the learning momentum going. I have a large dataset with over 25k rows and hundreds of columns. I would like to delete rows (participants) who have over 50% missing values per variables. Each column...

Hi Everyone, Thanks for this awesome forum. I've spent a lot of time on here in the past and am normally able to get answers from previous posts but this time I can't so trying to post myself. I want to write a macro that takes the values of a set of columns (the number of columns will vary...

Good Afternoon, How can I create 2 columns with distinct date ranges? I have 1 table with my dates and units and I want to show the units sold for 1 week in 1 column and the next week in the second column and then calculate the change WOW. I don't know how to have two date columns from one...

Hello all- I am running a line of code to delete multiple columns of unneeded info, this is what i am running: Range("A:B,H:H,J:AD,AG:AK,AN:AX,AZ:BJ,BL:BN").EntireColumn.Delete Is there a way to run this code and make it go faster? I have a timer on for this line and its taking between 9...

Hi all, After DropButton Clicking, it shows all CoboBox’s records with columns visible, but after selecting a record from list, CoboBox shows first column’s value only, rest columns are hidden. Is there a way to show selected record’s all columns? Thank you in advance