Excel workbook macro

somusas 0 Newbie Poster

8 Years Ago

i want a macro which can find the "$" select all the data and copy it to the next sheet
The dollar symbols are dynamic so 1st and 4th dollar symbol will be copied sheet 1, data between 4th and 5th will be copied to sheet2,data between 2nd and 3rd will be copied to sheet 3 , it should find the dollar symbols and then select the data copy it , one thing to again remember dollar symbols are dynamic , it varies workbook to workbook.but it have 5 dollar symbols inside the sheet

Please let me know am i clear.

regards
som

This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with zip files.

TaxCalculator.xlsx (16.05 KB)

1 Contributor
0 Replies
120 Views

Be the first to reply

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.