Over 1 million tech questions and answers.

Solved: sequential row numbering based on value in another column/cell

Q: Solved: sequential row numbering based on value in another column/cell

I need to provide seqential row numbers from 1 to N that relate to cells in another column when the cell value is greater than zero. For instance, if the column with data is column d and I have data greater than zero in cells d3, d4, d5, and d7 I'd like the row count in column c to read number 1 for c3, 2 for c4, 3 for c5, and 4 four c7. Cells c1 through c3 as well as c6 should remain blank. What formula do I use?

RELEVANCY SCORE 200
Preferred Solution: Solved: sequential row numbering based on value in another column/cell

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: sequential row numbering based on value in another column/cell

Read other 7 answers
RELEVANCY SCORE 103.2

I am trying to create a database, to keep track for stores orders for the ship i am on.
I want to auto generate the stores order number (Order Number) in the format
0730/TAK/yy/$$$
The 0730 is fixed as is the TAK. The yy is 2 digit year and the $$$ is the sequential number.
The yy field i want to take the year from the "Order Date" field in the same form.

IS this possible?
I have Access 2007 but the final database may have to run on 2003.
The database is still in early stages so is still small can be forwarded if it helps

Many Thanks
Charles
 

A:Sequential numbering in access based on another field

Read other 11 answers
RELEVANCY SCORE 98

Lets say I had in cell $A$1 the number "36", in row2 figures for monthly spend, in row 3 cumulative spend and in row 4 the month number(1,2,3,4..). What I want to do is substract the monthly spend from $A$1 months ago from my cululative figure in row 3 so I have a rolling cummulative hardware spend value of 36 months in this case. So in this case if I was to do it manually in cell AK3 I would have "=AJ3+AK2-A2" and drag it further right. So I add my monthly figure of spend each month to the cummulative figure in row three but also deduct the monthly spend from 3 years prior.

So in order to use the figure in $A$1 I could do something in row 3 like: starting from B3: "=if(B4>$A$1,A3+B2-[$A$1rows_further_back_thanB2],A3+B2). So when I get to month 37 in row 4 I deduct the figure in row 2 (in the formula in row 3 - the cummulative row) from 36 months prior. I hope this all makes sense. Can you help me please (see attached spreadsheet).
 

Read other answers
RELEVANCY SCORE 88.8

I have an Excel workbook with 400k rows Each set of rows contains a table name with the fields in the table. The number of fields is not the same for each table. For example:

COLUMN A COLUMNB

AV_ACTN_RSLT_VWACTN_RSLT_CDAV_ACTN_RSLT_VWDESCRAV_ACTN_RSLT_VWDESCRSHORTAV_ACTN_RSP_VWEMPLIDAV_ACTN_RSP_VWEXT_ORG_IDAV_ACTN_RSP_VWINSTITUTIONAV_ACTN_RSP_VWNAMEAV_ACTN_RSP_VWRSPL_ID

AMT_X_SAL_TYPEWCS_PLAN_DESCR20AMT_X_SAL_TYPEWCS_TOT_AMOUNT

I need to convert the field names so that they are in a row like this:

AMT_X_SAL_TYPEWCS_PLAN_DESCR20WCS_TOT_AMOUNT

Is there any way for me to do this programatically? I'm using the transpose feature but it is time consuming and I have 400k rows. So basically, I want something like if the field in column A row 1 matches row 2, move that field to the right of row 1 and so on until the table name changes.

Or maybe i should dump the spreadsheet in access and try there...

Thanks,

Amy
 

A:Move data from column to row based on value of cell?

Read other 6 answers
RELEVANCY SCORE 86

I need to have sequential numbering from 1 to 600 utilizing a static leading fiscal year indicator and a static trailing division indicator. The format should look like this:

12-001L
12-002L
12-003L
and so forth up to
12-600L

How do I write this to enable the numbering? Please keep in mind that for numbers less than 100 I want leading zeros so that the characters fill seven spaces.

Standing by...
 

A:Solved: Sequential numbering with conditions

Read other 8 answers
RELEVANCY SCORE 84

I am currently running Access 2007 on an Acer Aspire computer running Windows 7. I also use a recent HP desktop running Windows XP Professional and Access 2007 at work. I am setting up a database that has 830,031 records & 100 + fields in the main data table. Presently, the table has no unique record ID that could be used as a primary key. I want the table to be sorted in a specific (chronological) order, which I can easily do with a simple query. I have added a new empty field called D_Rec_ID, and I want to fill this field with the record number for each record in the sorted order. Once the database is completed, the number of records will not change. How can I populate this field with sequential record numbers? The only thing I can get to work is to set up an Excel spreadsheet with blocks of 8,000 sequential numbers, copy each block of numbers, and paste it into the Access table in the appropriate location. I can only do 8,000 at a time without exceeding the MaxLocksPerFile on my work computer (set at 9,500), which I can’t change. This is an extremely tedious process and prone to mistakes. Any suggestions would be greatly appreciated.
 

A:Solved: Sequential numbering of records with record number

DigitalDoc4, welcome to the Forum.

I assume this "database" is only going to be used for Searching?

To do what you want Copy the Table and Paste - Structure Only.
Set your new field to Autonumber.
Now create the the Query and sort it in the order that you want.
Convert the query to an Append query and select the new table as the table to be appended to.
Save and Run the query.
The records should now be entered in the new table in the order that you want with new ID numbers in that order.
 

Read other 2 answers
RELEVANCY SCORE 78

I would like to assign a sequential number in Column A if a cell in Column B contains text.

I used the following formula but it did not work:

=IF(ISTEXT(B26),"",COUNTA(B26:B26))

In essence, I want the following:
Row Column A Column B
1 1 True
6 2 True
8 3 True

Can anyone help?

Thanks!
 

A:Solved: Sequential Number if Cell Contains Text

there maybe a better way to do this

Assume the data starts in A2 and B2

in A2 put
=IF(OR(ISTEXT(B2),B2=""),MAX($A$1:A1)+1,"")
and copy down

see attached
 

Read other 3 answers
RELEVANCY SCORE 77.2

I've been asked to create a "job quote" template in excel so each time it's opened - it will assign a sequential number starting with 15500. The next time it's opened the number assigned will be 15501. I'm almost bald from tearing out my hair as I can't figure out how to this this. Any ideas will be appreciated.
 

A:sequential numbering

If you know how to use VBA you could store the last value in a registry key or ini file and have some code so that when a new file is created from the template it gets the stored number, adds 1, and inserts it to wherever you want.

Hope this helps.
 

Read other 1 answers
RELEVANCY SCORE 77.2

I have created a form in Publisher(using many different programs including word, adobe, and excel) the problem I am having is that i need to have a field at the top to create a sequential number when it prints. so that if i print 500 copies, they can be numbered from 150 - 650 (example of numbers)...do you have any suggestions on how i might go about this?...i've tried putting it into an adobe pdf but i still was not able to figure this out...thanks...

hurleyherd
 

A:sequential numbering

Read other 9 answers
RELEVANCY SCORE 76.8

When removing/deleting a row from a spreadsheet, the leftmost auto numbering column does not renumber and therefor skips one or more numbers. Is there a way to have it auto renumber?

Excel 2000
 

A:Solved: Excel: Left auto numbering column

Read other 6 answers
RELEVANCY SCORE 76.4

Hello,

I am attempting to clear 2 cells, based off the value of another. I am pretty sure the code is correct, because it works within another Macro. Thanks.
Code:
Sub REMOVE()


Dim p As Long
p = Cells(Rows.Count, "a").End(xlUp).Row


For i = 1 To p
Range("k2").Select
If InStr(1, Range("k" & p), "None") > 0 Then Range("L" & p) = "" And Range("M" & p) = ""
'If no Issue, Location/Obsevations should be blank
Next i


End Sub


 

A:Solved: Clearing Cell Contents Based off other Cell

hi
try this variation;
Sub REMOVE()

Dim p As Long
p = Cells(Rows.Count, "a").End(xlUp).Row

For i = 1 To p
If InStr(1, Range("k" & i), "None") > 0 Then
Range("L" & i) = ""
Range("M" & i) = ""
End If
'If no Issue, Location/Obsevations should be blank
Next i

End Sub
 

Read other 2 answers
RELEVANCY SCORE 76.4

I have a very simple form with 3 form fields that populate other ref fields on a single page.

One of the fields is a serial number. I would like the user to be able to enter the serial number (which replicates into a ref field) and then print however many copies they want with each one having the serial number (the same in both places) increased sequentially by one on each print. All other data will remain the same.

The catch is that the starting serial number must be specified by the user rather than being taken from a reference file.
 

Read other answers
RELEVANCY SCORE 76.4

Can anyone here help me with a problem I have in Access.

I'm trying to create a form which would have 3 checkboxes, for Air, Electrical and Mechanical and next to them, an reference number for each.

This reference number needs to be sequential depending on the date

i.e
M01/05/08 would be first mechanical job in may 08
E10/05/08 would be 10th electrical job in may 08

and then the first number would reset to 01 at the beginning of each month. I've been given some code, but I'm a bit of a beginner in access so unsure what to do.

So far, I've created 3 checkboxes with 3 text boxes next to that which references back to the 3 columns in the table, labelled air, electrical and mechanical. I've been told to enter this code

Code:
Public Function GenerateProductID(ProdType As String) As String

Dim Prefix As String
Dim StrNextID As String
Dim Rs As DAO.RecordSet

Prefix = Left(ProdType,1) ' (E)lectrical, (M)echanical or (A)ir

'Select all product codes that begin with the prefix and end with the current month and year
Set Rs = CurrentDb.OpenRecordset("Select * From TblProducts Where Left(fldProductCode,1)='" & Prefix & "' And Right(fldProductCode,5) = '" & Format(Date(),"mm/yy") & "';")

'Is there any previous orders for this period?
If Rs.EOF And Rs.BOF Then
StrNextID = "01"
Else
StrNextID = Format(Rs.RecordCount +1 ,"00")
Rs.Close
End If

Set Rs = Not... Read more

A:Sequential numbering in Access

Read other 16 answers
RELEVANCY SCORE 76.4

How do I renumber records in a column after I have deleted some records. The numbers did not update in the groups where I deleted a record.
 

A:Sequential numbering of records

Read other 6 answers
RELEVANCY SCORE 75.6

Hi. I have two Wi-Fi adapters on my Win10x64 PC - an internal and an external on the roof of my motorhome via USB.

The first is named "Wi-Fi" and the second "Wi-Fi 4", which drives me bananas.

In the registry I found two instances of "Wi-Fi 4" and changed them to "External Wi-Fi". The "classic" control panel displays for Network show this name. BUT, the modern gui still calls it "Wi-Fi 4", and I cannot find where this label is coming from.

Screen cap below shows the disparity.
Plz advise, thanks! /jim

Read other answers
RELEVANCY SCORE 75.6

Not sure if this question has been asked or not i tried to search but i cant seem to find anything on the forum. So my question being:

A1=1
A2=2
A3=3
A4=4
A5=5
A6=6

But here is the kicker if i delete one of the other numbers i want it to auto fix the rest of the numbers and continue:

A1=1
A2=blank
A3=2
A4=3
A5=blank
A6=4

So any ideas? Thanks in advance for the help!
 

A:Sequential Numbering Excel 2007

If the sequence you want is:
A1=1
A2=blank
A3=2
A4=3
A5=blank
A6=4
Then just enter:
A1=1
A2=blank
A3=2
Then select those three cells (A1, A2, and A3)
Grab the grabpoint at the bottom right of cell A3 and drag downward.

From that I got:
A1=1
A2=blank
A3=2
A4=3
A5=blank
A6=4
A7=5
A8=blank
A9=6
A10=7
A11=blank
A12=8
A13=9
A14=blank
A15=10
A16=11
etc.
 

Read other 2 answers
RELEVANCY SCORE 75.6

Hi folks,
I have become a subscriber of this forum because most of you that will be reading this will know far more about what I will be asking about so Hello all thanks for listening to my waffle and hear is your starter for ten.

I am trying to make a number in a single cell in a form generated from an Excel work book page, increase by 1 every time that the form is saved and printed, as a serial number.

e.g. – when the form is printed it is automatically saved in a register and the number is incremented by 1, the cell is L2 on the attached file.

I am using Excel 2003 and Windows XP Home.

So folks dose that sound feasible?

Simon.
 

A:Sequential Numbering in Excel 2003

Read other 6 answers
RELEVANCY SCORE 75.6

I have a form that needs to have a three digit number (identifier) generated and visible on the form each time the document is opened (new number, next in sequence) and saved. I am trying to use a Macro but I keep getting an error that says "Autonew() ambiguous identifier" or something like that. I am not a programmer so I need very specific and easy steps to follow to accomplish this. The sooner the better, as I have been trying to get this done for 2 weeks now and I'm not having any luck.
thanks!
This is the macro code, and the error is "Compile Error: Ambiguous name detected: Autonew()"
Sub AutoNew()
'
' Autonew Macro
'
'
Sub AutoNew()
Order = System.PrivateProfileString("C:\Settings.Txt", _
"MacroSettings", "Order")
If Order = "" Then
Order = 1
Else
Order = Order + 1
End If
ActiveDocument.Bookmarks("Order").Range.InsertBefore Format(Order, "00#")
ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#")
End Sub
End Sub
 

A:sequential numbering on Word 2010 Doc

Hi

This usually means that you have 2 macros with the same name. Check in all modules including Normal modules for the other Autonew() macro.
 

Read other 1 answers
RELEVANCY SCORE 75.6

Hi Everyone,
I am using Word 2007 and I’m trying to come up with a solution for the following:
We have documents which we use and we would like to sequentially number each time the document is opened and printed.
For example:
DOC-YY-1
DOC-YY-2
DOC-YY-3
Where “DOC” is a fixed prefix and “YY” refers to the year: i.e., 11 and the 1 is a sequential number.
Would it be possible to embed the “1”, the sequential number in the document so that each time the document is opened, it increments the number and after it is printed, it saves that number.
For example, let’s say the last time it was printed, it had 8, and the next number would be 9. After it is printed, “9” is saved… and so on.
Also, it would be nice, if Word 2007 was able to prompt the end-user for the quantity of documents required. So the program can do multiple copies.
Is this something I can do solely in Word 2007 using VBA or would I have to use an external program?
Thanks in advance for your assistance.
 

A:Sequential Numbering in Word 2007

This can be achieved in VBA and probably wouldn't be too much work either. Have you used VBA at all before?
 

Read other 1 answers
RELEVANCY SCORE 75.6

Hello,

I would like to create a formula that searches a cell in column B that contains "***patient subtotal," and then returns a number in column A if that formula is true. However, I would like there to sequential numbers in rows below where the formula is true.

For example
Column A Column B
1 ***patient subtotal
2 ***patient subtotal
3 ***patient subtotal

I used the formula below, but it doesn't work. May you please help me?
=IF((SEARCH("***patient subtotal",B22)),ROW())*1-countif($B$22:B22,0))),"***patient subtotal","")
Thanks!
 

Read other answers
RELEVANCY SCORE 74.8

Hi

I'm trying to design a little receipt for my part time hobby/business and would like to have a sequential receipt number thats automatically updated in the receipt number cell (currently G1).

Also I have a macro that clears the filled boxes by copying blank cells on top of them and thus wiping them, is there anyway I could use this macro to wipe the receipt but also update the receipt number?

Hopefully that makes some kind of sense!

Thanks in advance for any help

Dan
 

A:Sequential receipt numbering in Excel 2000

No need to do the copying blank cells thing, nor get too complicated if it's just a small personal project. Something as follows should suffice:

Sub ClearReceipt()
Range("B2", "B4").ClearContents
Range("G1") = Range("G1") + 1
End Sub
 

Read other 2 answers
RELEVANCY SCORE 74.4

Excel 2007 for PC

Rookie Excel user requesting help writing a macro that will overwrite information in one column, based on information in a second column. See attached file.
 

A:Solved: Macro that overwrites info in 1st column based on info in a 2nd column

Read other 7 answers
RELEVANCY SCORE 73.2

I need some help. I am trying to come up with a formula that counts the times that a "string" occurs based on a value in another column.....
Example:
Everytime column a = "Jones", check if column e = "tom".....if so count it.
 

A:Counting strings in one column based on Condition in another column in Excel

The EASY way to do this is to concatenate columns A and E using (for instance) this formula:

=A1&E1

or

=A1&" "&E1 (puts a space between two words)

Then count the individual field. Make sense? Will it work for you?

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

Read other 3 answers
RELEVANCY SCORE 72.4

I have a database that i'm creating that has 3 different tables. Its for safety violations at work. One table is the innitial one that has all the pasic information on it. I set it up so that it automatically assigns a number to each complaint filed. The other two are for follow up. One is for how the problem is going to be fixed and who is supposed to do it, And the other one is for verification to make sure that the problem has been fixed. My problem is that i want the two follow up tables to automatically import the complaint number when a new complaint is filed. I tried to set everything up myself, but had no luck. Can someone please help? Thanks.
 

A:Solved: update the column in one table based on the column of another table

Read other 16 answers
RELEVANCY SCORE 72.4

I have an Excel 2003 spreadsheet that has three columns that are populated by dropdown lists. I have attached a sample based on my real problem for you to see. Depending on the selection in Column A there could be a required entry in column B or a required entry in column C or it may require that an entry be made into either B or C. If an entry is made in column A and none made in B or C then I need a message box to pop up to remind them to make the additional selection. Thanks in advance for your assistance.
 

Read other answers
RELEVANCY SCORE 71.2

Hello,
Is it possible in one cell to show the total of both the column and the row? The idea is that it would be a double check because they should add up to the same thing. I am working with Windows 2007.
Thanks.
 

A:Solved: adding row and column in same cell

Read other 9 answers
RELEVANCY SCORE 71.2

I have a very large spreadsheet with thousands of rows and about 20 columns
Col A has either of 4 values North, South, East, West
The other Cols have numbers
I want to get a total for North, South, East, West for Col B, C etc
Is there a formula I can use something like (if Col A = North , total ColB is )
Don't want to keep resorting by Cola and putting in Subtotals
Hope I have explained it well enough

Thanks

Brian
Dublin, Ireland
 

A:Excel Total in a column based upon value in another Column

yes you can use
SUMIF()

SUMIF(A:A, "north", B:B)

OR if you put the values North, South etc into a new column - Say Z2,Z3,Z4,Z5

SUMIF(A:A, Z2, B:B)
and copy down

if not - please upload a sample
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
 

Read other 3 answers
RELEVANCY SCORE 70.8

Not sure exactly how to word what I am trying to accomplish. for each matching cell in Column A, evaluate the values in Column B for matching rows. In the example spreadsheet, I have highlighted the ones I want vba to evaluate. The column can also be as large as 5000 rows at times. So for Dayton, at least one % is 0 and one is more than 1%. In that case I want the 0% highlighted. Same for Los Angeles and Annapolis which has 4 matching rows. However, I don't want Sacramento and Mobile 0% value highlighted because the value(s) are all below 1% each. I don't even know where to start on coding this. Any help is greatly appreciated.
 

A:For each matching cell in column A, evaluate Column B value

Read other 6 answers
RELEVANCY SCORE 70.8

Currently I have 83 products listed in one table in Access and a huge listing of people who use those products in another table. When I run a query to find all the ones who use the products listed I get 58113 connections.
What I would like would be to randomly select 10 to 20 users of each product (the minimum number of users for any one product is 10, but the maximum is over 3000 for the most used product. I would then like to export these randomly selected names to different Excel worksheets in the same workbook - I suppose one could export them all and then break up the data into new worksheets based on the product code....

Oh, and there are 10 products for whom there are no listed users, so I will have to match them up by their reporting districts instead and then select 10-20 as well...(I have run a query for this and the smallest group this way is 15 people.)

Thanks in advance!
 

A:Solved: Select some listings based on one column - need VBA

Read other 7 answers
RELEVANCY SCORE 70.4

I am trying to loop through a column and where there are blanks look up the value with vlookup. Initially I tried looping until cell is blank but of course that stopped the loop at the first blank. I changed it to loop until last row and column but I am sure I am not using the right syntax to do it. It loops great through row but continues past the last row. Any help is appreciated.
Code:

Dim UsedRng As Range, LastRow As Long
Set UsedRng = ActiveSheet.UsedRange
LastRow = UsedRng(UsedRng.Cells.Count).Row
Range("H2").Select
Do
If IsEmpty(ActiveCell) Then
ActiveCell.FormulaR1C1 = "=VLOOKUP(LEFT(RC[-7],8),Sheet1!C1:C3,2,FALSE)"
End If
ActiveCell.Offset(1, 0).Select
Loop Until ActiveCell.Cells(LastRow, 8)
 

A:Solved: Excel VBA Loop Until Last Cell in column

Code:
Dim UsedRng As Range, LastRow As Long
Set UsedRng = ActiveSheet.UsedRange
LastRow = UsedRng(UsedRng.Cells.Count).Row
Range("H2").Select
Do Until ActiveCell.Row = LastRow + 1
If IsEmpty(ActiveCell) Then
ActiveCell.FormulaR1C1 = "=VLOOKUP(LEFT(RC[-7],8),Sheet1!C1:C3,2,FALSE)"
End If
ActiveCell.Offset(1, 0).Select
Loop
End Sub
You need the until element at the start of the loop and you want the loop to end having processed the last row.
 

Read other 2 answers
RELEVANCY SCORE 70.4

I have a column of data that will be updated weekly with more data. I reference the last value in the column (which is the most current value of the column) using this formula:

=VLOOKUP(9.99999999999999E+307,'Sheet1'!G:G,1,1)

The column is column 'G' obviously.

In another cell, I would like to reference the cell 52 rows above that one (a year ago) and possibly take the average of the values inbetween as well. Any ideas?

I played around with a match/offset but I just got lost.
 

A:Solved: Referencing Cells Above the Last Cell in a Column

Read other 15 answers
RELEVANCY SCORE 69.2

In an existing report, I need to have a count of records that have a certain text in a particular column. How do I create this command?

Example: Need a count of records in column B that have the word "yes" or "no". So I need a count of how many yes's and how many no's. I need a count for both.
 

A:Solved: Access07 - Count records based on column text

Read other 10 answers
RELEVANCY SCORE 68.8

I have a spreadsheet that needs numbers in the far left column to track row data. Some rows have data, while others are skipped. I need to be able to number the rows sequentially without numbering empty rows. Any idea how? What if I need to insert a row - would the solution resequence?

Thanks!
 

A:Nonsequential column numbering

Why do you have empty rows? What's the point?
 

Read other 2 answers
RELEVANCY SCORE 68.4

Hi guys,

I've attached the dummy file. You see the report groups all the relevant data pertaining to the person's name and puts it under the name of the person. I need a macro that will copy the name of the person in column A across all the rows of data pertaining to the person's name in column Z. I will not know which row the name of the person will be in or how many rows of data each person will have, so the macro needs to search through all the rows to find specific names.You'll see an example of what I need in column AA.

I then wrote a macro just based on reading in the net to remove the blank rows in column A. For example A6 is blank, so the macro I wrote deletes that column. The macro also deletes the "Total No. of Cases" row.

This is the macro:

Sub Deletejunk()
'
' Deletejunk Macro
' To delete rows containing *No. of Cases* & Blanks
'
' Keyboard Shortcut: Ctrl+Shift+O
'

With ActiveSheet
.AutoFilterMode = False
With Range("a1", Range("a" & Rows.Count).End(xlUp))
.AutoFilter 1, "*No. of Cases*", xlOr, ""
On Error Resume Next
.Offset(1).SpecialCells(12).EntireRow.Delete
End With
.AutoFilterMode = False
End With
End Sub
I would like that after the previous macro copies the names to column Z this macro could run straight after that. Even better if this macro could delete those names in column A. I'm thinking we would then have to make an array of things to... Read more

A:Solved: Macro to copy text from a cell to a column with specific criteria

Read other 8 answers
RELEVANCY SCORE 68.4

Hello,

I cant seem work out a solution for what I'm trying to do. I have an Excel workbook that has multiple sheets. On sheet 1 i want the data from cell "G3" to be copied onto sheet 2. But i want the location on sheet 2 to be based on whatever was entered into cell "D3" on sheet 1.

For example: Sheet 1, cell D3 I have the name John, in cell G3 i have 68. I want "68" to be pasted in sheet 2 in cell B26.

But if the name in Sheet 1 cell D3 is Suzie, then I want G3 to be pasted in Sheet 2 in cell D26. So I would need to identify the paste location for each person.

I want the data to paste to the next cell so that the next entry can be pasted below the last entry for that person (for John the first entry would go into cell B26, then the next entry would go into cell B27 and so on).

But i want it to be a specific range, i dont want data to be pasted past 20 cells (cell B45). If possible a message box could be created to let the user know that the max is reached.

I would appreciate anyone's help with this as i have been struggling for awhile to try to get this. Thank you
 

A:Excel - Copy paste cell into range based on another cell

Read other 12 answers
RELEVANCY SCORE 68.4

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 68.4

I have a sheet set up with the list with the description (text) in column B, and summary scores (numerical, percentage) in column D. I want to do a summary row at the top of the sheet that pulls the data from the B cells, based on the lowest 3 values in column D.
 
I plan on using the formula =SMALL(D7:D32,1) (with d7:d32 being the list of percentages), to figure out the lowest 3 values. But the formula just pulls the summary score, not the description. I want to pull the description into but I am at a loss.
 
I am using excel 2013 on windows 10. Any help would be appreciated.

Read other answers
RELEVANCY SCORE 67.6

Hi guys,

Can you please help me further expand the macro below? I need it to also look between the ranges of C24 and Z24 and hide the respective column. (i.e need some sort of loop)

i.e

if C24 is 0, then hide column C
if D24 is 0, then hide column D
etc...
Sub Hide_Column ()

If Range("H24").Value = 0 Then
Columns("H").EntireColumn.Hidden = True
Else
Columns("H").EntireColumn.Hidden = False
End If

End Sub
 

A:Solved: Hide Columns based on value of cell

Read other 9 answers
RELEVANCY SCORE 67.6

Hey all:

I'm have really no experience with coding, so I'm out of my depth trying to do this myself. Hopefully someone can help, so here goes!

Essentially, my excel sheet keeps track of dates of when files need to be renewed. They need to be renewed every 60 days. So I have an "IF" formula that tells me if it's time for renewal.

What do I need to do to get an email notification whenever a file comes up for renewal? I've attached a sample sheet.

Best,
Nick

PS.
Using Excel/Outlook 2010
ClickYes Pro is installed (don't know if it will be necessary or not)
 

A:Solved: Emailing from Excel Based off Cell Value

Read other 16 answers
RELEVANCY SCORE 67.6

Does anyone know a way to manipulate the countif formula to count how many cells are "green" or "red" (with varying text in each cell), rather than the value of the cells?

Can this be done in VB?
 

A:Solved: countif based on cell format, not value?

Read other 10 answers
RELEVANCY SCORE 67.2

I have inherited a long document which consists of a table with multiple rows and two columns. The first column consists of numbers (1 - 207) which just serve to number the items in the second column. Problem is that a few of the items (whole rows) have been deleted which now means the numbers running down the first column are no longer consecutive. (Each item has its own row). I thought I could highlight the first column right throughout the document, press delete, then press the automatic number icon on the Formatting toolbar. When I did this only the column for the first page was highlighted.

Is there a way to highlight the first column right throughout the 10 pages of the document and perform the above actions to get it all consecutive again?

Thanks for any help - Julie
 

A:consecutive numbering in Word 97 table column

It sounds to me like it isn't one continuous table.

One way to check this is to click anywhere in the first cell in the relevant column, then select Table -> Select -> Column on the menu bar.

Scroll down the page and see if the whole column is highlighted. If not, then the table is probably split.

I tried to recreate this with two tables and got it to work by selecting the first column in the first table, then the first column in the second table by holding Ctrl. Clicking autonumber worked for me in this instance....

If the tables aren't split, all i can suggest is trying to highlight the relevant column first by clicking in the first cell and following the steps above (Table -> Select -> Column) and then hit autonumber.
 

Read other 3 answers
RELEVANCY SCORE 67.2

My workplace currently uses an excel sheet for what are called "Daily Logs." These logs are printed approximately one month in advance, and they each are required to have the workday printed on them (i.e. Tuesday, May 1, 2012; Wednesday, May 2, 2012; etc.- excluding weekends and holidays). I was wondering if there was a way to have a dialog box to choose what days of the year you want to print the sheet for, and then, the spreadsheet would print those dates (one date per sheet).

Is this possible?
 

A:Print sequential dates represented in one Excell cell

you could use a user form with a list box that populates all the dates available in the workbook. then the use can check which ones they want printed and hit a print button
 

Read other 3 answers
RELEVANCY SCORE 67.2

I am trying to hide rows of my worksheet that show a date in the completed column.
The orders that are complete have a date in column F up to this point I highlight them green so I know they are completed but it would be nice if they highlighted green and were hidden when a date was entered into the completed column.
Can someone assist me with creating a macro that will do this?
I am very new to macros so please forgive my lack of knowledge.

I have attached a sample of what I am doing however inf has been changed.

I am using Excel 2007

Thank you,
 

A:Solved: Macro for excel 2007 to hide rows based on any data entered in a column

Hi, welcome to the forum,

I put some simple code in the Sheet's vba

Make sure you allow macro's to be run

Just enter a date in the last row of column F for testing.

For the other green rows, just click in column F and update the date by retyping it
 

Read other 3 answers
RELEVANCY SCORE 66.8

I know that this is probably a pretty trivial problem, but I can't seem to come up with the answer. I am trying to set the selection focus to a cell in a column, based on an offset variable. The following is a little macro that I created to experiment with. As written, it positions the selection focus on cell C6. But I can't find the way to set it to C6 + Offset. The only reason for the MsgBox statement is to prove that I passed the argument as expected.

Sub MvTo(ByVal Offset As Long)

Range("C6").Select
MsgBox "Offset " & Offset

End Sub

I thought I could use RnCn cell references and write something like Range("R6[+Offset]C3").Select, but I get an error return, so I'm missing something somewhere. Run-time error '1004', Method 'Range' of object "_Global' failed.

I am using Excel 2000.
 

A:Solved: Set cell selection based on a variable offset?

Read other 6 answers
RELEVANCY SCORE 66

i have a spreadsheet that updates with data from a number of different sources. i need to filter only the relevant data that i need. i'm almost there but need to find out how to pull 2 more pieces.

in the attached spreadsheet the cells i need are in column R and T. I need to know the corresponding "name" and "size" of the data that is in column S.

unfortnuately the actual values don't show up in the spreadsheet b/c they are live data feeds but the formulas written up until now are still there.

in a nutshell what i'm doing is getting 5 price feeds and i need to filter out which is the highest updated within the last 2 minutes. i actually have the only the price figured out in column S, but i also now which name and how big the size is related to that price.

your help is very appreciated.

regards,
 

A:Solved: excel - data returned based on the value of a specific cell

Read other 10 answers
RELEVANCY SCORE 66

I have an excel sheet with two tables for customers to know which products the customer is using based on a Contract table.

The enclose sheet has two tables:
1. Customer
2. Contracts

All what I need is to fill the columns of "Product A", "Product B" and "Product C" of every customer looking at the table "Contracts" where the data is available based on the "Customer ID"

How can I do it?
 

A:Solved: MS Excel / Filling a cell with YES based on data from another sheet

I would just use a simple countifs formula to check if the customer ID and Product type match (ie the count of matches is greater than zero)
See attached.
 

Read other 3 answers