[Macro] Dataset insert text for each row of data

H

Hyflex

New Member
Joined
Mar 28, 2011
Messages
40
Hi,

I have hundreds of datasets and I am looking for a way to do the following via the use of a macro

I need a macro to look for the word "Name" (will accur about 20-30 times)
I need it then to offset 1 down to the cell below
Now for each dataset IF there is data in that row it needs to go to Column G and input "List Complete"


x2P5O.png
 

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.
You must log in or register to reply here.

Similar threads

B
  • Question Question
VBA to Insert Column, Lookup to another workbook, return results.
Replies
1
Views
201
dermie_72
D
D
  • Question Question
Remove matching rows with pause function
Replies
1
Views
187
alansidman
A
R
  • Solved
VBA - Deduplicate a column without exact references
2
Replies
10
Views
410
Joe4
Joe4
Q
  • Question Question
Macro needed to insert 4 rows in table, copy data from above, copy data from another sheet and paste special (transpose values) to those new rows...re
Replies
1
Views
383
sijpie
sijpie
C
  • Solved
VBA macro: insert row if condition is met and apply formulae
Replies
3
Views
346
CXsjr
C

Forum statistics

Threads
1,224,600
Messages
6,179,836
Members
452,947
Latest member
Gerry_F

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