Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello -
I've been searching this forum for help and while I've found bits/pieces of useful code, I'm not sure how to put it all together. Here's what I need to do: ** find last column with data ** delete two columns, one column from the end - Ex if sheet has 10columns, delete #8 & 9 ** in the first blank column, insert fomula (starting 4th row down) and autofill to last row AND THEN one more row ** then total the values in two columns - Ex if sheet has 10col, total #6 & 7 ** copy/paste_values the inserted formulas Can you please help me build this code? Thanks! Ray |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Ray
I'll help you with it but I'm not clear on what you want. If you wish, send me your file or an example of your file. Include a step by step of what you want. Actual examples would be most useful. My email address is . Remove the "nop" from this address. HTH Otto "Ray" wrote in message oups.com... Hello - I've been searching this forum for help and while I've found bits/pieces of useful code, I'm not sure how to put it all together. Here's what I need to do: ** find last column with data ** delete two columns, one column from the end - Ex if sheet has 10columns, delete #8 & 9 ** in the first blank column, insert fomula (starting 4th row down) and autofill to last row AND THEN one more row ** then total the values in two columns - Ex if sheet has 10col, total #6 & 7 ** copy/paste_values the inserted formulas Can you please help me build this code? Thanks! Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto fill option | New Users to Excel | |||
I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
Fill handle formula | Excel Worksheet Functions | |||
How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) |