Copy/Paste, Repeat until next

S

segran

Active Member
Joined
Aug 20, 2004
Messages
335
Hi,

I will like to know how to do the following:

<html><head><title>Excel Jeanie HTML</title></head><body>

<!-- ######### Start Created Html Code To Copy ########## -->

Excel Workbook
TU
3Column 1Column 2
4*QS1. Please select the school you expect to graduate from among
5QS1. Please select the school you expect to graduate from amongTOTAL
6QS1. Please select the school you expect to graduate from amongTOTAL ANSWERING
7QS1. Please select the school you expect to graduate from amongUniversity of California - Los Angeles
8QS1. Please select the school you expect to graduate from amongMIT (Massachusetts Institute of Technology)
9QS1. Please select the school you expect to graduate from amongPennsylvania State University
10QS1. Please select the school you expect to graduate from amongHarvard University
11QS2. From the following list, please select the major course ofQS2. From the following list, please select the major course of
12QS2. From the following list, please select the major course ofstudy that most closely reflects your degree.
13QS2. From the following list, please select the major course ofTOTAL
14QS2. From the following list, please select the major course ofTOTAL ANSWERING
15QS2. From the following list, please select the major course ofBusiness
16QS2. From the following list, please select the major course ofEngineering
Sheet1




<!-- ######### End Created Html Code To Copy ########## -->

</body></html>


Column 1 - the result I want to outputted
Column 2 is the data set

Search for QS in Column 2 dataset, and once QS is found, fill that in Column 1, until the next QS is found, and then fill in the QS into column 1.

Thank you
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

Dan Wilson
  • Solved
Help with Identifying Row numbers
2
Replies
15
Views
750
Dan Wilson
Dan Wilson
M
  • Question Question
Deleting unuse row before transfering into pdf
Replies
1
Views
286
NoSparks
N
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
L
  • Question Question
Selection based on two variables - copy and paste to another sheet
Replies
3
Views
391
kvsrinivasamurthy
K
P
  • Solved
Copy and cut from sheet 'Raised'
Replies
7
Views
415
Patriot2879
P

Forum statistics

Threads
1,224,599
Messages
6,179,831
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