Hi,
i have item Codes in ColumnA(A2:A500) and values in columnC (C2:C500)
i need to multiply whole range in C with given number inputed by user.
Additional to this, for few specified items (code: 123, 321, 231), the sign - or + needs to be converted -to+ or +to-
(i am thinking of going with the form of somekind)
Also, i need to format ColumnD with Text.
Can this be done?
thx in advance
Here are a couple of examples of code that will accomplish the first two items on your list. AS for column D, I'm not sure what you are after.
Please Login or Register to view this content.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
Originally Posted by pinstripe
Please Login or Register to view this content.Additional to this, for few specified items (code: 123, 321, 231), the sign - or + needs to be converted -to+ or +to-Please Login or Register to view this content.Also, i need to format ColumnD with Text.Please Login or Register to view this content.
Last edited by jindon; 11-10-2007 at 09:28 PM.
Since the multiplier is supplied by the user, it might be wise to put the product in its own column, so that the original numbers are preserved if the user changes their mind. (or bumps the Enter key when the multiplier = 0)
thank you guys ... that solved the problem.
now it looks so simple
@mikerickson i need the results in same column, so this is ok
thx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks