- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to copy paste a formula column between two different tables
I have two tables coming from two similar files that vary in number of rows.
They share column names and I want to copy-paste formula columns from the old one to the new one.
There is no index I can use to join them.
How can I do that, ideally without JSL?
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to copy paste a formula column between two different tables
Copy Columns on first table (right click on column header and select Copy Columns) and Paste Columns on second table should work (right click somewhere on column header and select Paste Columns).
-Jarmo
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to copy paste a formula column between two different tables
Copy Columns on first table (right click on column header and select Copy Columns) and Paste Columns on second table should work (right click somewhere on column header and select Paste Columns).
-Jarmo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to copy paste a formula column between two different tables
Thanks. It didn't seem to work using the Edit menu. Clicking on the headers was the trick.