Can I Fill Non-adjacent Cells With The Fill Feature? (example Listed)
Nov 7, 2008
how to enter data in non-adjacent cells using a fill command.
Here is what I am trying to do:
in the column, I am holding ctrl button to select every 10th cell down the sheet. I need to enter a date in every selected cell that is exactly 7 days apart, i.e., 11/7/08 then 11/14/08 then 11/21/08, etc.... but no other dates or data.
I have tried to figure out a way to do this other than manually, but am confounded.
View 9 Replies
ADVERTISEMENT
Feb 19, 2014
I'm trying every conceivable angle I can think of in vba and coming up empty. What I have is a spreadsheet similar to this:
Column A Column B
1. 1234567
2. 2345678
3. 3456789
4. 4567890 A0001
5.
6. 9876543
7. 9876543
8. 9876543
9. 1234578
10. 3456789 A0002
What I would like to do is to fill in B1:B3 with A0001 and B6:B9 with A0002. The number of rows in each set of data will vary, but the identifier (A000X) will always be located in the row in column B adjacent to the last entry for that set of data in column A and there will always be empty cells between data sets. The number of data sets will also vary.
View 5 Replies
View Related
Oct 18, 2011
Still adjusting to 2010 Excel...How do you use the automatic fill in feature of formulas; e.g. when typing =convert....a fx function appears....not sure how to use it
View 2 Replies
View Related
Aug 11, 2008
I would like a macro that when run, finds empty cells in a column within the used range and fills them with the same formula in the other cells in the same column but relative to the row.
I have a basic understanding of VBA so if someone can set me on the right track i'll have a go myself as i appreciate this would take a while to write out from scratch.
View 9 Replies
View Related
Feb 1, 2010
Is there some easy way to fill out column B referencing column A, but only incrementing by 1 row in A every 2 cells in B?
Example:
Column A:
A1 = 1
A2 = 2
A3 = 3
etc...
Column B (I would like to fill this, referencing column A):
B1 = A1
B2 empty
B3 = A2
B4 empty
B5 = A3
etc
View 4 Replies
View Related
Oct 22, 2013
I am setting up a schedule maker for a coworker, in which I have divided two columns into time in and time out for each day of the week. My coworker wants the cell to be highlighted red if the shift is a night shift (Begins after 4), and I used conditional formatting to set up both columns independently to evaluate if the value of their content is after 4 PM. However, this means if a shift starts at noon, but ends after 4, only the time out cell will be highlighted red, not a huge issue but it isn't aesthetically pleasing.
View 3 Replies
View Related
Jan 6, 2007
what is prompting this formula to auto fill down when a value in an adjacent cell is entered.
In column A I enter an unformatted fax number.
In column B I use the following Text Formula:
"="("&LEFT(A20,3)&")"&MID(A20,4,3)&"-"&RIGHT(A20,4)
Someone in my office copied the workbook and now any time a value is
entered into the next available Column A cell. The cell in column B will automatically apply the above formula and format the fax number. The person who copied the workbook does not know how this is working nor does anyone else in the office.
There are no macros embedded in this workbook so no event is firing to cause this.
I have attached a small copy of the workbook called "Auto format1.xls"
How to use:
-Select cell B20 and not nothing is in it.
-Enter any 9 digits in A20 and B20 somehow
copies down the formula from B19.
how to duplicate this.
View 9 Replies
View Related
Jul 17, 2014
I've created the following Macro based on some of the posts on this great forum! It works great, but I'd like to tweak it for another purpose where it would fill the formula down until a cell in column AF had the value "#N/A" or stopped having the value "clean". The #N/A is from a formula result so I'm not sure if or how the Macro would treat this.
Code:
Sub Y_CleanUp3()
'
' Clean Up Bad Data Macro 3
Dim LR As Integer
Range("AH2").Formula = "=VLOOKUP(X2,'[Territory by Zip Code.xlsx]Sheet1'!$A$2:$B$135000,2,TRUE)"
LR = Range("AF" & Rows.Count).End(xlUp).Row
Range("AH2").AutoFill Destination:=Range("AH2:AH" & LR), Type:=xlFillDefault
With Range("AH2:AH" & LR)
End With
End Sub
View 2 Replies
View Related
Apr 27, 2009
I have a listbox that has row and columns. The rows are combinations of options and the columns are Additives.
After selecting a row in Listbox1, (first column are names) i would like the value of the second column to goto a specific area.... find that value and in the cell to the right of it place a "Y". The "Y" would indicate that "yes" it was part of the selection row of the listbox. Same for third column, forth, fifth and sixth. The result from the listbox is a number of Y's and N's in the result page. Then making all that were not part of selected line and equal to "N" to hide row (height = to zero).
Listbox and expected result are in attached example worksheet.
The attached does show the need much better then I can explain it.
View 9 Replies
View Related
Apr 30, 2014
Is there anyway to automatically fill the empty added cell after inserting a row without using the fill handle? For example, for a series of numbers: [URL]
2. Drag the fill handle Selected cell with fill handle across the range that you want to fill.
Or running balance: [URL]
2. Extend the running balance formula into the new rows by selecting the last cell in the balance column and then double-clicking the fill handle.
View 6 Replies
View Related
Jul 21, 2014
I am currently working on a project and want to use a picture of a cauldron and have that filled in as opposed to a bar graph filled with cauldron pictures. Is this possible? I picture something similar to how someone would fill a picture on a piece of paper until they hit their goal.
Secondly, If I need to do a bar graph I know I can do conditional formatting on the values within their cells but can I create this formatting specifically to the graphs themselves?
View 1 Replies
View Related
Oct 14, 2008
i have attempted may be totally in the wrong direction. I have a worksheet where column A should hold the same value for many Rows of information, but instead only prints once in the first row of that section. The # of rows in each section vary; sort of like this - where ... is a blank cell:
A 1
... 2
... 3
... 4
B 1
... 2
... 3
I would like to write a macro that loops through Column A and replaces empty cells with the most recent value. When i run the following code it puts the value in the blank cell, but fails to loop to the next.
View 3 Replies
View Related
Jan 31, 2007
i typically have a difficult time figuring out how to reference cells correctly depending on the situation. anyways what i have is a formula in a cell and i want to fill in the next four cells to the right.
the help file gives:
Worksheets("Sheet1").Range("A1:M1").FillRight
View 9 Replies
View Related
Jul 13, 2012
I'm trying to loop through a list of about 1300 items and copy the rows where one of the cells has a fill color to 2 different sheets in the same workbook. If there's no fill color, the row moves to a different sheet.
My code is determining that all cells have a fill.
For Each cell In Range("Classification")
If cell.Interior.Color blank Then
cell.Select
Range(Selection, Selection.Offset(0, -9)).Copy Destination:=Range("Compliance")
Range(Selection.Offset(0, -5), Selection.Offset(0, -9)).Copy Destination:=Range("Mstar")
Else
cell.Select
Range(Selection, Selection.Offset(0, -9)).Copy Destination:=Range("RP")
End If
Next cell
View 3 Replies
View Related
Feb 7, 2013
I am using Excel 2010 and basically i am trying to fill a range of cell with a green color if any value was enter in a specific cells. Example: I would like to fill range: A10:c13 with a green color (regardless of the cells content in this range) if a value was entered in cell C10 or C11 or C12 or C13.
I've tried conditional formatting but unfortunately I'll have to apply formatting for every cell and for a range of over hundred cells is not efficient.
View 7 Replies
View Related
Jan 16, 2009
Working with 2 worksheets in the same spreadsheet. In worksheet A cell F6 is a solution (hex2dec) these solutions are staggered consistently in column F (F6, F9, F12, F15 etc) In worksheet B cell A2 displays workshop A cell F6 details (=ATR!F6)
Worksheet B cell A3 Autofil uses (=ATR!F7) I want (=ATR!F9) Worksheet B cell A4 I want (=ATR!F12) How do I condition autofil to follow my chosen sequence ie F6,F9,F12,F15 etc...
View 3 Replies
View Related
Aug 12, 2009
I am trying to create a nice equation that will look in row 35 for the highest value and then return the value that is 33 rows up and 1 column to the left. See attachment of for more details.
Basically, I need a formula to fill in cells B38:B41 (detail included in Excel doc attached).
View 6 Replies
View Related
Aug 12, 2013
I have a workbook with 15000+ Isometric drawing nos. in column A and and joint nos. in Column B. I want to fill the blank cells with the isometric drawing no.s for the corresponding joint nos. A sample worksheet is attached.
View 8 Replies
View Related
Feb 5, 2014
I want to run a series of cells but how to do it. E.g.
Cell A1 to contain the data 2A
the next cell (A2) to read 2B
the next 2C etc etc
I've tried just dragging the cells down but it just duplicates 2A, 2B, 2C whereas I want it to fill the next cells as 2D, 2E etc
And I've tried using the fill series option but neither seems to be working (presumably due to the letter).
View 4 Replies
View Related
Nov 5, 2009
I have this formula in the cell
View 4 Replies
View Related
Jul 10, 2007
I have two columns with data (length of column B represents total length of database.) Column A only has some blank cells.
I need to fill Column A blanks with the contents of cell above.
Monday
Tuesday
[blank cell]
Wednesday
Thursday
[blank cell]
[blank cell]
***end of column B
Therefore VBA to place Tuesday into blank and Thursday into the two blanks before bottom of the range of Column B.
Using record macro doesnt give me go to first blank etc.
something like
Start column A2 to End
Find first blank, copy active cell -1
Next blank cell. (ins some cases it will copy the name it has just filled into cell above.
Finish at last cell in Comumn B
View 6 Replies
View Related
Apr 3, 2008
Is there any way to fill blank cells going up instead of down, other than having to go to each section and dragging the fill handle. I'm looking at a list of data that has a summ code at the bottom of each section of data. I need to fill the blank cells above the summ code for each section.
For example:
D2-NHL RACE .001515
D2-SERVICE CODETO1515
NHSUMM CODETO1515
A0-ATBV TRIO DV .018989
A0-SERVICE CODETO8989
C0-ATBV C HN .017676
C0-ATBV C HNAC .0011
C0-SERVICE CODETO7777
43-ATBETRIOHN .014646
43-ATBETRIOHNAH .0011
43-SERVICE CODETO4747
45-ATBECMBDVRHN .0133
45-ATBECMBDVRHN0 .0033
45-SERVICE CODETO66
NVSUMM CODETO6346963468
Everything above NV needs to be filled with NV and everything aboveNH needs to be filled with NH. There are over 13000 lines of data. How do I accomplish assigning or filling the related summ codes in the blank cells in between?
View 5 Replies
View Related
Apr 21, 2008
I have a spreadsheet dealing with orders made by customers and the delivery of the items they have ordered.
When I have delivered the items to a customer I need to note down that their order has been delivered. I also need to enter the date on which it has been delivered.
I have created a user form in which I select the order number of that particular order from a combobox and state whether or not it has been delivered, this is either a "yes" or "no" selected from another combobox.
I then have to note the date in a text box on which the items were delivered.
My problem is getting the answer "yes" or "no" and the date to fill in on the worksheet next to the corresponding order number.
View 3 Replies
View Related
Jun 10, 2008
I am getting with the great user defined function (SumColor) you posted here and that I have modified a bit to suit my need. I have a spreadsheet thanks to which I calculate the total cost of a product (find spreadsheet attached below). There are three types of costs:
1. Amortization: always start with AMOXXXXX which I locate in the end of the spreadsheet
2. Assemblies: always start with a 99XXX or 98XXX
3. Components: any other notation (90, 91, 92, etc.)
Each product can have until 5 levels of subassemblies:
1. Level 0: always located in row 8 with big bold letters
2. Level1: cells in yellow (color index = 36).................
View 4 Replies
View Related
Jan 10, 2009
I need to populate a range of cells with names from a list on another sheet based on the contents of another cell.
In the attached example;
on sheet 2 cell E3 has a number in it that corresponds to a number in column D on sheet 1, I want to use that as the reference to fill in cell E4 on sheet 2 with the value in column A on sheet 1, then I need to populate the YELLOW cells on sheet 2 with the names from sheet 1 column C that also match the values in sheet 2 cell E3.
The attached file has an example. I have been trying to use LOOKUP and VLOOKUP but can't get it to work.
Can someone please take a look at this for me?
View 6 Replies
View Related
Feb 19, 2009
I have this formula: =VLOOKUP(C:C,Sheet2!A1:A10000,1,FALSE)
that I need to put in column A from 1 to 26,xxx. Is there a way to paste that formula in every cell down the column without the part in bold changing? I'm not too keen on hitting ctrl+v over 26 thousand times.
View 2 Replies
View Related
Jan 20, 2010
when I select a value from my drop down list how can I fill in say.. cell A50 with a number automatically?
Pretty much on a drop down selection I want to fill in another cell.
View 11 Replies
View Related
May 15, 2013
I would like to fill some cells with a customer id if this customer is the same as the cell bellow. As my example below.
CUSTOMER idCUSTOMER NAME TYPE
737346 Nikos 81
1154765 Kyriakos 81
1154780 Thanos 81
I would like to fill automatically the empty cell bellow Kyriakos the customer id 1154765 in new column. I want in column "new" to fill with customer id and when the customer id is empty to fill the same customer id as above customer id.
Like the example below
CUSTOMER idCUSTOMER NAME TYPEnew
737346 Nikos 81 737346
1154765 Kyriakos 81 1154765
1154765
1154780 Thanos 81 1154780
View 5 Replies
View Related
Jul 1, 2013
I have a daily spreadsheet tracking sales. When I copy the cells to a new spreadsheet, alternate rows are filled with black. Even after selecting the black filled rows, I am unable to eliminate the black. I would simply like to "duplicate" the existing workbook. How can this be accomplished.
View 2 Replies
View Related
May 6, 2014
I'm using 3 sheets within one Excel file. 1st sheet (target) is called Offer, the 2nd one (source) is called Stock and there's a 3rd one that only contains a button to which i'll assign the final macro. Now, back to it.
I need to copy from Stock to Offer contents of the entire column (basically there are a few more in Offer, so i need to copy each one and place it in a different part). I need to copy from ROW 2 and paste in ROW 6. The length of the document varies, as it's connected to the database (now i can have 3800 rows, in the next hour 3765). Previously i just added an X to row 4500 ( i don't expect to EVER have more than 4000 lines) and just copied from 2 to 4499
Second issue is, on the Offer sheet i have to fill a column with a certain value. Again, it needs to start from Row 6, and needs to be as long as the adjacent column. To get a better idea, i have for example 3800 price lines, so i need the column next to it to be filled with 3800 rows saying GBP (this will be a fixed value).
Also, none of the codes above should exclude blank cells in the middle of the string. Last thing, seems some of the barcodes i have only have 12 digits, so i'll need to add a 0 in front of all shorter numbers to go up to 13 digits.
[Code] ......
I should be able to figure the rest by recording bits and pieces. The Save part is done already, i'm using
[Code] ....
I needed it in XLSX format, not XLSM so that suits just fine. I might need to add hour and minute as well but i can sort it out (as i said, i can do some stuff on my own but this one got me to the bottom).
View 2 Replies
View Related
