Over 1 million tech questions and answers.

Data from one excel into another by using predefined rows

Q: Data from one excel into another by using predefined rows

Hello,

I am in need of a Excel tool (may be VBA/Fucntion..) where in I get the data from a spread sheet into another based on the 3 cells of a row.
EX: Excel 1 is having 3 columns defined (A, B, C) & each row in these columns will have predefined numbers as shown below:
Using these I need to get the data from Excel 2 (where we have the columsn A, B, C) for columns D, E....
Compare row 1: X1,Y1, Z1 in excel 1 & excel 2 to get cells D1, E1& F1 data to be filled from Excel 2.

RELEVANCY SCORE 200
Preferred Solution: Data from one excel into another by using predefined rows

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: Data from one excel into another by using predefined rows

Read other 13 answers
RELEVANCY SCORE 86

Hi There

It has been quite a while since I asked for help. I wonder if the following is doable as an Excel macro. The attached is only a demo with only 2 fields and a few rows of data. The real worksheet has more fields and around 3,000 rows.

Sheet 1 contains the data in its initial state and sheet 2 contains data after the macro is run. You will see from sheet 2 that the field labeled QUANTITY determines the number of rows to insert and copy the correct data into those inserted rows. I want the entire row to be copied down as opposed to only the data, since I have more columns than shown here. Is this possible to do? Can anyone help me with writing a macro, since I have over 3,000 rows to do.

Thanks for all your help. You guys are fantastic.

Mario
 

A:Inserting specific number of rows in Excel and copying data in those inserted rows

Read other 14 answers
RELEVANCY SCORE 74.4

Not sure where to post this; hope I found the right forum.

I have a set of texts in the source language in Excel. I have translated these into the target language. What I now want to do is match the source language data with my translations.

Is there any way to tell Excel that "when the text XXX is in column G, row 341, the text XXX is to be inserted into column H, row 341)?

Just an example.

In other words, what I want to do is make sure my translations are placed in the column to the right of each source language text.

Regards
Mattias
 

A:Excel, matching data in rows

i have moved to business applications

in column H you can use IF

in H341
=IF(G341="XXX", G341, "what to do if not")

this will copy G341 into H341 only if G341 contains "XXX"

OR
=IF(G341="XXX", "YYY", "what to do if not")

if what you want inserted is different text
 

Read other 1 answers
RELEVANCY SCORE 73.6

I'm new to macros. Is there anyone who can sort information in an infinite number of columns and an infinite number of rows by information contained in each row? Some rows will contain only one column and others will have several columns.
Additionally, after the sort, I would like to total the number of like rows and insert that total in column "A" in the front of the rows, deleting all but one of the like rows. Also, there is data in parentheses that I would like to add together, per row and insert the sum in column "B" at the front of the row.
I have attached before and after files.
Thanks for any help. I have spent a lot of time trying to figure this out, but I'm not savvy enough to do it. And if I didn't explain this well enough, I'll try to clarify. Westcap
 

A:Sorting and addition of data in rows, Excel

Read other 16 answers
RELEVANCY SCORE 73.6

Hi

(A)
does anyone know how to search for the text content of a cell through a column and then return the value/content of the cell of a certain other column of the same row where the text content was found?
e.g.

A1 B1 C1 D1
2 013004T XY
3 092004TP YZ
4 012004TP ZY
5 052004P YX
6 092004TP YY [FORMULA]
7 072004TP ZZ
>>FORMULA: "Look for string '092004TP' in column A (other than in row 6) and return the value of that row in column C (C3=YZ)."
NOTE: There might be more than 1 row with the string '092004TP' in column A - I would need the sum of all results in column C where the FORMULA finds this string.

(B)
I also have a similar problem with another worksheet:
It would require a formula which searches through a whole column for certain names, e.g. "Donna", and then returns the value of another column in the same row where it found "Donna"; the value, again, is not in a column directly adjacent to the column where "Donna" would be found.
This is fairly identical to problem (A), except that the search string would be unique (only 1 result), and it doesn't have to take into account (and disregard) if the string was found in the same row of the FORMULA (the search column would be in a different worksheet from the FORMULA worksheet).

Thanks for any suggestions!

Cheers
from New Zealand

Andreas
 

A:EXCEL Searching Data in Rows/Columns

Read other 7 answers
RELEVANCY SCORE 72.8

I have a excel file like below.

Column1 |Column2|Column3|Column4|Column5|Column6|Column7
Row 1 EEEE 1 2 3
Row 2 4 5 6

I want to move data in row 2 (4,5,6) to Row 1 columns 5,6,7.

Could you help me with an excel macro to automate this as i am working with a large number of records like this in one excel sheet. i.e, i want to select the sheet and move data in every 2nd row to the columns in row above at the end of columns in that row.

your assistance is greatly appreciated.

thank you
 

A:Excel Macro to Move data in Rows to column

Read other 8 answers
RELEVANCY SCORE 72.8

If you check the file attached.

please can you help me in moving data with duplicate names to have the 2nd and 3rd email address moved to a new column and delete the row

need an excel macro to automate this as i am working with a large number of records like this in one excel sheet. i.e, i want to select the sheet and move data in every 2nd row to the columns in row above at the end of columns in that row.
 

A:Excel Macro to Move data in Rows to column

I'm unable to understand the entire requirement, but for moving the records with duplicate names, I've written few lines. This will cut the duplicate record rows (Consider "Pupil Forename" for removing)from the "Report Data" and will post into "Sheet3". Before running this macro please insert "Sheet3". Let me know your requirement, hope I will be able to resolve it out. Thanks!

Code:
Sub test()
Sheets("Report Data").Select
Dim trow As Long
trow = ActiveSheet.UsedRange.Rows(ActiveSheet.UsedRange.Rows.Count).Row
For i = trow To 1 Step -1
If i = 1 Then
Exit Sub
End If
If Cells(i, 1).Value = Cells(i - 1, 1) Then
Rows(i).Select
Selection.Cut Destination:=Sheets("Sheet3").Range("A65536").End(xlUp)(2)
End If
Next i
End Sub
 

Read other 2 answers
RELEVANCY SCORE 72.8

We have a survey package which is great, but it out puts the questions numbers over the columns and each new row is a response, however our calculations are setup for the question numbers to be the rows and the responses are the columns. Is there any way to swap these values around in this fashion? Thanks for any help
 

A:Excel: swapping columns and rows layout of data?

Howdy. You can copy the data, then Paste Special > Transpose
 

Read other 2 answers
RELEVANCY SCORE 72.8

Hi,

I'm trying to get a Word doc (a meeting agenda) to populate using data from an Excel sheet and have run into a couple of challenges. I have Word 2010 and Excel 2010 and am currently using labels and fairly basic coding via Developer in Word. I feel like there is likely a way to do what I'm trying to do but unfortunately haven't been able to figure it out - and haven't had much luck online. So I'm hoping you might be able to help!

I'm including a description of the challenges I've run into below along with an image of the spreadsheet and the coding I'm currently using. Any help at all would be really appreciated!! If there is any other info I can provide that would be helpful, please let me know.

Thanks so much,
L

Challenge 1: Is there a way to make the data area in Word automatically grow to accommodate the text from Excel? One of the items I'm including is comments, which could range from three words to 10 lines. It seems like the only two options with a label is for the data to be partially cut off (using wrap), or for it to resize itself. I'd like to have the field in Word automatically extend if needed to fit all the text. Is this possible?

Challenge 2a: While I have coding that works to draw the data in, I'm hoping that there is a way to do it without having to manually update the coding for all 200+ line items in the Word doc. Right now the Excel Spreadsheet has about 300 rows and 60 columns - it is genera... Read more

Read other answers
RELEVANCY SCORE 72

I would like to get a script going that checks column A in an Excel spreadsheet with the contents of another file. The other file can be separate Excel file or a txt file. The script would delete the entire row of data in the main spreadsheet when the data (string) in column A matches anything listed in the txt (or other Excel) file.

I'm a real beginner and appreciate any help you can give me.
 

Read other answers
RELEVANCY SCORE 72

I'm a novice excel VBA macro user. I've manipulated already created macros, but I'm not sure how to create one from scratch. Can someone please help me create a macro.

I'd like to move the values highlighted in yellow to the cells highlighted in green...and then delete any rows that are empty.

Thanks in advance for the help.
 

A:Solved: Excel Macro to Move Data in rows to columns

Read other 9 answers
RELEVANCY SCORE 72

In Excel 2007, I have a spreadsheet with 14 columns. Twelve of the columns contain categories of data that correspond to the entries in the other two columns. I need to change the list so that each item/amount in each category occupies its own row, as follows:

Eg.

From this:

col1-----col2-----category1-----category2-----category3-----etc... up to 12 categories
aaa------bbb---------------------$55
ccc------ddd------$44--------------------------$66
To this:

col1------col2------category------amount
aaa-------bbb------2-----------------$55
ccc-------ddd------1-----------------$44
ccc-------ddd------3-----------------$66
I know how to do this manually, but it needs to be done frequently on many different sheets. So, I need a way to do it automatically.

Many thanks for your help
jeannie
 

A:Excel macro - change column data to multiple rows

I have your data mapping from A:N to P:S, with no headers. In case that's wrong, make sure your work's saved before trying this.

Sub test()
LastRow = Range("A" & Rows.Count).End(xlUp).Row
For i = 1 To LastRow

For Each Cell In Range("C" & i & ":N" & i)
If Cell <> "" Then
DestRow = WorksheetFunction.CountA(Columns(16)) + 1
Cells(DestRow, 16).Resize(, 2).Value = Cells(i, 1).Resize(, 2).Value
Cells(DestRow, 18) = Cell.Column - 2
Cells(DestRow, 19) = Cell.Value
End If
Next Cell

Next i
End Sub

HTH (welcome to the board)
 

Read other 2 answers
RELEVANCY SCORE 72

I have a spreadsheet that has is basically ready to be converted to a .csv file, It is basically a list of items that I want to convert to a csv file so I can import into our ERP system.

The problem is I have some items with 0 qty on it and I do not want those rows going into our ERP system. I want to clean this up before I convert to a csv file.

Sample
Items # Qty
1121 1
1470 0
1569 2

I just want
Items # Qty
1121 1
1569 2

Is there a macro that I can run that will do this for me?
 

A:Solved: Excel - remove 0/blank rows data for csv conversion

Read other 6 answers
RELEVANCY SCORE 71.6

I am looking for a way to insert rows automatically with a formula or some other function. I have large spreadsheets where the data will be the same in a certain column for two to 50rows. When that data changes in that column, I want a row inserted before the new data item. I've searched ?Help with no solution. Is there a way to do this so I don't have to go line by line looking for the data to change, then manually adding a blank row between the changed data?
 

A:Solved: Excel 2003 insert rows when data stops duplicating

Read other 10 answers
RELEVANCY SCORE 71.6

Hi everybody,

I upload an excel file to help understand my problem.
So I have date and time and in column 2 I have my parameter value.

Note 1) not all the data is at 04:30:00, and this is a huge problem in the macro I found online.

1-1-16 0:00 1
4-1-16 4:30 1
8-1-16 4:30 1
11-1-16 4:30 1
15-1-16 4:30 1

What I want to create is the missing data time, associated with a column 2 blank and not 0 if possible

So the final result should be like
1-1-16 0:00 1
1-1-16 0:01 "blank" (not zero if possible)
1-1-16 0:02 "blank"
...
4-1-16 4:30 1
4-1-16 4:31 "blank"

Thanks for your time
 

Read other answers
RELEVANCY SCORE 70.8

Hi everybody

I have got an hourly meteorological data for 10 years. The problem is that some of the data entries are missing. e.g.

23-April-2006 19:00
23-April-2006 20:00
23-April-2006 22:00
23-April-2006 23:00

I need to insert the rows for missing hours. Rest of the columns in the inserted row are needed to be blank. e.g.

23-April-2006 19:00
23-April-2006 20:00
23-April-2006 21:00
23-April-2006 22:00
23-April-2006 23:00

Please also note that for some years, the data entries are for half past hours. e.g.

31-Dec-2001 23:30
01-Jan-2002 00:30
01-Jan-2002 01:30
01-Jan-2002 02:30

Peace
Muhammad Zeeshan
 

A:Solved: Inserting rows for Missing Date/ Time data (Excel 2007)

Read other 16 answers
RELEVANCY SCORE 70

Hello-

While importing the essbase retrieved data from excel spreadsheet to access database using the folling Access VBA command, I get 65 K of blank rows into the table. This only happens for essbase retrieved data, other excel files works just fine. Is there a reason, and how can I prevent this 65 K blank rows? Please help. Thank you much.

VBA command to import excel data

DoCmd.TransferSpreadsheet acImport, nSpreadSheetType, "SPECTRUM_CALCULATION", _
cFileName, Me!ChkBox_FieldNames

Santosh
 

A:import essbase retrieved excel data to access table adds 65 K blank rows

essbase is probably using empty strings, which Access picks up as data. Instead of importing to a new table, set up your table with a primary key, one that corresponds to the Excel column most likely to have data in it every time. Set allow empty strings to no on that field as well. That should import only the "filled" records.
 

Read other 1 answers
RELEVANCY SCORE 70

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 70

I need a visual basic macro for excel 2002 that will do the following:

From sheet1:ColumnA
Select rows until sheet1:columnA value does not start with REC (as the no of rows is unbalanced, sometimes 7 rows, sometimes 10 rows, sometimes 8 rows, etc)
copy selected rows and transpose to sheet2:columnA to however many rows were selected

Repeat until end last row
My real table has 30000 rows and the rows are unbalanced

I am attaching a test file.

Please help me and thank you for your support and time.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Pentium(R) Dual-Core CPU E5300 @ 2.60GHz, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 2047 Mb
Graphics Card: ATI Radeon HD 4300/4500 Series, 1024 Mb
Hard Drives: F: Total - 99998 MB, Free - 30856 MB; G: Total - 205236 MB, Free - 153405 MB; H: Total - 305168 MB, Free - 180367 MB;
Motherboard: MICRO-STAR INTERNATIONAL CO.,LTD, G31M3-L V2(MS-7529)
Antivirus: None
 

A:Visual Basic Macro for Excel 2002 columns to rows in new sheet using unbalanced data

Can you also attach a second workbook showing how the data should appear after the macro is run?

Regards,
Rollin
 

Read other 3 answers
RELEVANCY SCORE 68.4

Hi I am trying to copy and insert rows based on a number in cell E. If the number in cell E is 4, I would like to copy 3 additional rows beneath the original and then also number the 4 rows into column F consecutively for each group. I am attaching a spreadsheet of before and after. Sheet 1 is the before and sheet 2 is the after. Can anyone help me with this. I have tried another code but it not work properly. I did find one that would put blank rows in but I cannot get past that. Any input is greatly appreciated.

Thank you

Peg
 

A:insert rows based on number in cell and copy the data down into the new rows

Hi Peg

Try this solution and see if it is ok for you. I've put in some code to help prevent the running of the code multiple times on the same sheet. If you don't need this safeguard you can delete the block of code that does this.

Also, make sure and make a backup of your file before running this - just in case.
 

Read other 1 answers
RELEVANCY SCORE 67.6

I do a weekly report that I base on results that I get with search done in Internet Explorer. I can then cut and paste these results into an Excel spreadsheet, but I need to delete most of the information (whole rows) and reorganize the remaining rows by taking the even numbered rows and putting them into the B column, then delete that Row as well. I have included some images that should help. A few more items:

1.)The information that I paste into the excel spredsheet may contain up to, but no more than 350 lines from the original copying source in Explorer (I'm not sure how many lines that translates into Excel)

2.) After every 20 records in Explorer there is a "top" link that gets copied, which needs to be taken into consideration when deleting the extra rows entirely

3.) Another way to look at this is that I ONLY want to keep the rows that have the 7 digit number a space then 2 more digits, as well as the rows that contain the price with the $ For instance the first record in my example I ONLY kept 8055312 11 & $70,000. The price will ALWAYS have a $ and the first set of number will ALWAYS have 7 digits first, no letters.

Attached is a jpg that shows the various steps, the last screen shot has a few of the cells highlighted in the upper left hand side. Those 6 highlighted cells is all of the information I need, and how I need it presented from the first 3 search records, the MLS number and the price.
Thanks!
 

A:Solved: Excel Question: Removing unwanted Rows, moving some rows to new columns

Read other 16 answers
RELEVANCY SCORE 67.6

I am having exactly the same problem as a closed thread. http://forums.techguy.org/business-applications/857921-excel-2007-table-filter-problems.html

Did anyone ever get to the bottom of it?

Basically, if I have a table in Excel 2007, and actually use the filter, it then breaks the autofilter.

I had a table with 6 rows, and it completely messed up.

Now I am down to 4. If I filter on 1, then 1 shows.

If I cancel the filter, only 1 to 3 show and row 4 is hidden. If I drop down the filter, row 4 does not exist.

If I unhide row 4, it is matterless. Excel 2007 's table shows it on screen, but it is no longer in the autofilter.

Filter by row 1, then row 3 disappears into hidden status, and drops off the autofilter. Rows 1, 2 and 4 now show (I unhid row 4, remember?)

BUT< the autofilter now only has row 1 in it. Rows 2 to 4 have been lost from the autofilter.

I need to be able to :
a)automatically add rows
b)filter by criteria
c)reference the table by row and column in calculations

Switching the autofilter off and on does not help. Converting it to a range means all my references went to pot, and also means that referencing and calculating sums breaks it automation. I am utterly depressed.
 

A:Excel 2007 table filter bug is hiding rows and losing rows from the autofilte

Ah well, Looks like I'm not the only one who had this problem. This article has a detailed explanation of what's causing the problem and a few possible workarounds: http://blog.contextures.com/archives/2010/03/19/number-the-visible-rows-in-excel-autofilter/

I found it thanks to http://answers.microsoft.com/en-us/...cel-2007/2364f944-18fa-482d-a1ac-db7464be0894
 

Read other 2 answers
RELEVANCY SCORE 66.8

Hi,

I couldn't find an answer in the Forums for this in the past half hour of looking through them- there are so many, and I need an answer sooner than in the 4 or 5 days it will take me to get through them in HOPES of finding my answer. Sorry. So could someone who knows Excel in Windows 7 help me?

I uploaded a bunch of keyword searches. Came up with 4 columns and anywhere from 100- 400 rows. I need to sort these in different ways. By Keyword so the spreadsheet is by alpha, then by Demand with highest at top/lowest at top, by Supply highest at top/lowest at top, and by Profitability highest/lowest. I know I can't do all at once, I am referring to different sorting methods.

Example: (you have to imagine 4 columns, and the numbers going under each column- when I saw the preview it bunched the numbers together and I can't seem to put them where they belong, but the first # goes under the second col (B), second # goes under "C", third # goes under "D" column:

COLUMNS:

A-----------------------------B-----------C-------------D

KEYWORD DEMAND SUPPLY PROFITABILITY
breathing exercises 7995 5306 1507
celebrations 8523 142301 60
cervical 10235 58395 175
chakra 28455 43099 660

My problem has been that in reading the instructions I don't understand how to do this (perhaps I'm just dumb!) so that each word will still have the "righ... Read more

A:Re: EXCEL- resorting rows so they each relate to original rows

When you sort in Excel, you select all of the rows and columns of the data to be sorted. When you apply a sort to one (or many) columns, all of the data on each row is kept complete and moved up or down.

Is that what you needed to hear?

Read other 7 answers
RELEVANCY SCORE 65.2

Hi everyone,

To help manage the department I work for (cleaning for a poultry processing plant) I am currently reviewing Quality inspection results which have been entered into Excel. It is about 30 pages long if I printed the full version out.

I am looking for someone to help with a mini program which will only print out the data rows which I need to review. Eg. If machine 1 (Row 20) was found to have not passed a check but machine 2 (Row 21) passed, then I would like to run a little program to only print Row 20.

As I am almost a novice at this stuff I'm was hoping that this may be a simple program and that someone might want to help me out. If it isn't or I am asking too much please tell me and I won't post anymore messages.

Thankyou for your time if you have read this message.

p.s - I did know enough to add a IF formula which tells me if the row should be printed or blank if it doesn't. I have been using that to review my data on the computer screen.
 

A:Solved: Help with Excel so when I print only revelent data (rows) print out??

Read other 7 answers
RELEVANCY SCORE 65.2

I'm trying to remove duplicative data from cells in a column based on information from another cell.

Example:

Col A Col B Col C Col D
Name1 Dept 1 Salary 1 Bonus 1
Name2 Dept 2 Salary 2 Bonus 2
Name2 Dept 3 Salary 3 Bonus 2
Name3 Dept 4 Salary 4 Bonus 3

In the above, there are 2 separate entries for Name2 because they were in 2 separate depts. My source data lists the bonus amount (Bonus 2) paid to Name2 but lists it twice incorrectly and I need to remove the duplicate so it should look like this:

Col A Col B Col C Col D
Name1 Dept 1 Salary 1 Bonus 1
Name2 Dept 2 Salary 2 Bonus 2
Name2 Dept 3 Salary 3
Name3 Dept 4 Salary 4 Bonus 3

Any help or ideas would be outstanding.
 

A:Removing duplicate data in a table without removing rows in Excel

Read other 6 answers
RELEVANCY SCORE 60

I have data that repeats hundreds of times. I am trying to put each string of data on 1 line.

f-name(A2) initial(B2) l-name(C2) ID#(D2) DOB(E2) Street(F2) company(G2)
City(F3) company#(G3)
State,Zip(F4)
Home Phone(F5)
Work Phone(F6)
Email(F7)

After the data is moved to one line I would like to delete the lines that previously housed the information. The company# can be deleted. I have never worked with macros. I would appreciate any help given.
 

A:Solved: move data from rows and columns to other rows and columns

bump
 

Read other 3 answers
RELEVANCY SCORE 59.6

Hello,

I need help to create an Excel macro that would

1. ask users to select x number of rows to be copied from one worksheet of one Excel file
2. once users have selected the rows to be copied, then the rows are copied from the one original Excel file into X number of target Excel files

Notes:
the target Excel files are all based on the same template
there is one worksheet in each of the target Excel files

in the target files, the rows should be copied from the first available empty row, going down

Looking forward to your help!

Thanks a lot.
Mzz
 

A:Macro needed to copy x number of rows from one Excel file into a batch of Excel files

Hi, welcome to the board.
Not much info there to get the correct picture.
Sample? Of source and template please
And not to forget, what version of Excel are you and the users using?
 

Read other 1 answers
RELEVANCY SCORE 55.2

Hi,

I want to know how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.

So that the excel size won't be that big and also it saves processing time.
 

A:Solved: Access data export into Excel as the data linked to excel.

Read other 16 answers
RELEVANCY SCORE 54.8

Does anyone know if there is a way to exceed the default worksheet length of 65536 rows?? I have a very large amount of data that I am currently having to analyze in pieces but would really like to do all at once. Any leads would be greatly appreciated.
 

A:Excel: Want More Than 65,536 Rows

Read other 7 answers
RELEVANCY SCORE 54.8

Hi all,
I have a sheet sent over to me weekly that contains approximately 1450 rows. Of these rows I have to remove specific ones then manually recalculate all the info.
The way the sheet is downloaded means there are no formulas in it when I get it so as you can imagine it is a long and tedius task.

What I am looking for is...
Is there a way to run a macro that can search for specific instances and then calculate this for me?

This is how the file I get sent is laid out...what I am really looking for is maybe a macro that can run through the file, find where column F has text and if it does, total up the numbers below.
The paste below is filtered to show anyone below 100%.

Region 1
154 138 89.61%
123

30 26 86.67%

name 1 Full-time 10 6 60%
124

40 34 85%

name 2 Part-time 2 0 0%

name 3 Part-time 10 9 90%

name 4 Part-time 10 7 70%
125

48 45 93.75%

name 5 Part-time 8 7 87.5%

name 6 Part-time 2 0 0%
126

36 33 91.67%

name 7 Full-time 2 1 50%

name 8 Part-time 2 1 50%

name 9 Part-time 8 7 87.5% Region 2
234 219 93.59%
127

40 28 70%

name 10 Part-time 2 0 0%

name 11 Part-time 10 0 0%
128

64 61 95.31%

name 12 Part-time 10 9 90%

name 13 Part-time 10 8 80% Region 3
204 187 91.67%
As you can see, the 123, 124, 125 and so on are store numbers, all of the figures are correct at the moment however once I remove the specific lines they won't be, for example if I remove name 10 then store 127 and region 2's figures aren't ... Read more

A:Excel sum rows

I have attached a demo file as the copy and paste did not work. I have also unfiltered the results to show every line not just those below 100%. Hopefully that will make it a little more clear.
 

Read other 1 answers
RELEVANCY SCORE 54.4

In my quest to develop macros to manipulate our data I am trying to find a way to delete all rows that do not contain data in column J. Any ideas of how I could select rows without having the specific worksheet in the macro?

Whenever I try recording a macro using the sort function, it specifies the one worksheet where I recorded it.
This is what it recorded:
ActiveWorkbook.Worksheets("Z011_15A").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Z011_15A").Sort.SortFields.Add Key:=ActiveCell. _
Offset(-98, 0).Range("A1:A159"), SortOn:=xlSortOnValues, Order:=xlDescending _
, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Z011_15A").Sort
.SetRange ActiveCell.Offset(-99, -9).Range("A1:X160")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
 

A:MACRO selecting rows that do not contain data in a particular row

Read other 8 answers
RELEVANCY SCORE 54.4

Hello Again

This is an Excel question. I have many rows in an Excel spread sheet that have duplicate data. These duplicate rows vary in content and in length each and every day. So far I have been deleting the duplicate rows manually. This task is now becoming time consuning. To make it easier on myself, I do a sort so that duplicates are all clumped together. For example I may the following in Columns A and B. Note, there are no spaces between different products.

000-00-001 product A
000-00-001 product A
.
.
.
000-00-002 product B
000-00-002 product B
.
.
.
etc and so on

I tried writing a macro to eliminate the duplicates only but it does not work properly. Can you help me on this one?

Mario
 

A:Deleting Rows that have duplicate data

Read other 6 answers
RELEVANCY SCORE 54.4

Hi - i am trying to write a macro to move data from some rows to columns, but its not a straightforward transpose. Attached is the example

and if there are any blanks not to transpose those.

Suggestions??
 

A:Macro column data into rows

Select your range of data to evaluate (in your attached example you would select C3:N12) and then run the macro below. The macro will create a new sheet with the transposed data.
Code:
Sub Transpose()

oldSheet = ActiveSheet.Name

Worksheets.Add().Name = "NewSheet"

Sheets(oldSheet).Select

For Each vcell In Selection.Cells

If vcell.Value <> "" Then

vRow = Sheets("NewSheet").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Row

Sheets("NewSheet").Range("A" & vRow).Value = Range("A" & vcell.Row).Value
Sheets("NewSheet").Range("B" & vRow).Value = Range("B" & vcell.Row).Value
Sheets("NewSheet").Range("C" & vRow).Value = Cells(2, vcell.Column).Value
Sheets("NewSheet").Range("D" & vRow).Value = vcell

End If

Next vcell

End Sub
Rollin
 

Read other 1 answers
RELEVANCY SCORE 54.4

Hey,

I have imported sales data in excel. The information lists in along two rows with mutliple columns. I need the information to be in one row under various headings. I have attached a link to a sample to explain this properly. I think I need to use a macro but I don't understand enough about them to make it work.

Any help would be much appreciated.
Cheers
https://docs.google.com/spreadsheet/ccc?key=0Av0-qDbMrH0rdHJWaWlReXd4RXptWlpwME50UTBsclE
 

A:Moving data from columns to rows

Read other 11 answers
RELEVANCY SCORE 54

Hello, new to excel vba, having a hard time to multiply the rows, i know this is a basic question but its not working for me any ideas guys ? how do i get this going
 

A:how to multiply rows in excel vba

Read other 13 answers
RELEVANCY SCORE 54

I have a lot of time series data, which includes date, time, latitude, longitude. Each date (dd/mm/yy) should have 15 time cells next to it, 1700, 1800, 1900, 2000, 2100, 2200, 2300, 0000, 0100, 0200, 0300, 0400, 0500, 0600, 0700. However, when the data was entered if there was no latitude or longitude entered, the row was skipped, and as such there are "holes" in the data. I would like therefore to enter a line where each row is missing so that ever day records the times given above, and N/A is inputted where no latitude or longitude was recorded. Any ideas?
 

Read other answers
RELEVANCY SCORE 54

Hi,
I'm manipulating a large file and want to insert rows programatically within VBA so that I can include sub-totals and also some other formatting to make the output look better. I'm using the Range(Cells(1,1),Cells(r,1)).Select method elsewhere (where 'r' is the row number), but this doesn't work when I come to defining a row where I want to insert additional rows.

Any help on how I can insert at rows at variable points from within VBA would be greatly appreciated!

rsb
 

A:Inserting Rows in Excel using VBA

One way to learn is to record a macro of you inserting rows.
 

Read other 2 answers
RELEVANCY SCORE 54

Hi again

Once again, I would like to thank all of you for your help in Excel programming. You guys are GREAT!!

I have another slight problem I need help with. I have a column, say column A, with text. Most of this text is repetitive in nature. I want to keep only the first 10 rows of the text that is repetitive and cut and paste the other repetitive text to sheet 2. Here is an example: Let us say that Column A has this text. I just used any text. The columns could have repetitive numbers as well. This is just an example.

qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
qwe
rty
rty
rty
rty
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio
uio

Etc down the column. This list is extremely long. As you can see form my example, there are 12 qwe's, 4 rty's and 13 uio's. I would like to keep only ten or less of each groupings and cut and paste those groupings in excess of 10 into sheet 2. In other words, when the macro is run, I would like to have 10 qwe's, 4 rty's and 10 uio's in sheet 1. Sheet 2 would then have 2 qwe's and 3 uio's.

I have tried to create a macro by myself but this is beyond my prgramming expertise. Any help woud be appreciated.

Mario
 

A:Counting rows in Excel

Read other 16 answers
RELEVANCY SCORE 54

I have some code that pulls data from two different worksheets onto one worksheet. The data looks like the following:

WS1

123
123
852
9637
5789
5789
159

WS2

123
123
852
9637
5789
5789
159

WS3

123
123
852
9637
5789
5789
159
123
123
852
9637
5789
5789
159

I need to come up with some code that will go through the A Column to delete the rowa that contain duplicates. So, once the deletion code has ran, WS3 should look like this...

WS3 (After Deletion Code)

123
852
9637
5789
159
123
852
9637
5789
159

Does anyone have any ideas? I have the code below, but it works only if data is pulling from one worksheet.
Code:

LastRow = ws.Range("A65536").End(xlUp).Row
For x = LastRow To 1 Step -1
If Application.WorksheetFunction.CountIf(ws.Range("A2:A" & x), ws.Range("A" & x).Text) > 1 Then
ws.Range("A" & x).EntireRow.Delete
End If
Next x
 

A:Excel -> Delete Rows

Forgot to mention that the deletion code needs to be universal. There will not always be data from WS2, so the code I posted above will work. I just need help creating a code that will work if there is data in WS2.
 

Read other 1 answers
RELEVANCY SCORE 54

How can I get the row numbers in an Excel worksheet to show and print?
 

A:Number Excel rows?

File > Page Setup > Sheet, put a check by Print-Row and Column Headings.
 

Read other 2 answers
RELEVANCY SCORE 54

I have formulas that has the data setup in rows (input). The next sheet is formulas that are in columns referencing these individual rows (output). When column A's formulas are dragged to column B, the references change as expected but to Sheet1!B1 rather than Sheet1!A2 (back to the rows). I think I 've done this before, but can't for the life of me remember how. Help me please and I'll be your best friend! (hey, it's the best I can do).

thanks,

drew
 

A:Excel Columns to Rows

Select all the cells involved

Right click anywhere on your selection and from the menu that pops up choose Copy

Click in the cell where you want the list to begin then Right click and from the menu choose Paste special you will now see another menu.

At the bottom right hand side of this menu, Select Transpose.

That's it your list will now run across the page instead of down
 

Read other 3 answers
RELEVANCY SCORE 54

I was given a txt doc that I opened in excel. This is a transaction log, and one transaction will have multiple rows. I need one row per transaction. There is one row that has M1- INFOGEN3 Tender Post Response is ACCEPTED (or DECLINED). Then a couple rows down it has M1- Ready to Post Tender for Check ID 179909...

I am hoping to at least have those two rows on the same line so I can search for DECLINED and get the check ID number. There's like 1080 of these things and going through one by one would be difficult.

Thanks for any help!!!!!!!!
 

A:Combining rows in Excel?

Read other 6 answers
RELEVANCY SCORE 54

We need to combine a report for the past 8 years. Each year is composed of 5 columns:

A) Department
B) Expenditure
C) Account title
D) Cost center
E) Amount

We want to make a new file with these columns:

A) Department
B) Expenditure
C) Account title
D) Cost center
E) Amount 2000
F) Amount 1999
G) Amount 1998
H) Amount 1997
I) Amount 1996...

The main issue is that the files (years) do not have the same amount of rows. There are some account titles and cost centers that were present on other years that are not present this year, and vice versa.

Copy and paste of the Amount will post them on different cost centers, since they will not fall on the correct row.

Any idea on how to make things easier?

------------------
"There are no stupid questions, just stupid people." -- Mr. Garrison on South Park
 

A:Excel - Merging rows

Could you possibly use Access and import these tables? You could then specify which field the column needs to go in to.
 

Read other 2 answers
RELEVANCY SCORE 54

I want my rows to automatically number beginning with #1, even though the data doesn't start until row 8. What formula would I use. (If I insert a row in the middle, would it keep the same numbering?)
 

A:Number Rows in Excel

sbudd said:

What formula would I use. (If I insert a row in the middle, would it keep the same numbering?)Click to expand...

=ROW()-7 (Yes)
 

Read other 2 answers
RELEVANCY SCORE 54

Hi,

I have a large excel database wich one observation is spread in several rows. For statistical purposes i need to place all the information of one observation in one single row.

attached a file with sample of my data and the layout i need to have.

Can anyone give an hand with this?

Thanks in advance,
bmoita
 

A:Multiple Rows to One Row - MS Excel

Read other 6 answers
RELEVANCY SCORE 54

stupid question time:

I have about 63000 excess rows in excel 2000 that have just junk, but no matter if I delete them or clear them they stay in the worksheet. How do I make them go away?
 

A:excess rows in excel

Read other 16 answers