LinkBack URL
About LinkBacks
Can anyone help me with modifying my code to make the output appear in the same sheet? Thank you.
Please Login or Register to view this content.
Can anyone help me with modifying my code to make the output appear in the same sheet? Thank you.
Please Login or Register to view this content.
Try adding/changing these:
Please Login or Register to view this content.
I'm looking at replacing the whole sheet with the new set of data
Then I guess your best solution would be the original one, which outputs to a new worksheet, and then just simply delete your original source worksheet.
Is there really no way to sort of refresh the sheet with the new data?
Might be possible if you posted a sample workbook, people will need to look at how the data is displayed and then come up with a solution to treat it.
sample.xlsx
Attached is the sample workbook. Rename the sheet with Office_Metadata and make sure the name "Sheet1" is present if you're using the existing code. Thanks!
Try this code:
Please Login or Register to view this content.
Seems like the first set of data (first 10 rows, number may vary) is missing, the rest gets displayed
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)
To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Right, sorry did not look carefully into it. Try this amended code:Originally Posted by exlecel123
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks