Search : in
By :

Find the last filled cell and past data after

joe, on Oct 22, 2009 6:50:48 am BST 
 Report this message to moderators

Hello,

first of all thanks for solving my last query...it helped me a lot..

I have a new problem and the scenario is:

say cell a1:c1 has the heading as name, phone,id
and it goes down upto a5:c5(it can be more on different days) this is in sheet 1

now i have a similar data in sheet 2 having the same heading but different data.

what i require is a macro which would auto find the last filled cell in column a of sheet 1 and then copy the complete data from sheet 2 and paste from cell a6 onwards in sheet 1 as a5 is the last filled cell.


thanks in advance

Configuration: Windows XP Internet Explorer 6.0

Best answers for « find the last filled cell and past data after » in :
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Firefox - Finding the profile folder ShowFirefox - Finding the profile folder Windows 9x/Me : C:\Windows\Application Data\Mozilla\Firefox\Profiles\< Profile Name >\ or C:\Windows\Profiles\\Application Data\Mozilla\Firefox\Profiles\< Profile Name...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download Super Finder ShowAre you frustrated to use the research motor by default on Windows? And definitely use Super Finder. Super Finder is an alternative program to search and find files, files and other data easily and fast on your hard disk.For instance, Windows XP will...
Download Super Finder Show
Download Advanced XML Converter Show
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Spreadsheets - Data Entry ShowCell Content A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example...
Ask your question Reply
They need your help