Hi all
I'm hoping someone can assist me.
I'm not too good with excel, but i need to move data from the active sheet ('Invoice') to another sheet ('Existing customers').
The data that needs to be stored is Name, Address 1-3, postcode and the customer ID should increment.
I'm brand new on this forum and would really appreciate anyone being able to help me.
Thank you for taking the time to read my post.
Hi,
The way I always approach tasks like this is to use a helper row (hidden if required) that contains the data fields that you want, in the same order as that required on the destination sheet. The formulae in the helper row simply link directly to the relevant Invoice cell.
So for example in your case assuming you've added a new row 1, then A1 would be =C10, C1 would be =C14, (C14 now being the Name).
B1 would be the first ID number.
Give a range name to A1:G1, say "NewRecord"
Now your macro would be
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks