Forum Discussion

Qrew Member

3 years ago

Mass change multiple rows based on a filter

Hello I am in the process of creating a table by automatically uploading from SFTP server. Assume that I have a table with 1000 Customers X 10 Column with customer details. Say these 1000 custome...

Data import and export

AdityaBhandar

Qrew Member

Thank you for the reply Mark. Let me make it much simpler. Key field is customer #.

But, say I filtered on State=TX, and want to update Street Name of first 10 rows (customers).

Can I copy and paste from excel to update top 10 street names keeping all other fields the same?

------------------------------
Sivaram Bhandaru
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

Oh, you mean can you copy from Excel into Grid Edit? I don't have a Windows machine to test with, but I recall in the past that the native Microsoft Browsers "play nicely" with Microsoft Excel being copied into Grid Edit.

So try using Edge or what ever the Microsoft browser is a called these days and you can probably copy in column by column. You may also get it to work with Firefox, but I'm not sure. I guess what I am saying is that your ability to copy from excel into Grid Edit will be browser specific.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

AdityaBhandar
Qrew Member
3 years ago
Mark, I used both Edge and Chrome but it is same.

However, I tried select all -> Edit -> Copy from excel -> Right click on column in QB table -> Paste special->Paste and it worked.

Thank you!

------------------------------
Sivaram Bhandaru
------------------------------