Update specific row in table with new data

**DixieLou** · 07-08-2020, 02:28 PM

I am hoping it's possible to create VBA code that will take the entries on "Update Device Info" E3:E15, copy them, then find the correct Equipment ID in the EquipmentList Table, and then transpose/paste the data into that row. If it makes a difference, Column E will not be visible to the user; I'm using it to collect the updates and combine them with fields that are not updating.

Sample file is attached.

Thank you!

**WideBoyDixon** · 07-08-2020, 05:11 PM

You don't need Column E - you can do this all in code like this:

Please Login or Register  to view this content.

WBD

Update specific row in table with new data

LinkBack

Thread Tools

Rate This Thread

Display

Update specific row in table with new data

Re: Update specific row in table with new data

Thread Information

Users Browsing this Thread

Similar Threads

why won't pivot table update with new rows added to data table even after pressing refresh

Detect the presence of data in specific cell range and update table in another sheet

Detect the presence of data in specific cell range and update table in another sheet

To paste specific data in specific columns and rows to specific table in powerpoint

[SOLVED] VLookup Question - If i update the lookup table i do not want to update old data

Copy data from one table and Clear and update new data into another table in another sheet

How to auto update the PowerPoint table when new data entered into Excel table?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions