The table range may start from any cell in the sheet.
Hence i need a code to perform below task.
First find non blank cell in sheet "Item"
Copy the column till the last row, go to last column and +1 and paste.
Give 2 headings "% of claims" and "% of amount"
Calculate some formula in next columns.
I have given the required result in Sheet along with required formula "Result after code"
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
While copying to new column, do not copy "No. of Claims" (I know I have asked for it earlier. But now no need). Also heading format of % Claims and % Amount
to be same as other hadings. Also the multiplication formula should be vissible instead of values.
Simply I want the result same as "Result after code".
While copying to new column, do not copy "No. of Claims" (I know I have asked for it earlier. But now no need). Also heading format of % Claims and % Amount
to be same as other hadings. Also the multiplication formula should be vissible instead of values.
Simply I want the result same as "Result after code".
If you are going to use formulas, then there is not much point in using VBA. The code provided does the same task as the formulas and leaves the Sheet unincumbered by the formulas, thereby reducing the probability that someone will inadvertantly change or delete the formulas through editing.
Just wanted to check, It that possible to add one more column, as mentioned in Column K. if the amount is less than lakh, amount should be converted into numbers as mentioned in K11.
If the amout is grater than lakhs, it should convert in 2 decimal like as mentioned in K12. If it is more than 1 crore than mount should converted to 2 decimal as mentioned in K7.
In such way i wanted to make a sentence in column K.
I dont know whether it is possible or nor. Please advise.
Last edited by saravanan1981; 08-18-2019 at 09:55 AM.
Bookmarks