Allocation a number to specific column

S

shahsavand

Board Regular
Joined
Dec 8, 2014
Messages
74
i want to allocate the extra quantity of column G to one of the (A to D) if they filled with a number.i just wanna add the extera number to one of those column not all of them.
i would be very grateful if anybody could help me with a VBA code.

[TABLE="width: 687"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]XS4020-34403
[/TD]
[TD]XS4020S-34503[/TD]
[TD]XS5020-34603[/TD]
[TD]XS5020S-34702[/TD]
[TD]TOTAL NEED[/TD]
[TD]Total RECEIVE[/TD]
[TD]EXTRA[/TD]
[/TR]
[TR]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]4012[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000
[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]12000[/TD]
[TD="align: right"]8000[/TD]
[/TR]
[TR]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]4216[/TD]
[TD="align: right"]216[/TD]
[/TR]
[TR]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]18000[/TD]
[TD="align: right"]8000[/TD]
[/TR]
[TR]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]12000[/TD]
[TD="align: right"]8000[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]2208[/TD]
[TD="align: right"]208[/TD]
[/TR]
[TR]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]2208[/TD]
[TD="align: right"]208[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]8000[/TD]
[/TR]
[TR]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]2304[/TD]
[TD="align: right"]304[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]2560[/TD]
[TD="align: right"]560[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]6000[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]2940[/TD]
[TD="align: right"]940[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]8000[/TD]
[/TR]
[TR]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3040[/TD]
[TD="align: right"]1040[/TD]
[/TR]
[TR]
[TD="align: right"]2000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"]40000[/TD]
[TD="align: right"]32000[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
You must log in or register to reply here.

Similar threads

A
  • Solved
Create accounts by user form to show balance by calculation for two columns
Replies
4
Views
107
abdo meghari
A
A
  • Solved
add formulas in last column after sorting for each duplicates ID
Replies
9
Views
126
Peter_SSs
Peter_SSs
A
  • Solved
insert column and autofill based on cell value
2
Replies
15
Views
170
mumps
mumps
A
  • Question Question
Merge partial character before specific word across sheets based on headers
Replies
3
Views
187
Amer Omar
A
O
  • Solved
Put amount in DEBIT,CREDIT columns based on matching part of item
Replies
9
Views
186
Omran Y
O

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

Share this page

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
Back
Top