find last value in column and copy then paste to another sheet.
Basically i have column C and it has a formula copied throughout from cell 4 to 4500, when data is entered into the table and the formula does its magic a value is displayed in the relevant cell in column C. i want to find the last cell in column C with a value and copy this and then paste the value to another sheet not the formula. ive tried a few things but failed. HELP please.
Something like this..
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
Here's another way
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
sorry nither of these codes worked, im using excel 2000 if that makes a differance. ive attached an example file of what i want to happen.
could not get either code to work like i wanted, i have attached an example sheet to show what i would like to happen.
hi AZZ70, try this option, press Run button on Invoice sheet or run code "test"
TEST.xls
Not sure whats happened but when i try and move the code to my file it either throws up on error and the code or shows nothing. i have attached the following file with is yours just with all the formlas in and extened. on the saved file the data on the invoice tab is different to the payment tab becuase i forgot to change it back when testing.
Last edited by AZZ70; 09-23-2012 at 08:10 AM.
Try changing this. Also for Client 3 look at the Invoice and payment dates?
Please Login or Register to view this content.
Ok that seems to have fixed that thanks.
Thanks guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks