hi,
i m unable to paste the row to the new sheet here is the code below:
Please Login or Register to view this content.
in this i have search for the last row filled
the row is then copied
the issue is that i have to paste it to the sheet naming "MasterSheet" but i m unable to do this.
please help.
Last edited by arlu1201; 04-12-2013 at 04:24 AM.
karanpreet,
Welcome to the forum!
Give this a try:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
hi,thanks for replying but it shows the error of subscript out of range.
thanks.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
If you are getting a subscript out of range issue, you need to check if your sheet is named as "MasterSheet". If not, change it in the code to reflect what your sheet name is.
done..thanks a lot .my mistake.
i want that column A should be of client name and it should fetch the name from the sheet from where it is copying the row. the cell to be fetched is cell D1 and should paste it to the "MasterSheet" column A
Can you post your entire code here so we can add in this portion?
here i want that while coping the row from any sheet to the "MasterSheet" it should copy the cell( D1) text as well to be placed at the column A of "MasterSheet".Please Login or Register to view this content.
thanks.but help me asap.
The code in post 9 is already copying to column A of Master sheet, so you better change that to B.
Then add thisChange the text sourcesheet to the name of the sheet from which you are copying.Please Login or Register to view this content.
the sourcesheet is not the only one sheet from where i m copying the row .it is active sheet .
my work is that the data of a client is present in the particular sheet.i want to copy the last row that contains the recent meeting with the client so to make it easy i want that the last row of each sheet should go on the sheet naming "MasterSheet" on which all recent info with client is to be put on .so last row contains the data starting from column B and copies well on the mastersheet but i want the client name as well to be put up on the COLUMN A on the mastersheet.
and whenever i add a new recent activity with the client in the specific client sheet it should change the recent info in the mastersheet of that particular client.
you get the requirements...is it ok?? please help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks