fill

Hi, I'm trying to copy data from sheet2 into sheet1 using the following formula ='sheet2'!$A1 and then dragging the formula all the way to column Z. I want to keep Column A the same but have it automatically fill the series of A1, A2, A3, and so on but it doesn't do that. Instead it'll copy...

I need to produce a SKU GAP Fill report and would like to get some help. We have thousands of accounts and 53 SKU's and I need to find out from the sales reports from distributors which accounts are missing key SKU's. Any help would be appreciated.

I have code set up to select rows and can then fill down, but I want column C to fill series and the other columns to copy down. The Range will always be different and so will the number of rows selected. Is there a way of doing this? Private Sub CommandButton1_Click() Dim lRows As Long...

So at work a guy goes through a spreadsheet and color codes different part numbers will the fill function depending on the status of the part then we get a new list of parts on another sheet and he has to manually go back and forth do highlight the cells on the new sheet. Is there a way when we...

Hi all! I am in need of code that will fill in the below formula in E7:E5000 with a deactivate event. =IFERROR(INDEX(Instruments!$C$3:$C$40,MATCH(B7,Instruments!$B$3:$B$40,0)),0) Thank you!

I have an Excel table of that format number | description | weight 1 | weight 2 | number | description | weight 1 | weight 2 I have to fill in data by finding the number and manually fill in weight1 and weight2 Is there a way I could just make the data entry quickly instead of finding...

I am not sure if this was asked before. I tried searching, but didn't find any. Maybe I'm searching by wrong keywords. I have an excel sheet where F9 and F10 is blank. When printed on paper, it should show # / #. Imagine Microsoft Word setup with page numbering. Depending on the project we are...

I want to highlight the days on my calendar that match my Event list, but I want the different events to have different colors. example: Event List 1. 1/3/2020 - Baseball 2. 1/4/2020 - Football 3. 1/5/2020 - Golf 4. 1/6/2020 - Baseball 5. 1/7/2020 - Baseball 6. 1/8/2020 - Golf I want the...

Morning all. I found the below code to fill a selected range that has empty cells amongst the data to fill the blank cells with whatever input into the resulting pop up box, in this case zero. It works on part of the worksheet but not on the other, I cannot understand why it will not work on...

Hey All, So a friend of mine has a workbook that is acting up. When he selects a range to fill the cells he has to click twice. The first time he clicks nothing happens, and the second time he clicks the pattern is applied. I thought this was curious so I recorded a macro when he did this and...

Hey guys always such great help :) Had a question that i could not find on the web: I have a table with the auto fill function on which is great, however this is just one column that i would like to disable the auto fill function. Is there a way to do this?

Is there a formula I can use in Conditional Formatting to highlight specific cells (not the row) based on the text in one cell in the row to highlight the data in the same row? Currently I'm creating 3 CF's (">0", "=0', "<0") in the specific row of data, then using the Format Painter to copy...

I need to fill a column of my table with VBA as follows: IS100 IS110 IS120 IS130 I can select the range as follows but not sure how to proceed after: Range("table_admin[Sequence]") many thanks Andrew

Hi There I have a list of postcodes and their 16 wards. I want it sowhen someone enter the postcode into the postcode column it astronomically picksthe ward relating to this postcode and fill in next column once the postcodebeen entered. Does anybody have any ideas how I could do this? Many...

Hi I want to fill blank cells with 0. The code below gave me error message complaining that rows.count overflow. I changed it to 1000 and it worked My question, why I got that error message, and how you would do it using your programming style? Thank you very much. Sub fillblankcells()...

How can i force a user to fill in cells in an order? c3 first f3 second h3 third ect...

Apologies for including the formula in the title. I was unable to paste I in here. Any advice as to why I'm unable to fill the formula? I've tried other formulas and they auto fill, but not this one. Do I perhaps need to do it as a vlookup? If so, any help would be greatly appreciated. T

Hi I would like to format 2 or 3 cells based on the colour of another cell So when the cell goes to Red i want the other cells to have no fill Any other colour and they display their information Help much appreciated

<tbody> Cost Center 1234 Total Cost Center 1234 </tbody> I have a table of information where, in column A there are title showing the beginning and end of each group. I want to fill down these titles. In the example above, I want to fill down the Cost Center 1234 in the empty...

Looking for some help in how to setup a logical IF statement (believe that's the right terminology). Column C below, I'm trying to determine the following G1 = if network count =0 & Device count is >1000 - Then fill in G1 into cooresponding C cell G2 = if network count >1 & device count =0 -...