Hi all
Need a little help with some VBA
In my work book I have a sheet called Items, in the sheet column A has a summery of items ordered, column B has the product code.
I would like to copy & paste both cells into the next available row in a sheet called print, if a cell in column A is >1 to produce a pick list.
thanks in advance
Nelly
Search the forum, this is requested at least once a week.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Try:
Please Login or Register to view this content.
Thanks John
Is it possible to paste values only rather than the formulas ?
Nelly
Maybe:
Please Login or Register to view this content.
You my friend are a STAR
Thank you for your help.
Nelly
You're welcome. Glad to help out and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks