hi
I have created a quotes spread sheet for hire of equipment, I have 3 individual worksheets for 3 separate peoples quotes, which include date, time, customer, description, and booked date, the 3 main worksheets, are 'currently on hire, off-hired, and sales, i want to create a drop down box at the end of each row of information, I need the dropdown box to remove the data from the individual worksheets and move it to the main worksheets chosen in the dropdown box.
Last edited by Davy Newbold; 12-07-2016 at 08:00 AM.
Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional. Thanks!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you.
Formulas cannot remove anything from other cells, you will need VBA for that.
Also, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
ive attached a file
surely someone knows how to do this?
I think what im trying to do is use macros in the form of a drop down box, but to move a row of data???
For members who may respond here, please note the contents of this earlier thread from Mr Newbold
In particular if you offer advice that he doesn't agree with you are quite likely to get a negative rep as I did.
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.
Are you being deliberately provocative in giving me another negative rep?
...for the record Mr N, that last post wasn't a rhetorical question.
Your response - or lack of response will determine your continued presence here.
I think you need to stop commenting on my posts, and trying to bully me
If this bickering continues, I shall close the thread.
For the record, Davy, awarding negative rep for a suggested solution or workaround that didn't suit you was out of order, and I am not surprised that Richard took umbrage. Please do not do that again. Remember that people are here to help you on a purely voluntary basis: please treat all of us with the respect we deserve. Thanks.
Please continue in this thread: http://www.excelforum.com/excel-prog...o-another.html
This now obsolete thread is closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks