Free Microsoft Excel 2013 Quick Reference

Macros to move multiple rows to one row.

This report spreadsheet is exported from SAP. Since SAP has a limit number of displaying the columns, there are 40 headings (= 40 columns) in the report has been broken down to 4 rows of headings. How to use macros to move 3 those extra rows to one row and the number still matches each column? I also attatch the file for reference. Very appriciate any help.


Post your answer or comment

comments powered by Disqus
I want to create a macro to move files from one server to another.
Basically, I'd want to move anything that has a .XXX at the end. I want to
move the files as listed in the active workbook and determine the number of
files to move based on the info stored in column A.
For i = 2 To Cells(Rows.Count, "A").End(xlUp).row

Next i

The directory location is stored in column B of my workbook.
(Y:abcfile.xxx)

Can someone assist?

Thanks,
Barb Reinhardt

Hi,
I need to create a macro to move variable multiple horizontal data to vertical format with certain infomation on horizontal will be duplicated following that variables. It's looks like below where you can see variables data in column F, G, H and I are moved vertically and at the same time column A, B, C, D and E will be duplicated following the variables allocation. I've tried to use transpose but it too manual and now looking suitable macro to help on this function

Original DataAccountDim 3Dim 4AmountCurrencyV20228V20242V20211V202044006003300BXXX 9.4USD0.591.923.343.554006003400BXXX 88.17USD5.5118.0331.3233.314006003500BXXX 7.27USD0.451.492.582.75Process to automateAccountDim 2Dim 3Dim 4AmountCurrency400600V202283300BXXX 0.59USD400600V202283300BXXX 1.92USD400600V202283300BXXX 3.34USD400600V202423300BXXX 3.55USD400600V202423400BXXX 5.51USD400600V202423400BXXX 18.03USD400600V202113400BXXX 31.32USD400600V202113400BXXX 33.31USD400600V202113500BXXX 0.45USD400600V202043500BXXX 1.49USD400600V202043500BXXX 2.58USD400600V202043500BXXX 2.75USD

Is there anyone can help?

Please Help me with some macro. I have tried hard but failed.

All I want is to - Delete Multiple Consecutive Blank Rows but leave with One Blank Row.

For eg:

ozgrid.com
ozgrid.com
.
.
.
ozgrid.com
.
.
ozgrid.com
ozgrid.com
ozgrid.com
.
ozgrid.com

Should be like:

ozgrid.com
ozgrid.com
.
ozgrid.com
.
ozgrid.com
ozgrid.com
ozgrid.com
.
ozgrid.com

The Dots (.) are Blank Rows

I will be very gratefull to you.

I am having a heck of time trying to figure this out. I need to move data from one row to the next four. This is for readability. Here is an example.

aaa bbb ccc ddd eee

I need it to look like this

aaa
bbb
ccc
ddd
eee

I can do this with insert and cut and paste but a macro would help a ton. I also need it to do this with about 500 rows of data. Its very repetitive so I dont think it would be to hard but hey I could be way off. Thank you to anyone who can help.

Hi,

I need a macro to update chart ranges every month, the concept is simple, I need to show in my chart always the last 3 months, but I can't figure how to do that kind of macro to move the range down on my table.

I tryied to record something with the macro recorder, but all it does is move the range down from rows 2, 3 and 4 to rows 3, 4 and 5.
Next month I'll need to move from 3, 4 and 5 to 4, 5 and 6.

HTML Code: 
Sub Macro1()
'
' Macro1 Macro
' Macro gravada em 2/3/2008 por !
'

'
    ActiveSheet.ChartObjects("Gráfico 1").Activate
    ActiveChart.SeriesCollection(1).Select
    ActiveChart.SeriesCollection(1).XValues = "=Plan1!R2C1:R4C1"
    ActiveChart.SeriesCollection(1).Values = "=Plan1!R2C2:R4C2"
End Sub


I need help with a macro to move rows to different worksheets. For example, If I put in Delivered, I want the row moved to a "Delivered" worksheet. If I put in Declined, I want the row moved to a "Declined" worksheet. I have been able to successfully get one of these to work at a time, but I need both of these to work in a single Macro. Help anyone? Here's the code I used to move one of them.

Option Explicit
Dim Flag As Boolean
Private Sub Worksheet_Change(ByVal Target As Range)
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row

If Flag = True Then Exit Sub
If Not Intersect(Target, Range("B2:B100" & LR)) Is Nothing Then
If Target.Value = "Delivered" Then

LR = Sheets("DELIVERED").Range("A" & Rows.Count).End(xlUp).Row + 1
Target.EntireRow.Copy
Sheets("DELIVERED").Range("A" & LR).PasteSpecial
Flag = True
Target.EntireRow.Delete
End If
End If
Application.CutCopyMode = False
Flag = False
End Sub

/close

Hi All,

I have a worksheet with a large number of rows of data. This is set out as follows:

Date Category Code Description Amount Number

7-Jun-2011 Legal Z530 Description 1 32,000 273645
7-Jun-2011 Legal Z846 Description 2 32,000 273645
7-Jun-2011 Legal Z935 Description 1 32,000 273645
7-Jun-2011 Legal Z935 Description 3 32,000 273645

What I need to do is merge all of the above 4 rows into one. The factor that is always the same is the number column on the end and the Amount. This means I would end up with the following:

Date Category Code Description

7-Jun-2011 Legal Z530,Z846,Z935 Description 1, Description 2, Description 3

Amount Number
32,000 273645

Obviously the above would all be on one row but it is difficult to type it on here. What I will also need is for the macro to do this for the whole sheet as the rows would continue down for around 7,000 rows. So every time there is a group of rows with the same 'Number' and 'Amount' they need to be brought into one row and where any data is different in the other columns it should merge into the final single row.

I really hope this makes sense and someone can help as it is quite hard to explain.

Thanks

Hi am Stuggling to work out how to set up this excel sheet. basicly i have created a sheet with excel which i want to use to help me remeber and log what i have down whilst taken calls in a call centre. there are basicly there i have created a drop down list for certain viables once i have done or not done some thing i want to be able to make it as done then save on another work sheet what i have recorded and reset the changed value back the way it was and change from call 1 to 2 ect logging each call . so it needs to move data from the main sheet to the next sheet and paste it into one row. then next time i click next call do the same but post it into the next row ect ect. the idea is i will be able to see how many times ive promoted a product and by it copying row by row which call i offered a product on ect

Hi all, I would like a simple macro that would actually move a cell based on criteria. In my case it would be:

In row A, if a cell starts with 'Agent Name' then that cell needs to move down one cell replacing the contents of that cell...

Hope that makes sense?

Macro to move rows, row by row, from one worksheet to another worksheet based upon specific criteria.

I need a macro that I can apply (to a rectangle click) to match and move rows from one work sheet to the corresponding row in another worksheet.

Conditions:
-Column A "Location" = Values are Unique
-All other Columns = Values are NOT unique
-A list of Contents is added to the worksheet "PullSheet"
-The "Get Pull Sheet" rectangle is clicked

1. The first, only the first, matching contents row in the worksheet "MasterLog" is moved (copied and then deleted, so it cannot be pulled again, from "MasterLog") to the corresponding row in worksheet "PullSheet".
2. If the MasterLog's "On Hold" column's value is "True", it does not recognize this row as an option to be moved to PullSheet.
3. Then goes row by row (Item by Item) doing the same thing.

The top 3 criteria are very important to me. If it is possible the next 2 would be very helpful as well, but not necessary.

4. If the Contents row in "PullSheet" does not have a match in "MasterLog" it should be highlighted Red.
5. If the Contents Row in "PullSheet" matches a (Location) that is a "Z?????" it should be highlighted Green after being moved to "PullSheet"

I have attached a sample workbook to see more clearly what I am referring to. Thank You All.

I am trying to write a macro to, among other things, hide multiple columns and selected rows. Everytime i record the macro and play it back it hides not just the columns and rows i selected to hide but everything. then it prints and unhides everything. Any and all help or ideas are much appreciated.

P>S If anyone would like to see the actual workbook message me and i will email it to you as it is to big to attach to this post.

Code Below


	VB:
	
 IRDPAYSLIP() 
     '
     ' IRDPAYSLIP Macro
     '
     '
    Rows("29:65").Select 
    Selection.EntireRow.Hidden = True 
    ActiveWindow.SmallScroll Down:=-30 
    ActiveWindow.ScrollColumn = 2 
    ActiveWindow.ScrollColumn = 3 
    ActiveWindow.ScrollColumn = 4 
    ActiveWindow.ScrollColumn = 5 
    ActiveWindow.ScrollColumn = 6 
    ActiveWindow.ScrollColumn = 7 
    ActiveWindow.ScrollColumn = 8 
    Range("A:A,B:B,F:F,H:H,I:I,J:J,K:K,L:L,M:M,N:N,Q:Q,U:U,W:W").Select 
    Selection.EntireColumn.Hidden = True 
    ActiveWindow.SelectedSheets.PRINTPREVIEW 
    ActiveWindow.ScrollColumn = 7 
    ActiveWindow.ScrollColumn = 5 
    ActiveWindow.ScrollColumn = 4 
    ActiveWindow.ScrollColumn = 3 
    Rows("5:5").Select 
    Range("C5").Activate 
    Selection.EntireRow.Hidden = False 
    Rows("4:4").Select 
    Selection.EntireRow.Hidden = True 
    Range("A1:W28").Select 
    Range("C1").Activate 
    ActiveSheet.PageSetup.PrintArea = "$A$1:$W$28" 
    With ActiveSheet.PageSetup 
        .LeftHeader = "" 
        .CenterHeader = "&""-,Bold""Hamburgers R US" 
        .RightHeader = "&""-,Bold""Sam Richardson" 
        .LeftFooter = _ 
        "&""-,Bold""H:Computers2011Unit 2785 Hamburgers 'R' Us" & Chr(10) & "Month Of July" 
        .CenterFooter = "" 
        .RightFooter = "" 
        .LeftMargin = Application.InchesToPoints(0.708661417322835) 
        .RightMargin = Application.InchesToPoints(0.708661417322835) 
        .TopMargin = Application.InchesToPoints(0.748031496062992) 
        .BottomMargin = Application.InchesToPoints(0.748031496062992) 
        .HeaderMargin = Application.InchesToPoints(0.31496062992126) 
        .FooterMargin = Application.InchesToPoints(0.31496062992126) 
        .PrintHeadings = False 
        .PrintGridlines = False 
        .PrintComments = xlPrintNoComments 
        .PrintQuality = 600 
        .CenterHorizontally = False 
        .CenterVertically = False 
        .Orientation = xlLandscape 
        .Draft = False 
        .PaperSize = xlPaperA4 
        .FirstPageNumber = xlAutomatic 
        .Order = xlDownThenOver 
        .BlackAndWhite = False 
        .Zoom = False 
        .FitToPagesWide = 1 
        .FitToPagesTall = 1 
        .PrintErrors = xlPrintErrorsDisplayed 
        .OddAndEvenPagesHeaderFooter = False 
        .DifferentFirstPageHeaderFooter = False 
        .ScaleWithDocHeaderFooter = True 
        .AlignMarginsHeaderFooter = True 
        .EvenPage.LeftHeader.Text = "" 
        .EvenPage.CenterHeader.Text = "" 
        .EvenPage.RightHeader.Text = "" 
        .EvenPage.LeftFooter.Text = "" 
        .EvenPage.CenterFooter.Text = "" 
        .EvenPage.RightFooter.Text = "" 
        .FirstPage.LeftHeader.Text = "" 
        .FirstPage.CenterHeader.Text = "" 
        .FirstPage.RightHeader.Text = "" 
        .FirstPage.LeftFooter.Text = "" 
        .FirstPage.CenterFooter.Text = "" 
        .FirstPage.RightFooter.Text = "" 
    End With 
    With ActiveSheet.PageSetup 
        .LeftHeader = "" 
        .CenterHeader = "&""-,Bold""Hamburgers R US" 
        .RightHeader = "&""-,Bold""Sam Richardson" 
        .LeftFooter = _ 
        "&""-,Bold""H:Computers2011Unit 2785 Hamburgers 'R' Us" & Chr(10) & "Month Of July" 
        .CenterFooter = "" 
        .RightFooter = "" 
        .LeftMargin = Application.InchesToPoints(0.708661417322835) 
        .RightMargin = Application.InchesToPoints(0.708661417322835) 
        .TopMargin = Application.InchesToPoints(0.748031496062992) 
        .BottomMargin = Application.InchesToPoints(0.748031496062992) 
        .HeaderMargin = Application.InchesToPoints(0.31496062992126) 
        .FooterMargin = Application.InchesToPoints(0.31496062992126) 
        .PrintHeadings = False 
        .PrintGridlines = False 
        .PrintComments = xlPrintNoComments 
        .PrintQuality = 600 
        .CenterHorizontally = False 
        .CenterVertically = False 
        .Orientation = xlLandscape 
        .Draft = False 
        .PaperSize = xlPaperA4 
        .FirstPageNumber = xlAutomatic 
        .Order = xlDownThenOver 
        .BlackAndWhite = False 
        .Zoom = False 
        .FitToPagesWide = 1 
        .FitToPagesTall = 1 
        .PrintErrors = xlPrintErrorsDisplayed 
        .OddAndEvenPagesHeaderFooter = False 
        .DifferentFirstPageHeaderFooter = False 
        .ScaleWithDocHeaderFooter = True 
        .AlignMarginsHeaderFooter = True 
        .EvenPage.LeftHeader.Text = "" 
        .EvenPage.CenterHeader.Text = "" 
        .EvenPage.RightHeader.Text = "" 
        .EvenPage.LeftFooter.Text = "" 
        .EvenPage.CenterFooter.Text = "" 
        .EvenPage.RightFooter.Text = "" 
        .FirstPage.LeftHeader.Text = "" 
        .FirstPage.CenterHeader.Text = "" 
        .FirstPage.RightHeader.Text = "" 
        .FirstPage.LeftFooter.Text = "" 
        .FirstPage.CenterFooter.Text = "" 
        .FirstPage.RightFooter.Text = "" 
    End With 
    ActiveWindow.SelectedSheets.PRINTPREVIEW 
    ActiveWindow.SmallScroll Down:=-12 
    Rows("23:25").Select 
    Range("C23").Activate 
    Selection.EntireRow.Hidden = False 
    Range("C67").Select 
    ActiveWindow.SmallScroll Down:=3 
    Rows("28:66").Select 
    Range("C28").Activate 
    Selection.EntireRow.Hidden = False 
    ActiveWindow.SmallScroll Down:=-9 
    Columns("C:AC").Select 
    Selection.EntireColumn.Hidden = False 
    Columns("B:B").Select 
    Selection.EntireColumn.Hidden = False 
    Columns("A:A").Select 
    Selection.EntireColumn.Hidden = False 
    ActiveWindow.ScrollColumn = 2 
    ActiveWindow.ScrollColumn = 3 
    ActiveWindow.ScrollColumn = 4 
    ActiveWindow.ScrollColumn = 5 
    ActiveWindow.ScrollColumn = 6 
    ActiveWindow.ScrollColumn = 7 
    ActiveWindow.ScrollColumn = 8 
    ActiveWindow.ScrollColumn = 7 
    ActiveWindow.ScrollColumn = 6 
    ActiveWindow.ScrollColumn = 5 
    ActiveWindow.ScrollColumn = 4 
    ActiveWindow.ScrollColumn = 3 
    ActiveWindow.ScrollColumn = 2 
    ActiveWindow.ScrollColumn = 1 
    ActiveWindow.SmallScroll Down:=-3 
    Rows("5:5").Select 
    Selection.EntireRow.Hidden = False 
    Selection.EntireRow.Hidden = True 
    Selection.EntireRow.Hidden = False 
    Rows("4:4").Select 
    Selection.EntireRow.Hidden = False 
    Rows("5:5").Select 
    Selection.EntireRow.Hidden = True 
    Application.ScreenUpdating = False 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


I am trying to figure out how to use a macro to move the data that is stacked up under the company name to the same row that the name is in.

So, move data from C1R2,R3,R4,R5 into C1R1,C2R1,C3R1,C4R1 and C5,R1.

The attachment has a few lines of the data for an example.

I have tried it on my own, done some searches, but macros don't like to work for people that don't know what they are doing.

Thanks for any help.

i have an order history spreadsheet that currently has one line per
item, with multiple orders for each item. i would like to move the data
with a vba macro to end up with one row per order. i would like excel
to check for text in each "orderqty" column in each row. if text
exists, copy columns a, b, and all 6 cells for that order starting with
"ordernum" to the first 8 cells in the first blank row at the bottom of
the sheet.

it should iterate to the right across a row for each column headed by
orderqty, and skip to the next row when it encounters the first blank
orderqty.

i guess i'll need two loops - one as it iterates across column headers,
and one as it iterates down the row.

for an example section of the spreadsheet, see my forum post here:
http://www.mrexcel.com/board2/viewtopic.php?t=227255

Hello all,

Trying to write a macro that will move and delete info within rows based on certain criteria.

In the Title column (marked in the row 1 header), if there are two titles that match and are sequential, the following happens:
- On the row containing the first instance of the duplicate title, the dates in the HB Start Date and HB End Date columns are moved into the Start Date and End Date columns (replace any existing data in these cells). The data in the Hdate and Gdate columns in this row is deleted.
- On the row below this (containing the second instance of the duplicate title), delete the Gdate, HB Start Date, HB End Date, and Hdate data in this row.

In the example attached, Title2 is a duplicate, so the macro will move the data in the two rows for Title2:

Would need to loop through several thousand rows. The columns are not always in the same column letters, which is why I’d like to use the header in row 1 to identify the columns. Also, there may be instances of triple titles that match. In this case, do nothing – the macro should only move dates if it finds only two sequential titles. If there are more than this in the Title column, then do nothing.

Please let me know if there are any questions. Help is most appreciated on this – thank you!

Question also posed at Mr. Excel: http://www.mrexcel.com/forum/showthread.php?t=535105

I know you all are probably tired of having to answer this question, but I have been looking for an answer to this question for well over a week on many sites including this one. I have used Excel for many years and am familiar with formulas, but this is the first time I am attempting to write a macro. Honestly, I’ve read a lot of the questions and answers to similar questions on this subject but I must confess that I don’t understand what I am reading. I even purchased a book over the weekend to help me, I just don’t get it. ANYWAY, if anyone can help me with the following situation, I would greatly appreciate it.

The scenario...

I have a workbook with several worksheets in it in preparation for an audit. One spreadsheet contains a population of 7000 rows with 25 columns of data. The first column (A) identifies the sample item, i.e., sample 1 or sample 2. I need to generate a macro to pull the sample 1 items and copy them to another spreadsheet with all 25 columns of data. I then need to repeat the same macro or another one to copy the sample 2 items to its own spreadsheet. I need to also make this button activated if possible or at least hot key it.

The spreadsheet with the large population is titled “totalpopulation”. The spreadsheet that will contain the sample 1 items is “sample1” and the one for the sample 2 items is titled “sample2”. There is a lot of header information, so the data doesn’t start until cell A10. I work at a defense company and thus cannot send a copy of the spreadsheet. I’m on my home computer now. However it looks something like this.

Spreadsheet totalpopulation

A B C D E F G

Cell A9 sample # Asset # Description part no cost location ……etc
Cell A10 2 123456 cart 245fg $100 texas
cell A11 1 256891 bike jkeop1 $25 ohio
cell A12 2 ad2135 pen 4586 $5 iowa
cell A13 1 999564 desk 256qw $45 Utah

Copy sample 1 items (rows/columns) to:

Spreadsheet sample1

Cell A9 sample # Asset # Description part no cost location ……etc
cell A10 1 256891 bike jkeop1 $25 ohio
cell A11 1 999564 desk 256qw $45 Utah

Copy sample 2 items (rows/columns) to:

Spreadsheet sample2

Cell A9 sample # Asset # Description part no cost location ……etc
Cell A10 2 123456 cart 245fg $100 texas
cell A11 2 ad2135 pen 4586 $5 iowa

I need button or hot keys to launch the macros, if possible.

I appreciate the help. I’m sorry I couldn’t figure this out from the other responses. I just don’t understand the language/terminology at this point.

Richard

I am reaching dead ends here. I have a worksheet (Sheet2) that has a REVIEW table starting in "B2" with information running from column B to X. There are "x" amount of rows that are filled based on user input, so my question is :

1) Is there a way to create a pointer of some kind positioned on Sheet 2 at "B2"?
2) Copy the data in "B2" and paste on Sheet 3
3) Return to Sheet 2 and move to the next column "C2", Copy, and Paste on Sheet 3.
4) Repeat this process until finally reaching column X.
5) Then, I need the pointer mentioned in #1 to move down to "B3".
6) Repeat steps 2-4 until reaching column X
7) Move the pointer down to "B4"
Repeat steps 2-4 until reaching column X

This process should repeat over and over (thinking Do While loop) until the reaching a cell in column B where there is no information, the last row with data.

Can anyone help with this problem. I am not even sure how to begin. I appreciate all the help I can get. Thank you in advance.

K_Man95

I need help designing a macro that can take data that comes in looking like this...

A - B - C - D - E - F - G
123 - 5 e. main st. - Anytown - IL - 60635 - emp1 - john smith1
123 - 5 e. main st. - Anytown - IL - 60635 - emp2 - john smith2
123 - 5 e. main st. - Anytown - IL - 60635 - emp3 - john smith3
123 - 5 e. main st. - Anytown - IL - 60635 - emp4 - john smith4
123 - 5 e. main st. - Anytown - IL - 60635 - emp5 - john smith5
321 - 1 e. main st. - Anytown - IL - 60635 - emp1 - john smith6
321 - 1 e. main st. - Anytown - IL - 60635 - emp2 - john smith7
321 - 1 e. main st. - Anytown - IL - 60635 - emp3 - john smith8
321 - 1 e. main st. - Anytown - IL - 60635 - emp4 - john smith9
321 - 1 e. main st. - Anytown - IL - 60635 - emp5 - john smith0

and moves and filters it so that it looks like this...

H - I - J - K - L - M - N - O - P - Q
- - - - - emp1 - emp2 - emp3 - emp4 -emp5
123 - 5 e. main - town - IL - zip - smith1 - smith2 - smith3 - smith4 - smith5
321 - 1 e main - town - IL - zip - smith6 - smith7 - smith8 - smith9 - smith0

So in the initial column F, the employee #s 1-5 will be constant throughout every set that comes in. Each set is 5 rows, and the number of sets varies from day to day. So I need the macro to move the data from the first 5 rows, and then the next 5 rows after that, and the 5 after that one, etc... basically until there is no more data (upto the blank row)

I have a basic "Copy this, paste it transposed here and advanced filter this and paste it here" kind of macro, but as it stands now, it repeats the code 60 times so it can handle 60 sets of data. As you can imagine, this is very slow.

If you need to see that code, i can post it, but i'd rather start from scratch on this one.

Thank yoU!

I want to write a macro to move certain records from one folder (tab)
to another. Here are the details:
I have a list of records in a folder named Official List. It's a list
that grows and shrinks in size every day. It extends from column A
through S. When a date is entered in column Q, it means that this
record can be moved to the other folder (named Deleted List), and
placed at the bottom of that list. I have named the header of column Q
"Taken_Date". (I prefer using named ranges, rather than row numbers or
column letters in case I change the design of my spreadsheets)
The range name of the column heading at the top left of the Deleted
List is called "Moved_To"
I hope this is clear enough. As always, I appreciate the help provided
from this group.

ALSO, I've always liked using the If-Then function in my spreadsheets.
But, I'm finding it hard to understand how to use this in VBA. I have a
book by John Walkenback, Power Programing with VBA, but it just doesn't
seem to address this powerful function enough. I've always thought the
If-Then function as a versatile tool, but maybe I'm bypassing better
functions to incorporate into my macros. I've been writing code just
for a few months, so if anyone has a suggestion on good resource
material, I would appreciate it.

Hi there,

I am looking for a macro to detect and hide blank rows.
I am using two tables in my worksheet.
The second table is only showing a value when the answer on
the if command in that table is positive.
However, I want the results in my second table nicely sorted out
without any blank lines between them.
What would be the best way to hide the empty lines?

Thanks in advance,

Mr.Clueless

Hello -
I'm not sure how to explain what I'm trying to do without showing you, so I will attach a bit of my document showing how the report comes out and how I want it to look; I'm looking for an automated way to reformat a canned report I receive several times per week. The canned report lists each record on 2 rows, with blank columns between rows. I want to make each record one row, moving the information from the 2nd row to one of the blank columns between data. These reports range from 10 records to 15000 records, so it can be very time-consuming to do by hand. Thank you so much for your help!

Can Anyone Tell me Please the Command to Move the Curser One Cell Down from
Any Cell as a Stating Point to Any Other Cell Without Using the Command for
Example - "Range ("A1") .Select" as this limits me to selecting this one cell
only. I need to Write a Formula That Will Find a Number in a Row Based on a
No. in One Perticular Cell.

My Idea is To Move Down a Cell at a time within a List of No.s and Loop
Until the Found Cell Matches the No. in a Reference Cell i.e. "Move Down
Until = A1" or "move Down One Cell at a time, End When Cell = A1" I'm sure
you get the gist of what I'm After,

Please Help

I have an invoice in Excel for billing my customers with over 100 total items
that I carry in my full inventory
I might only use 25 or so per invoice.
Currently eliminate the blank rows manually so I don't have to print all items
would like a macro to automatically not print any row(item) that has no value
Any help would be appreciated.

Hey Everyone,
I am trying to put together a macro to pull data from one tab to another. The key here is that I want it to take the entire row.

Basically it will look something like this:

As someone goes down the rows of the checklist putting x's in the boxes that need one (there is a column set aside for that), that box will turn red.

That part is easy and done.

What I cant figure out how to do next is to automatically have a copy made of the row with the red cell and send them to another document.

Anyone have any ideas???

Thanks for the help!

Aaron

Please help me,
I have a problem with this macro to move value to other specify sheet

please see attached file..

Thanks.


No luck finding an answer? You could always try Google.