How to move the results from one row ro another

rajagopalanpb

New Member
Joined
Nov 21, 2008
Messages
34
Hi


I would like to have a VBA code to the following:Please note that the rows are dynamic and I need the results row for every customer.Currently it is totalling and displaying the results column at the botton of every customer but I need it at the start of every customer

1.When the new customer number starts the cells are shifted and moved one row.

2.Insert the results word and it displays the results thats displayed currently at the bottom,shoudl be displayed at the top where the row gets inserted in (1)

Current view:

Customer Date of POD Del date Diff Percent

123456 03.02.2009 03.02.2009 0 100
05.02.2009 10.02.2009 5 0
Result 0

(The result is that if all the rows are 100% ,the result row is 100% else it is 0%)

Preferred View:

Customer Date of POD Del date Diff Percent

123456 Result 0
03.02.2009 03.02.2009 0 100
05.02.2009 10.02.2009 5 0



I am new to Excel VBA and any help in this regard would be well appreciated

Thanks in advance for the help.

Raja
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
your requirements are not clear.

post a very small extract of your sheet and tell us what exactly you want.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,147
Messages
5,835,667
Members
430,373
Latest member
swartzfeger

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top