columns

I have several sheets that have hidden rows and columns but on occasion I need to unhide them. This usually results in a freeze/crash of the sheet due to the volume of columns being unhidden. How can I limit the number of both rows and columns to something like 15 and 50, respectively?

Can anyone help me with this code that I have problems doing for the last 2 days. What I need to do is find the last column in that particular row starting from column H onwards, if there is any text that shifts down the row in column G and repeat the action; when it finds the text in a cell it...

Hi, I am new to Power Query (like just started yesterday new), and I have a question. Do the queries I create and update have to have the same number of columns? I have these financial reports I receive every month/quarter that requires a lot of clean-up. But there is a column for each...

So I have a list if things in a sheet. In the A column there are names, B column has a date, C column has a number and the D column has another date which is 5 days from the date in column B. I want to be able to come up with something that when someone's name is written into column A and if the...

I have successfully used a code to create the multi-selection drop down menus across an entire column but I was wondering there was a way to apply it to multiple columns on the same sheet. I currently have it for E(5) but want to apply it to F(6). I don't have a row limit as we plan the data...

Hello, I am trying to write a macro that builds a chart when it is run. However, if the chart already exists (ie if the macro has already been run at least once), I would to delete the existing chart and create a new one. To be honest the whole ChartObject vs Chart thing is not very clear to me...

So I have a sheet with information in columns (approx 200) which I would like to move to new sheet. The idea is that I need column A in each new sheet following with column B, then next sheet again column A + column C and so on till the last column. Could someone help me with this...

Hey good folk, I have a timesheet i get my engineering dept to fill in, we have a lot of customers who's name they have to input when working on a design. The "short" name our ERP system uses is noting like the actual customer name and my guys sometimes get confused. Anyway i have created an x...

Hi, I'm hoping someone can help figure out how to separate a series of addresses in one column into separate columns, when there are no columns to use for Text to Columns. I have a large sample file of addresses and was able to get 75% of them (the ones correctly formatted with commas)...

Hello! I'm looking to copy an entire row from one worksheet (Sheet1) to another (Sheet2) based on multiple criteria. For example, in the image below, I need to be able to find all the "Green" fruits and then refine that further to only "Medium" Size. Then, I need to copy the entire row (as long...

Need help if anyone can provide it. I'm trying to write a Macro where i can hide columns based on a cell value. The issue I'm having is trying to figure out how to construct it in a manner where I can have the macro work based on multiple cell values as well as work throughout the entire...

Hello, I have a .csv with more than 255 columns (395 exactly), I only need 3 columns but I cannot manipulate the source file manually, that is, I cannot divide it in two. The columns are: 131, 208 and 282 I have tried to do it by wizard but Access won't let me do it because it has more than...

Hi everyone! I'm looking to compare two columns on 2 different files. Let's call them Column 1A (File 1, always has the same file name and directory) and Column 2A (File 2, shares directory with File 1). I want to extract the unique values from Column 1A that are not present in Column 2A and...

Hi - I have a list of partnerships like this on Sheet2: For each uniquely named partnership, I would like it to take that name and copy a "template" column I will provide but with the partnership name as the header in a table on Sheet1. My table looks like this: So that in the end, each...

I'm having a tough time with this and think I'm very close but cant quite get the. i was trying if statements, index match, but cant get it to quite work. here's what I'm trying to do in column a the letters appear in sets of 5, and in column b, the letters appear 1 each. how can I achieve the...

HI Friends , I'm looking for a little help in Vba macro. I have two sheets ( category ) which has values like CURRENT ASSETS ,NON CURRENT ASSETS, CURRENT LIABILITIES ,NON CURRENT LIABILITIES , PROFIT LOSS Etc.. in the other sheet (Balance sheet) in column A i have CURRENT ASSETS ,NON...

Hello. I am trying to copy/paste data from 2 columns (containing several rows with required data) and transfer the columns to another worksheet in the workbook over a time span of either 23-24-or 25 hrs The problem is that I need to use an argument what is not consistent and I have a macro in...

I have a spreadsheet with hundreds of lists that each have a header and vary in length. The headers all follow a similar format (ABCD 123AB) and I want all columns for which the headers share the first 8 characters (including the space) to be combined into a single column with the header being...

Hello, I have a Navigation tab in a workbook that has buttons to take you to specific sheets. I have written code so that when the "Plastics" option button is selected columns I:Q are hidden and all buttons within those rows are hidden. Private Sub OptionButton2_Click() '''''''Plastics...

I'm creating a worksheet (Data) that will reference another (Sheet1). In Sheet1, the data will change periodically by being pasted in from a form filled out by someone else. The trouble is that the form has three versions, and each version has a slightly different number of columns. I need to...