colomn

I have a table with columns of data, the number of which may vary. I need to write a simple code to include in a macro, which would delete all non-empty columns after column G. All the columns have headers in row 1. I am just a bit confused with a number of options.

Hey all, so let’s say I have a pivot table that has many categories. I want to tell the vba to onlygrab the categories in colomn A and not the blank cells and paste them in tab “sheets” in colomn s. How would i do that? Thank you in advance !

Hey all, i have ave a simple loop that goes through all colons and rows. I want to to go through 2 rows (1&2) then skip to 11 then run for 4&5 then skip to 7&8 and so one until there is nothing in colomn A. Please help me Thank you!

Hi all, i created a loop but I have MYCOLOMNas a variable representing where the macro should start. So 1=A B=2 and so on. I was wondering how I change my colomn to start from the first empty colomn and run the macro from there thank you!

Hi, i am am trying to auto fill. Taking the average in cell A1 and B1 and putting it in C1. I want that to auto fill in colomn C until there is not value to average in one of the rows.

Hi, I checked the forum but couldn't find anything that worked for me. The problem I have is getting excel to count only the unique combination Part and Location, in the example below it should return the number 2 (colomn D) as there are 2 unique locations for the combination. <tbody> COLOMN...

So I have recorded a macro and I want to loop it but all it’s doing is just repeating the same code over and over again. I want it to run and move right a Colomn and run for all Colomns. To give more detail I just wrote a sumifs equation and I copy paste it to the next colomn chnage the cell and...

I have this spreadsheet with some information on it. What I want to do is. For example. In cell G5, if the data in cell C5 matches any of the numbers ts numbers in the 2nd image, I want to copy over (for example) the corresponding Client name, if the number doesn't match any in that colomn then...

Hi Master Need your help please. First sorry for my bad english. I have two colomn contain string character, example like this: Colomn A1: Billy Colomn B1: Adam Which is wrong alphabetical order, so in Colomn C1: equal to 0 It should be: A1: Adam B1: Billy Colomn C1: equal to 1 This in...