[peteRabbit]

Hi, I am using Windows Vista. I have a process which begins with a certain web page that I want to copy colums of data from. I print it as an Adobe PDF, then I select the data I need, copy it, and open it in an Excel table. I need to repeat this task 7 times,adding data to my spreadsheet, and it works fine 6 times out of 7. The error is when the Excel table opens, many of the columns appear merged in to one row. In other words, it looks like 6 cells just became packed in to one, in each column. Then I waste time copying the row and inserting the copied data into a new row. I must remove the data I don't want in the cell, by process of elimination.

I'm kind of new to this...If I am not using the word 'merged' correctly, I'll understand.

Thank you!

[Zack Barresse]

Hi there, welcome to the board!

Yes, the data probably does come in merged. We can make this simpler though. Can you provide the website you get the data from, and what data you are getting from it exactly? Also, how do you put the data into your spreadsheet? Can you provide a sample? What version of Excel do you have? Are you going to be the only one running this? Will you always have an internet connection? We should be able to automate this entire process for you.