Re: Copy & Paste According to Reference
Thanks for the reply, the id columns are not included in the import so to match them I tried using string searching and using offset but I can't get the ids to match the reference numbers. This would be fairly simple if it was a static list, but since it is dynamic I can't search for these specific id's. Perhaps some grouping method? Or some better string searching?
Re: Copy & Paste According to Reference
Thanks for the reply, I didn't think it was important to include, all I did to go from source to after expanded is import the html code (column E) into internet explorer and export it back into excel as a table as well as some simple macro formatting.
Hi Community,
I have some data from a query which I expand upon, however after expanding it is missing some data from the source. Since the data is dynamic (from the query), I can't use a record macro function to copy and paste the missing values!
In the attached workbook I'm missing some data which can be found in the "source" sheet; specifically Id, travel end date, opportunity reference number and opportunity sequence number. I'm sorry if this is a little confusing so I attached a "expected result" to see what I mean!
Thank you!
Re: Transpose Vertical List?
Thanks again! You're a one man army :machineg:
Hi Community,
I'm sorry for posting again so soon, but I've ran into a new problem! I have a vertical clump of text that I'm trying to transpose to a horizontal list. I've attached an example workbook that has what I'm trying to do on a new sheet! I've tried transposing the entire column (column B) but it ends up with messy formatting because of the spacing between list items. Would appreciate any help!
Re: Delete Rows Between Repeating Cell Values
Thank you!! This is exactly what I needed, thank you! :dance:
Re: Delete Rows Between Repeating Cell Values
Sorry if this is double posting, but attached is 3 chunks of data with another sheet as my expected result. Big thanks to anyone that can help me with this VBA!
Re: Delete Rows Between Repeating Cell Values
Thanks for the reply, I'll gladly attach the worksheet but I won't have access to it until Monday :censored:, I'm sorry if this causes any inconvenience! I can make a "fake" version if needed that looks similar to my worksheet. Thanks again!
Hi Community,
This is a common question I know, I've been silently snooping around for an answer to my question but couldn't find one that fits my code, so here I am! I'm trying to delete rows between two varying ranges which sometime repeat (more on that later). I'm currently importing chunks of data into excel (column A only), each chunk of data starts with the text Substantial Shareholders and ends with the text Portfolio.
[TABLE="width: 568"]
Chunk 1:
Substantial Shareholders
Company Secretary
Fax No.
STUFF TO DELETE
STUFF TO DELETE
...
Portfolio
Chunk 2 - X:
Substantial Shareholders (may have multiple on top of each other, seperate rows)
Company Secretary
Fax No.
STUFF TO DELETE
STUFF TO DELETE
...
Portfolio
[TABLE="width: 568"]
From the above I need to delete starting from Fax No. to Substantial Shareholders in the next data chunk and repeat for all the remaining data chunks. However as mentioned earlier, sometimes there are more than one Substantial Shareholder meaning the code I'm using does not know where to stop. If I try using Portfolio + 1, it only loops through the first two chunks of data (doing what I want) but leaving the remaining chunks untouched. I'm sorry if this is a little confusing but I'm not sure how to get this done, I'd appreciate some help!
[/TABLE]
[/TABLE]
