Using For-Next To Fill Cells
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
ADVERTISEMENT
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
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
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
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
Aug 13, 2009
1. I want to highlight cells on a form so that a user knows which cells to fill out.
2. When they print the form I do not want the cell shading to print.
View 2 Replies
View Related
Jan 27, 2005
how can I automatically fill cells with certain colors based on the value of the cell. (i.e. I want to search an entire workbook and fill cells with values between 80 and 99 green, 60 to 79 yellow and 0 to 59 red.)
View 9 Replies
View Related
Jul 1, 2008
I am working on a spreadsheet for a shoe company. I have separate columns for the size, model, color, and item number of a shoe. I get everything except for the item number from a written document; I then have to find the item number for the shoe from another excell document called the Master List.
I was hoping there would be a way to have Excell auto-fill the item number for me. For example, if a shoe is a Red, Athens (the shoe model),size 12, its item number (which can be a pain to find) listed in the row of the Master List is aaabbb. So I want to just enter in the size, color and model number, and have Excell find the item number for me, and fill it in.
I have enclosed an example. Sheet 1 is the sheet I would be working on. Sheet 2 is a portion of the Item master list, which is actually 50k lines.
View 8 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
Sep 25, 2007
I have a situation where I am trying to copy to blank cells. All the data is in Column A. In Column A there are Account numbers that are attached to dates in Column B and Transaction Amounts in Columns C & D.
If there are multiple dates with transactions, then Column A does not repeat, but is blank until the next Account number. I am trying to have the Account number fill in the blank cells until the next Account number. I have a macro that runs and picks up the Account number and then copies the data in Columns B - D. However, the blank cells are messing up the macro.
View 4 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
Apr 4, 2009
I just stumbled onto this forum while Googling around, and it looks great. I'm pretty new to VBA coding so please bear with me. Effectively what I'm looking to do in this mock-up file, is anywhere the currency is "EUR" in column A, I'd like the relative cell in Column G to change to "INSERT TEXT", else I want it to untouched (i.e. to keep the comment it currently has).
View 6 Replies
View Related
Jul 14, 2009
I currently have some code that copies a single cell from multiple worksheets. Unfortunately those cells all have a yellow fill and i don't want that fill showing up in my summary sheet. How can i alter this code to copy the cells without the fill.
View 2 Replies
View Related
Dec 18, 2009
Look within sheet "highlowperf" column K and copy the row containing cells that are filled green in column K into sheet "overallperfomers" starting from row 9 within the "overallperformers" sheet until completed. It needs to be from row 9 as i have other data above this which i need to keep intact.
Further to this i do not require all information from the row that is found to contain a green fill. I wish to copy columns A B C D E F G K.
If this second part is not possible I can settle to just copy the whole row over and i will try and work around.
View 6 Replies
View Related
Jan 6, 2010
I have 2 sheets that are used for an inventory that tracks hours on a tool that we use where I work. One sheet allows the user to add items to the inventory along with the current hours on the items. On another sheet, I have several dropdown boxes based on the category of items that are autopopulated with the item's serial numbers through data validation. So far, I'm only able to have the serial numbers fill the dropdown boxes, but I also need to have the hours associated with the individual serial numbers transfer over to this sheet as well in the cell adjacent to the dropdown list.
I assume the pseudocode for this would be for each cell in the dropdown sheet, if it matches a cell in the inventory sheet, grab the cell's value in the hours column and paste it into the adjacent cell on the dropdown sheet, but I'm not sure how to do the actual VBA for it.
I've included my sanitized workbook so you get a better idea of what I need.
View 8 Replies
View Related
Jan 23, 2009
i would like to be able to fill color numerous rows of cells that have a number in one of the columns that is either above a certain number or below a certain number.
example 3-Nov 5 H
5-Nov -3 V
6-Nov 4 V
9-Nov 12 V
10-Nov -1 H
in this example i want to fill color any row that in column 2 has a number less than -1 and greater than 4.
View 3 Replies
View Related