Formula to range Value Data

H

howard

Well-known Member
Joined
Jun 26, 2006
Messages
6,570
Office Version
  1. 2021
Platform
  1. Windows
I would like to range value data in Col B:M on all sheets on the same row where the following text appears in Col A

Sales Achieved for the Month-New Equipment
Sales Achieved for the Month-Used Equipment
Sales Achieved for the Month-SVC Equipment
Sales Achieved for the Month-Admin Equipment

It would be appreciated if someone could assist me
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
You must log in or register to reply here.

Similar threads

zoharb
  • Question
Formula to calculate sales data as per conditions
Replies
0
Views
108
zoharb
zoharb
L
  • Solved
VBA help: how to set dynamic next available row
2
Replies
16
Views
796
Lil Stinker
L
P
  • Question
Summing Data based on a count of prior month data
2
Replies
12
Views
791
KRice
K
C
  • Solved
Updating a specific cell value in an autofiltered table
Replies
3
Views
295
skillilea
S
L
  • Question
Trying to determine if something is possible.
Replies
1
Views
199
frabulator
frabulator

Forum statistics

Threads
1,216,301
Messages
6,129,979
Members
449,548
Latest member
lharr28

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