About Us

Don Guillett

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nick Wakeham" wrote in message
m...
Many thanks, That's exactly what I wanted

Nick

"Don Guillett" wrote in message
...
You don't say where the input data row is so I use row 2. You could
change to
Cells(activecell.row, "a").Resize(, 4).Value

This assumes that you are executing from the input sheet and are placing
the values of the formulas in the last row +1 of the destination sheet.
Notice the placement of the dots (look in the vba help index for WITH).

Sub copyinputlinetonextrow()
With Sheets("destinationsheetnamehere")
lr = .Cells(Rows.Count, "a").End(xlUp).Row + 1
.Cells(lr, "a").Resize(, 4).Value = _
Cells(2, "a").Resize(, 4).Value
End With
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nick Wakeham" wrote in message
m...
Using Excel 2007 - I have a workbook with two worksheets. The front
sheet has a list of headers along the top such as date and then some
data that is going to be filled in down the columns. The second sheet is
the work-out sheet with the formulas that is going to work out the
figures to go into the first sheet. However, what I want to do to make
it simple for the people using the sheet, is to have one simple line of
formulae that they type into each week and the solutions to those
formulae are then placed in the first sheet but in the next available
cell going down the rows. i.e. this week the solutions would go into Row
3 Columns A, B, C, D; next week they would go into Row 4 Columns A, B,
C, D - all this without them having to do anything other than type in
the data on the second sheet. I know all about the Worksheet! formula,
etc but it is the looking for the next blank row business that puzzles
me.

Is this possible?

Nick

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average Formula to display blank cell if named range is blank	Rachael F	Excel Worksheet Functions	3	February 22nd 08 05:05 PM
finding last non-blank cell and then copying it to the next cell	mike_vr	Excel Discussion (Misc queries)	0	January 17th 08 05:02 PM
Finding next non-blank cell	Stu[_2_]	Excel Discussion (Misc queries)	4	October 23rd 07 01:29 PM
Finding the bottom non-blank cell in a range	Fenneth	Excel Discussion (Misc queries)	7	July 6th 06 06:05 PM
finding blank cell and moving specific data into it	BeJay	Excel Worksheet Functions	1	May 30th 06 07:06 PM

Menu

About Us